Migrating Amazon Redshift Users to BigQuery (MARUBQ) - Topología de laboratorio

 

Topología de laboratorio

Lab 1 - Provisioning and Managing Resources in BigQuery

  • Create datasets
  • Create internal and external tables
  • Control access to data
  • Share data
  • Monitor resource utilization

Lab 2 - Schema Migration to BigQuery

  • Understand data types in BigQuery
  • Define schemas in BigQuery
  • Partitioned and Clustered Tables
  • Nested and Repeated Fields

Lab 3 - Writing SQL for BigQuery

  • SELECT statements
  • DML statements
  • DDL statements
  • UDFs and Procedures