Migrating Snowflake Users to BigQuery (MSUBQ) - Lab Topology

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 in 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