Migrating Snowflake Users to BigQuery (MSUBQ) – Outline

Detailed Course Outline

Module 1 - Understanding BigQuery Architecture

• Quick reminder of Snowflake architecture
• Overview of BigQuery architecture
• Separation of compute and storage in BigQuery
• BigQuery Slots
• Workload management in BigQuery

Module 2 - Creating Datasets and Tables in BigQuery

• Resource Hierarchy in Snowflake
• Resource Hierarchy in BigQuery
• Creating resources in BigQuery
• Sharing resources in BigQuery
• Lab: Provisioning and Managing Resources in BigQuery

Module 3 - Mapping Data Types

• How data types map from Snowflake to BigQuery
• Understand data types unique to BigQuery

Module 4 - Schema Mapping and Optimization

• Schema definitions in BigQuery
• Partitioning in BigQuery
• Clustering in BigQuery
• Lab: Schema Migration to BigQuery

Module 5 - SQL Translation from Snowflake to BigQuery

• SELECT statements
• DML statements
• DDL statements
• UDFs and Procedures
• Lab: Writing SQL for BigQuery