Skip to content

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 GoogleSQL
Migrate a folder of Snowflake dbt models to BigQuery on Google Cloud
Kind
Skill
Skill
Pricing
Open source
Open source
Platforms
Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf, Goose
Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf, Goose
GitHub stars
24.4K
24.4K
Last commit
Nov 2026
Nov 2026
License
Apache-2.0
Apache-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 archive
Migrate 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.

Keep comparing