Skip to content

Bigquery pipeline audit vs Dbt sf to bq translator

Bigquery pipeline audit is an open-source agent skill for databases. Dbt sf to bq translator is an open-source agent skill for databases.

  • Bigquery pipeline audit has more GitHub stars (41,254 vs 24,379).
  • Bigquery pipeline audit is best for review a backfill script before running it on production.
  • Dbt sf to bq translator is best for migrate a folder of snowflake dbt models to bigquery on google cloud.
What it is
Bigquery pipeline audit is an open-source agent skill for databases.
Dbt sf to bq translator is an open-source agent skill for databases.
Best for
Review a backfill script before running it on production
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
41.3K
24.4K
Last commit
Nov 2026
Nov 2026
License
MIT
Apache-2.0
Open source
Good for
Review a backfill script before running it on production; Find unbounded BigQuery spend in a nightly job; Make a pipeline safe to re-run without duplicate rows
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 pipeline audit does

  • Cost exposure check

    Counts BigQuery jobs and external calls, and checks maximum bytes billed.

  • Dry-run modes

    Looks for dry_run and execute modes with a prod confirmation.

  • Backfill review

    Flags per-date query loops and suggests set-based alternatives.

  • Scan safety

    Checks partition filters, SELECT * and join fan-out.

  • Idempotent writes

    Checks for MERGE, staging swaps or dedupe views and a sound dedupe key.

  • Structured verdict

    Returns pass or fail per section, ordered patches and top cost risks.

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 pipeline audit vs Dbt sf to bq translator: questions

Is Bigquery pipeline audit or Dbt sf to bq translator cheaper?

Both are open source. Compare current plans on each official site.

What is the difference between Bigquery pipeline audit and Dbt sf to bq translator?

Bigquery pipeline audit is an open-source agent skill for databases. Dbt sf to bq translator is an open-source agent skill for databases. Bigquery pipeline audit has more GitHub stars (41,254 vs 24,379).