Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Pengantar BigQuery Migration Service
Dokumen ini memberikan ringkasan BigQuery Migration Service.
BigQuery Migration Service adalah solusi komprehensif untuk memigrasikan data
warehouse Anda ke BigQuery. Solusi ini mencakup fitur yang membantu Anda di
setiap fase migrasi, termasuk penilaian dan perencanaan, terjemahan SQL untuk
berbagai dialek SQL,
transfer data, dan validasi data. Bersama-sama, alat-alat ini membantu Anda mempercepat migrasi dan mengurangi risiko, sehingga mempersingkat waktu untuk mewujudkan nilai.
BigQuery Migration Service mencakup fitur berikut:
Penilaian migrasi BigQuery: Menilai dan merencanakan migrasi data warehouse Anda dengan menjalankan penilaian migrasi BigQuery.
Alat terjemahan SQL: Alat terjemahan mengotomatiskan konversi kueri SQL Anda ke dalam GoogleSQL, termasuk penyesuaian SQL yang ditingkatkan Gemini. Anda dapat menggunakan penerjemah SQL batch untuk memigrasikan skrip SQL secara massal, atau penerjemah SQL interaktif untuk menerjemahkan kueri individual. Anda juga dapat menggunakan SQL Translation API
untuk memigrasikan beban kerja ke BigQuery.
Anda juga dapat menggunakan alat open source berikut untuk membantu proses migrasi:
Alat migrasi data: Gunakan alat migrasi
data untuk mengotomatiskan
migrasi data warehouse Anda ke BigQuery. Alat ini menggunakan
BigQuery Data Transfer Service, layanan terjemahan BigQuery, dan
alat validasi data untuk mentransfer data, menerjemahkan dan memvalidasi kueri DDL, DML,
dan SQL.
Alat validasi data: Setelah memigrasikan data ke BigQuery, jalankan alat validasi data untuk memvalidasi bahwa tabel sumber dan tujuan Anda cocok.
Pemeta izin BigQuery: Gunakan pemeta izin untuk mengotomatiskan pembuatan dan pemeliharaan peta izin yang dapat diubah pengguna.
Anda dapat menggunakan pemeta izin untuk menganalisis dan menyelaraskan izin dan grup pengguna duplikat, sekaligus membuat laporan error. Alat ini menghasilkan skrip JSON dan Terraform untuk pembuatan grup, pengguna, dan binding BigQuery.
Template Cloud Composer: Gunakan template Cloud Composer untuk menyederhanakan pembuatan DAG Airflow baru atau migrasi tugas terorkestrasi yang ada dari lokal ke cloud.
Cloud Foundation Fabric: Lihat contoh dan modul Terraform untuk
Google Cloud,
termasuk blueprint zona landing di seluruh organisasi, blueprint referensi
untuk pola jaringan dan fitur produk, serta library modul yang dapat disesuaikan.
Kuota
Kuota dan batas berlaku untuk jumlah tugas serta ukuran file.
Untuk mengetahui informasi lebih lanjut tentang kuota dan batas layanan migrasi, lihat
Kuota dan batas.
Harga
Penggunaan BigQuery Migration API tidak dikenai biaya. Namun, penyimpanan yang digunakan untuk
file input dan output dikenakan biaya normal. Untuk mengetahui informasi selengkapnya, lihat
Harga penyimpanan.
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 2025-09-04 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)."]]