What problem does it solve? Migrating dbt pipelines from Snowflake to BigQuery requires rewriting hundreds of SQL models to handle dialect differences, semi-structured data access patterns, and type systems. Manual translation is error-prone and time-consuming, blocking teams from cloud migrations. ## Core Features & Use Cases - Automated SQL Dialect Translation: Converts Snowflake-specific syntax (colon notation, cast suffixes, dateadd functions) to BigQuery Standard SQL using the BigQuery Migration Service. - dbt Macro Preservation: Maintains {{ ref(...) }}, {{ source(...) }}, and Jinja control flow while translating underlying SQL. - JSON/STRUCT Standardization: Automatically converts Snowflake variant access patterns to BigQuery JSON_VALUE, dot notation for STRUCT columns, and ARRAY<STRUCT> indexing. - Use Case: You have a 50-model Snowflake dbt project using variant columns and nested object access. Run this Skill to generate BigQuery-compatible models with proper type casting, JSON extraction patterns, and deduplication logic in minutes instead of weeks. ## Quick Start Translate your Snowflake dbt project by providing the input directory containing SQL models, the output directory for BigQuery files, a GCS bucket for staging, and your Google Cloud region.