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 productionMigrate 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
- 41.3K24.4K
- Last commit
- Nov 2026Nov 2026
- License
- MITApache-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 rowsMigrate 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).

