Individual skill
bigquery-migration-sql-translator
Translates SQL queries, DDL schemas, and stored procedures from legacy database dialects (Teradata, Oracle, Redshift, Snowflake, SparkSQL, HiveQL) to BigQuery GoogleSQL using the BigQuery Migration Service (BQMS) MCP server. Use when translating legacy SQL queries, migrating schemas or metadata zip archives, or configuring BigQuery Migration Service (BQMS) YAML translation settings. Don't use for executing BigQuery queries or managing datasets and tables (use bigquery-basics), diagnosing runtime job errors (use bigquery-troubleshooting), or tuning slot reservations (use bigquery-optimization).
skills/cloud/bigquery-migration-sql-translator/SKILL.md
Source commit 496fbede89dac1faf0d180a936bfc472b6fbf886
What was checked
- Matches the observed repository HEAD
- Yes
- Scanner rules are current
- No
- Repository scan complete
- No
- Skill scan complete
- No
- Observed behavior
- Not checked yet
- Last checked
- Nov 4, 2026
These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.
Install this skill
Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.
An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.
Repository context
- Repository stars (not skill ratings)
- 23,652
- Repository last updated
- Nov 7, 2026
- License
- Apache-2.0
Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.
- google Repository topic
- googlecloud Repository topic
- skills Repository topic
- data Derived category
- data-databases Derived category
Files and excerpt
File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.
Browse files
SKILL.mdcore · 16,335 bytesSKILL.mdcore · 16,335 bytesSKILL.mdcore · 16,335 bytesSKILL.mdcore · 16,335 bytesSKILL.mdcore · 16,335 bytesSKILL.mdcore · 16,335 bytesSKILL.mdcore · 16,335 bytesSKILL.mdcore · 16,335 bytesSKILL.mdcore · 16,335 bytesSKILL.mdcore · 16,335 bytesSKILL.mdcore · 16,335 bytesSKILL.mdcore · 16,335 bytesassets/python_embedded_sql_migrator_template.pyruns · 42,785 bytesassets/translation_config_examples/environment_example.yamlasset · 167 bytesassets/translation_config_examples/experimental_input_formats_example.yamlasset · 213 bytesassets/translation_config_examples/experimental_metadata_example.yamlasset · 147 bytesassets/translation_config_examples/experimental_object_rewriter_example.yamlasset · 1,541 bytesassets/translation_config_examples/experimental_optimizer_example.yamlasset · 348 bytesassets/translation_config_examples/experimental_statement_rewriter_example.yamlasset · 400 bytesassets/translation_config_examples/input_formats_example.yamlasset · 200 bytesassets/translation_config_examples/metadata_example.yamlasset · 168 bytesassets/translation_config_examples/object_rewriter_example.yamlasset · 673 bytesassets/translation_config_examples/optimizer_example.yamlasset · 335 bytesassets/translation_config_examples/statement_rewriter_example.yamlasset · 387 bytesassets/translation_config_schemas/environment.jsonasset · 498 bytesassets/translation_config_schemas/experimental_input_formats.jsonasset · 976 bytesassets/translation_config_schemas/experimental_metadata.jsonasset · 629 bytesassets/translation_config_schemas/experimental_object_rewriter.jsonasset · 19,961 bytesassets/translation_config_schemas/experimental_optimizer.jsonasset · 635 bytesassets/translation_config_schemas/experimental_statement_rewriter.jsonasset · 1,292 bytesassets/translation_config_schemas/input_formats.jsonasset · 963 bytesassets/translation_config_schemas/metadata.jsonasset · 876 bytesassets/translation_config_schemas/object_rewriter.jsonasset · 9,376 bytesassets/translation_config_schemas/optimizer.jsonasset · 622 bytesassets/translation_config_schemas/statement_rewriter.jsonasset · 1,279 bytesassets/translation_config_schemas/transpiler_config_spec.jsonasset · 39,803 bytesreferences/attribution.mddoc · 1,951 bytesreferences/effect_compatibility.mddoc · 2,346 bytesreferences/effect_completeness.mddoc · 5,225 bytesreferences/effect_correctness.mddoc · 8,819 bytesreferences/mcp_config.mddoc · 10,246 bytesreferences/oracle_gotchas.mddoc · 3,223 bytesreferences/snowflake_gotchas.mddoc · 7,591 bytesreferences/teradata_gotchas.mddoc · 2,474 bytesreferences/translation_yaml_config.mddoc · 12,629 bytes
Read excerpt
# BigQuery Migration Service (BQMS) SQL Translator
The BigQuery Migration Service (BQMS) translates legacy database SQL scripts,
queries, and schemas into GoogleSQL. This skill coordinates translation
workflows, Cloud Storage staging, compiler error triage, and YAML configuration.
## Usage Attribution
**MUST READ**: Before executing any `gcloud`, REST API, or MCP command, you
MUST read and follow the instructions in
[Usage Attribution](references/attribution.md).
## Before you begin
