dbt-sf-to-bq-translator
Translates Snowflake dbt SQL models to Standardized BigQuery SQL
by googleFree
Description
dbt Snowflake to BigQuery translator is an agent skill for migrating dbt models from Snowflake SQL to standardized BigQuery SQL on Google Cloud. It handles the dialect translation, then enforces Google-specific standards on each output file: a copyright header at the top, explicit type casting, standardized JSON extraction, and deduplication with QUALIFY over the _extracted_at column. It also preserves dbt Jinja constructs and stores the final BigQuery-compatible models in the project. The skill covers SQL compilation and masks Jinja macro placeholders while the translation runs, so the logic is translated without breaking the macros. It works from a migration plan. The agent follows the instructions in a tasks file under a migration plan folder, records its progress and a final summary there so a human supervisor can track it, and recovers from errors by reading that file. The skill is intended for data engineering teams moving a dbt project from Snowflake to BigQuery who want a reviewable, resumable migration rather than a one-off conversion. It is published by Google on skills.sh under the google skills repository, with about 1.9K installs. The skills.sh listing shows Gen Agent Trust Hub and Snyk passing, with Socket showing Warn.…
Highlights
- Translates Snowflake dbt SQL to BigQuery SQL
- Preserves dbt Jinja constructs
- Enforces copyright headers and explicit casting
- Deduplication with QUALIFY on _extracted_at
- Progress tracked in a migration tasks file
Ratings & Reviews
No ratings yet
Be the first to rate dbt-sf-to-bq-translator.
People also visit
bigquery-observability
Provides data-retrieval best practices, tool selection guidance
bigquery-slot-cost-optimizer
Analyzes Google Cloud BigQuery slot consumption, query costs
gke-cost-analysis
Answer natural language questions and perform analysis on GKE cluster
dbt-sf-to-bq-translator FAQ
What does the skill do?
It translates dbt models from Snowflake SQL to standardized BigQuery SQL and stores them in the project.
Does it keep my Jinja macros?
Yes. It preserves dbt Jinja constructs and masks macro placeholders during translation.
How is progress tracked?
The agent records progress and a final summary in the migration tasks file, which a human supervisor can read and which it uses to recover from errors.
What standards does it apply?
A copyright header at the top of each file, explicit type casting, standardized JSON extraction, and deduplication with QUALIFY over _extracted_at.
How do I install it?
Run npx skills add https://github.com/google/skills --skill dbt-sf-to-bq-translator.
What are the best dbt-sf-to-bq-translator alternatives?
Popular alternatives to dbt-sf-to-bq-translator include bigquery-bigframes, bigquery-observability and bigquery-slot-cost-optimizer. See all dbt-sf-to-bq-translator alternatives