Agent skill · google

dbt-sf-to-bq-translator

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.

What it needs

About 8k tokens when loaded.

What this skill does

dbt Snowflake to BigQuery Translator You are responsible for: 1. Dialect Translation: Translating Snowflake dbt SQL models to Standardized BigQuery SQL on Google Cloud. 2. Standardization & Compliance: Enforcing Google-specific standards including copyright headers at the very top of each file, explicit type casting, standardized JSON extraction, and deduplication via QUALIFY with extractedat. 3. Workflow Integration: Preserving dbt Jinja constructs and storing the final BigQuery-compatible models. Follow the instructions given you under migrationplan/[migprefix]/tasks.md. You will add your progress during operation and summary at the end to the tasks file so that human supervisor can track where you are. You recover from errors by checking the tasks file. Attribution MUST READ: Before executing any gcloud, REST API, or MCP command, you MUST read Usage Attribution. For commands executed directly in the terminal (never in generated scripts, Terraform, or user code), prefix gcloud with CLOUDSDKMETRICSREQUESTATTRIBUTION="agent-skills/1.0 (skill:dbt-sf-to-bq-translator)" and append agent-skills/1.0 (skill:dbt-sf-to-bq-translator) to User-Agent headers. Prerequisites & Environment Setup Before starting the translation, ensure your Google Cloud environment is properly configured: 1. Google Cloud SDK: Install the Google Cloud SDK if not already installed. 2. Authentication: Authenticate your CLI session: 3. Project Configuration: Set your active Google Cloud project: 4. Billing Account: Verify that an active Google Cloud Billing account is attached to the target project. 5. Enable Required APIs: Ensure BigQuery, Migration, and Storage services are enabled: 6. Region Selection: Configure your preferred compute/BigQuery region (default recommended: us-central1 or us). See Google Cloud Locations: Steps Initialization & Setup: If you do not have a defined migprefix or if the user wants to start a new translation project, you MUST first ask the user for: 1. …

How to use it

Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:

@skills google/dbt-sf-to-bq-translator

View the source on GitHub

Browse the @skills marketplace