Migrating Snowflake Users to BigQuery (MSUBQ) – Outline

Outline detalhado do curso

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