BigQuery 마이그레이션 서비스는 데이터 웨어하우스를 BigQuery로 마이그레이션하기 위한 포괄적인 솔루션입니다. 평가 및 계획, 10개 이상의 언어에 대한 SQL 변환, 데이터 전송, 데이터 검증을 포함한 각 마이그레이션 단계를 지원하는 도구가 무료로 제공됩니다.
이러한 도구를 함께 사용하면 마이그레이션을 가속화하고 위험을 줄여 더욱 빠르게 가치를 창출할 수 있습니다.
평가 및 계획 단계에서 BigQuery 마이그레이션 평가 기능을 사용하면 기존 데이터 웨어하우스를 이해할 수 있습니다. 그런 다음 일괄 SQL 변환기 및 대화형 SQL 변환기를 사용하여 BigQuery에서 작업할 SQL 쿼리 및 스크립트를 준비하면 됩니다. 일괄 및 대화형 SQL 변환기는 다양한 SQL 언어를 통한 변환을 지원합니다.
데이터를 이동할 준비가 되면 BigQuery Data Transfer Service를 사용하여 데이터 웨어하우스에서 BigQuery로의 마이그레이션을 자동화하고 관리할 수 있습니다. 데이터를 마이그레이션한 후 데이터 검증 도구를 사용하여 마이그레이션이 성공했는지 검증할 수 있습니다.
할당량
할당량 및 한도는 작업 수와 파일 크기에 적용됩니다.
마이그레이션 서비스 할당량 및 한도에 대한 자세한 내용은 할당량 및 한도를 참조하세요.
가격 책정
BigQuery Migration API는 무료로 사용할 수 있습니다. 그러나 입력 및 출력 파일에 사용되는 스토리지에는 일반 요금이 발생합니다. 자세한 내용은 스토리지 가격 책정을 참조하세요.
[[["이해하기 쉬움","easyToUnderstand","thumb-up"],["문제가 해결됨","solvedMyProblem","thumb-up"],["기타","otherUp","thumb-up"]],[["이해하기 어려움","hardToUnderstand","thumb-down"],["잘못된 정보 또는 샘플 코드","incorrectInformationOrSampleCode","thumb-down"],["필요한 정보/샘플이 없음","missingTheInformationSamplesINeed","thumb-down"],["번역 문제","translationIssue","thumb-down"],["기타","otherDown","thumb-down"]],["최종 업데이트: 2025-07-14(UTC)"],[[["\u003cp\u003eBigQuery Migration Service offers a full suite of tools for data warehouse migration, covering assessment, SQL translation, data transfer, and validation.\u003c/p\u003e\n"],["\u003cp\u003eThe service includes both batch and interactive SQL translators that support multiple SQL dialects, aiding in the preparation of queries and scripts for BigQuery.\u003c/p\u003e\n"],["\u003cp\u003eThe BigQuery Data Transfer Service streamlines and manages the data migration process from existing data warehouses to BigQuery.\u003c/p\u003e\n"],["\u003cp\u003eThere is no direct cost to use the BigQuery Migration API itself, but standard storage fees apply for input and output files.\u003c/p\u003e\n"],["\u003cp\u003eUsers can estimate the cost of running their migrated data warehouse setup on BigQuery using the cost estimation functionality in Google Cloud Migration Center.\u003c/p\u003e\n"]]],[],null,["# Introduction to BigQuery Migration Service\n==========================================\n\nThis document provides an overview of the BigQuery Migration Service.\n\nThe BigQuery Migration Service is a comprehensive solution for migrating your data\nwarehouse to BigQuery. It includes features that help you with\neach phase of migration, including assessment and planning, SQL translation for\n[a variety of SQL dialects](/bigquery/docs/interactive-sql-translator#supported_sql_dialects),\ndata transfer, and data validation. Together, these tools help you accelerate\nmigrations and reduce risk, shortening the time to value.\n\nThe BigQuery Migration Service includes the following features:\n\n- **BigQuery migration assessment** : Assess and plan your data warehouse migration by running a [BigQuery migration assessment](/bigquery/docs/migration-assessment).\n- **SQL translation tools** : The translation tools automate the conversion of your SQL queries into GoogleSQL, including Gemini-enhanced SQL customization. You can use the [batch SQL\n translator](/bigquery/docs/batch-sql-translator) to migrate your SQL scripts in bulk, or the [interactive SQL translator](/bigquery/docs/interactive-sql-translator) to translate individual queries. You can also use the [SQL translation API](/bigquery/docs/api-sql-translator) to migrate your workloads to BigQuery.\n- **BigQuery Data Transfer Service** : Set up a data transfer that loads data from your data source to BigQuery. For more information, see [What is the BigQuery Data Transfer Service?](/bigquery/docs/dts-introduction).\n\nYou can also use the following open-source tools to help you with your migration process:\n\n- **Data migration tool** : Use the [data migration\n tool](https://github.com/GoogleCloudPlatform/data-migration-tool) to automate your data warehouse migration to BigQuery. The tool uses the BigQuery Data Transfer Service, the BigQuery translation services, and the data validation tool to transfer data, translate and validate DDL, DML, and SQL queries.\n- **Data validation tool** : After migrating your data to BigQuery, run the [data validation\n tool](https://github.com/GoogleCloudPlatform/professional-services-data-validator) to validate that your source and destination tables match.\n- **BigQuery permission mapper** : Use the [permission\n mapper](https://github.com/GoogleCloudPlatform/professional-services-bigquery-permission-mapper) to automate the creation and maintenance of user-modifiable permission maps. You can use the permission mapper to analyze and reconcile duplicate permissions and user groups, while also generating error reports. The tool outputs JSON and Terraform scripts for BigQuery group, user, and binding creation.\n- **Cloud Composer templates** : Use [Cloud Composer\n templates](https://github.com/GoogleCloudPlatform/professional-services-composer-templates) to simplify the creation of new Airflow DAGs or the migration of existing orchestrated jobs from on-premise to the cloud.\n- **Cloud Foundation Fabric** : View [Terraform examples and modules for\n Google Cloud](https://github.com/GoogleCloudPlatform/cloud-foundation-fabric), including an organization-wide landing zone blueprint, reference blueprints for network patterns and product features, and a library of adaptable modules.\n\nQuotas\n------\n\nQuotas and limits apply to the number of jobs as well as the size of files.\nFor more information on migration service quotas and limits, see\n[Quotas and limits](/bigquery/quotas#migration-api-limits).\n\nPricing\n-------\n\nThere is no charge to use the BigQuery Migration API. However, storage used for\ninput and output files incurs the normal fees. For more information, see\n[Storage pricing](/bigquery/pricing#storage).\n\nAdditionally, you can use the [cost estimation functionality in Google Cloud Migration Center](/migration-center/docs/migration-center-overview)\nto generate a cost estimate of running your data warehouse setup that you\nmigrate to BigQuery. For more information, see\n[Start a cost estimation](/migration-center/docs/estimate/start-estimation) and\n[Specify data warehousing requirements](/migration-center/docs/estimate/specify-datawarehouse-requirements).\n\nWhat's next\n-----------\n\n- For more information on batch SQL translator, see [Batch SQL translator](/bigquery/docs/batch-sql-translator).\n- For more information on using the interactive SQL translator, see [Interactive SQL translator](/bigquery/docs/interactive-sql-translator).\n- For more information on BigQuery migration assessment, see [BigQuery migration assessment](/bigquery/docs/migration-assessment).\n- Learn about the [Data Validation Tool](https://github.com/GoogleCloudPlatform/professional-services-data-validator#data-validation-tool).\n- For information about quotas and limits for the BigQuery Migration Service, see [Quotas and limits](/bigquery/quotas#migration-api-limits)."]]
