domains / families / data / dbt-sf-to-bq-translator

dbt-sf-to-bq-translator

separate

Translates Snowflake dbt SQL models to Standardized BigQuery SQL. Handles SQL compilation, Jinja macro placeholder masking, BigQuery Translation Service migration workflows, AST-based config transformations, explicit type casting, JSON extraction standardization, and deduplication. Use when migrating Snowflake dbt pipelines or models to BigQuery on Google Cloud. Don't use for generic BigQuery queries or non-Snowflake SQL migrations.

When to use

• Translating Snowflake dbt SQL models to BigQuery SQL
• SQL compilation
• Jinja macro placeholder masking
• BigQuery Translation Service migration workflows
• AST-based config transformations
• Explicit type casting
• JSON extraction standardization
• Deduplication

When not to use

• Generic BigQuery queries
• Non-Snowflake SQL migrations

Skill page

Source