Introduction to BigQuery Migration Service

This document provides an overview of the BigQuery Migration Service.

The BigQuery Migration Service is a comprehensive solution for migrating your datawarehouse to BigQuery. It includes features that help you witheach phase of migration, including assessment and planning, SQL translation fora variety of SQL dialects,data transfer, and data validation. Together, these services help you acceleratemigrations and reduce risk, shortening the time to value.

The BigQuery Migration Service includes the following features:

• BigQuery migration assessment: Assess and plan your data warehouse migration byrunning aBigQuery migration assessment.
• SQL translation services: The translation services automate the conversion ofyour SQL queries into GoogleSQL, including Gemini-enhancedSQL customization. You can use thebatch SQLtranslator to migrate your SQL scriptsin bulk, or theinteractive SQL translatorto translate individual queries. You can also use theSQL translation APIto migrate your workloads to BigQuery.
• BigQuery Data Transfer Service: Set up a data transfer that loads data from yourdata source to BigQuery. For more information, seeWhat is the BigQuery Data Transfer Service?.

You can also use the following open-source tools to help you with your migration process:

• Data migration tool: Use thedata migrationtool to automateyour data warehouse migration to BigQuery. The tool uses theBigQuery Data Transfer Service, the BigQuery translation services, andthe data validation tool to transfer data, translate and validate DDL, DML,and SQL queries.
• Data validation tool: After migrating your data toBigQuery, run thedata validationtoolto validate that your source and destination tables match.
• BigQuery permission mapper: Use thepermissionmapperto automate the creation and maintenance of user-modifiable permission maps.You can use the permission mapper to analyze and reconcile duplicatepermissions and user groups, while also generating error reports. The tooloutputs JSON and Terraform scripts for BigQuery group, user,and binding creation.
• Cloud Composer templates: UseCloud Composertemplatesto simplify the creation of new Airflow DAGs or the migration of existingorchestrated jobs from on-premise to the cloud.
• Cloud Foundation Fabric: ViewTerraform examples and modules forGoogle Cloud,including an organization-wide landing zone blueprint, reference blueprintsfor network patterns and product features, and a library of adaptable modules.

Quotas

Quotas and limits apply to the number of jobs as well as the size of files.For more information on migration service quotas and limits, seeQuotas and limits.

Pricing

There is no charge to use the BigQuery Migration API. However, storage used forinput and output files incurs the normal fees. For more information, seeStorage pricing.

Additionally, you can use thecost estimation functionality in Google Cloud Migration Centerto generate a cost estimate of running your data warehouse setup that youmigrate to BigQuery. For more information, seeStart a cost estimation andSpecify data warehousing requirements.

What's next

• For more information on batch SQL translator, seeBatch SQL translator.
• For more information on using the interactive SQL translator, seeInteractive SQL translator.
• For more information on BigQuery migration assessment, seeBigQuery migration assessment.
• Learn about theData Validation Tool.
• For information about quotas and limits for the BigQuery Migration Service, seeQuotas and limits.