Bigquery migration SQL translator vs Dbt sf to bq translator
Bigquery migration SQL translator is an open-source agent skill for databases. Dbt sf to bq translator is an open-source agent skill for databases.
- Bigquery migration SQL translator is best for translate an oracle pl/sql procedure into bigquery googlesql.
- Dbt sf to bq translator is best for migrate a folder of snowflake dbt models to bigquery on google cloud.
- What it is
- Bigquery migration SQL translator is an open-source agent skill for databases.Dbt sf to bq translator is an open-source agent skill for databases.
- Best for
- Translate an Oracle PL/SQL procedure into BigQuery GoogleSQLMigrate a folder of Snowflake dbt models to BigQuery on Google Cloud
- Kind
- SkillSkill
- Pricing
- Open sourceOpen source
- Platforms
- Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf, GooseClaude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf, Goose
- GitHub stars
- 24.4K24.4K
- Last commit
- Nov 2026Nov 2026
- License
- Apache-2.0Apache-2.0
- Open source
- Good for
- Translate an Oracle PL/SQL procedure into BigQuery GoogleSQL; Convert a batch of Teradata query files staged in a Cloud Storage bucket; Generate BigQuery table DDL from a Teradata metadata zip archiveMigrate a folder of Snowflake dbt models to BigQuery on Google Cloud; Convert Snowflake colon-notation JSON lookups into BigQuery JSON_VALUE calls; Clean up Snowflake-specific config and hook settings in dbt models before running on BigQuery
What Bigquery migration SQL translator does
Interactive query translation
Translates a single query, polls the job and reviews logs and output SQL.
Batch file translation
Runs multi-file translations from Cloud Storage and reads the consolidated report.
Metadata DDL generation
Produces target BigQuery schema definitions from a database metadata zip.
Error effect triage
Groups issues by correctness, completeness and compatibility to fix them in order.
Dialect gotcha checks
Checks output against known pitfalls for Teradata, Oracle and Snowflake.
YAML configuration support
Guides renaming, schema redirection, partitioning and optimizer settings.
What Dbt sf to bq translator does
Snowflake to BigQuery SQL translation
Converts Snowflake dbt SQL models into Standardized BigQuery SQL using the BigQuery Translation Service.
Jinja placeholder masking
Replaces ref and source macros with placeholders before translation and restores them afterward.
Config block cleanup
Strips Snowflake-only config parameters and removes invalid Snowflake commands from hooks.
JSON and STRUCT extraction rewrites
Replaces colon notation and JSON lookups with BigQuery JSON functions or dot notation for STRUCT columns.
Explicit casting and deduplication
Applies explicit type casts and row_number-based deduplication with QUALIFY where the source requires it.
Bundled migration script
A Python script runs the end-to-end upload, translation, download and post-processing workflow.
Bigquery migration SQL translator vs Dbt sf to bq translator: questions
Is Bigquery migration SQL translator or Dbt sf to bq translator cheaper?
Both are open source. Compare current plans on each official site.
What is the difference between Bigquery migration SQL translator and Dbt sf to bq translator?
Bigquery migration SQL translator is an open-source agent skill for databases. Dbt sf to bq translator is an open-source agent skill for databases.
