Learn more about BigQuery Migration Service → https://goo.gle/BigQuery-Migration-Service
Following your migration assessment, it is time to execute the transfer of your data and SQL queries into Google Cloud. This video dives into the specific tools and services that simplify migrating workloads from Snowflake, Teradata, Cloudera, and Databricks into BigQuery, Dataproc, and Google Cloud Storage.
Learn how to leverage the power of Gemini and automated SQL translation services to convert complex dialects into BigQuery compatible Google SQL. We also explore the BigQuery Data Transfer Service (DTS) for both full on demand and incremental migrations and additional migration tools, ensuring your transition is cost effective and optimized for performance.
Resources:
Schema mapping configuration YAML for Snowflake → https://goo.gle/snowflake-schema-mapping-config
Custom schema for Teradata → https://goo.gle/teradata-custom-schema-file
BigLake tables for Apache Iceberg in BigQuery (aka fully managed Iceberg tables) → https://goo.gle/biglake-tables-iceberg-bigquery
Create Apache Iceberg external tables (aka self managed Iceberg tables) → https://goo.gle/create-apache-iceberg-external
BigLake external Parquet tables → https://goo.gle/create-storage-external-tables-bigquery
Spark ‘register_table’ Procedure for manual Iceberg data copies → https://goo.gle/48IAwkq
Subscribe to Google Cloud Tech → https://goo.gle/GoogleCloudTech
#GoogleCloud #BigQuery #DataMigration
Speakers: Lucia Subatin
Products Mentioned: BigQuery, BigQuery Migration Service, Cloud Storage
