Lightlines
By google

dbt-sf-to-bq-translator

google1.8k installs

Move your Snowflake dbt models to BigQuery.

What it does

Converts Snowflake dbt models into standardized BigQuery-compatible models while preserving dbt Jinja logic.

When to use it

Use when migrating Snowflake dbt pipelines or models to BigQuery, not for generic BigQuery queries or other source dialects.

How to use it

Give it a Snowflake dbt project; it writes BigQuery-compatible models and asks you to approve the result before handover.

What you provide

  • An existing project

Uses

Good to know

  • cannot be undone: Cloud Storage; gcloud configuration
  • acts without asking
  • works out of sight

Latest review

What you need · 6

The bundled migration script requires Python 3.11 or newer.

The bundled migration script declares pyyaml 6.0 or newer as a dependency.


Access · 6

This skill

Cloud Storage

Write

Deletes staging objects and uploads SQL (irreversible)

gcloud configuration

Write

Changes your active cloud configuration (irreversible)