MSUBQGOGoogleGO-MSUBQ1.0<ul> <li>Compare architecture and provisioning of resources in Snowflake and BigQuery</li><li>Configure datasets and tables in BigQuery</li><li>Map and compare data types in Snowflake to data types in BigQuery</li><li>Map and optimize schemas from Snowflake to BigQuery</li><li>Translate SQL from Snowflake to BigQuery</li></ul><p>None.</p><p>Current users of Snowflake (Data Engineers, Data Analysts, Data Scientists, Application Developers) migrating to BigQuery.</p><h4>Module 1 - Understanding BigQuery Architecture</h4><ul> <li>Quick reminder of Snowflake architecture</li><li>Overview of BigQuery architecture</li><li>Separation of compute and storage in BigQuery</li><li>BigQuery Slots</li><li>Workload management in BigQuery</li></ul><h4>Module 2 - Creating Datasets and Tables in BigQuery</h4><ul> <li>Resource Hierarchy in Snowflake</li><li>Resource Hierarchy in BigQuery</li><li>Creating resources in BigQuery</li><li>Sharing resources in BigQuery</li><li>Lab: Provisioning and Managing Resources in BigQuery</li></ul><h4>Module 3 - Mapping Data Types</h4><ul> <li>How data types map from Snowflake to BigQuery</li><li>Understand data types unique to BigQuery</li></ul><h4>Module 4 - Schema Mapping and Optimization</h4><ul> <li>Schema definitions in BigQuery</li><li>Partitioning in BigQuery</li><li>Clustering in BigQuery</li><li>Lab: Schema Migration to BigQuery</li></ul><h4>Module 5 - SQL Translation from Snowflake to BigQuery</h4><ul> <li>SELECT statements</li><li>DML statements</li><li>DDL statements</li><li>UDFs and Procedures</li><li>Lab: Writing SQL for BigQuery</li></ul>- Compare architecture and provisioning of resources in Snowflake and BigQuery - Configure datasets and tables in BigQuery - Map and compare data types in Snowflake to data types in BigQuery - Map and optimize schemas from Snowflake to BigQuery - Translate SQL from Snowflake to BigQueryNone.Current users of Snowflake (Data Engineers, Data Analysts, Data Scientists, Application Developers) migrating to BigQuery.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 BigQuery1 jour595.00850.00660.00950.00950.00950.00790.00