dbt-sf-to-bq-translator agent skill by google
Translates Snowflake dbt SQL models to BigQuery SQL, handling SQL compilation, Jinja macro masking, BigQuery Translation Service workflows, config transformations, type casting, and deduplication.
At a glance
| Publisher | Google Official |
|---|---|
| Repository | google/skills (163 listed skills) |
| Category | Data, Analytics and Databases |
| License | Apache-2.0 |
| Last commit | October 16, 2026 (repository) |
| SKILL.md | 146 lines, 1,756 words |
| Bundled files | 4 files, including references, scripts |
| Quality score | 89/100 · B Passes all seven graded checks |
| Security scan | Not scanned |
| README badge | Get the badges for this listing |
Before you install
Read from the skill's files at the directory's October 22, 2026 snapshot: what ships with it, what its code reads, and the terms it is published under.
- Bundled scripts: 2 script files (2 Python). Your agent may run them, so read them first.
- License: Apache-2.0, an open-source or open-content license.
Install dbt-sf-to-bq-translator
The skills CLI works with Claude Code, Codex, Cursor and other agents; the other routes copy the folder by hand.
npx skills add https://github.com/google/skills/tree/main/skills/cloud/dbt-sf-to-bq-translatortmp="$(mktemp -d)"
git clone --depth 1 https://github.com/google/skills.git "$tmp/repo"
mkdir -p .claude/skills
cp -R "$tmp/repo/"skills/cloud/dbt-sf-to-bq-translator .claude/skills/
rm -rf "$tmp"tmp="$(mktemp -d)"
git clone --depth 1 https://github.com/google/skills.git "$tmp/repo"
mkdir -p .agents/skills
cp -R "$tmp/repo/"skills/cloud/dbt-sf-to-bq-translator .agents/skills/
rm -rf "$tmp"For a user-level install, copy the folder to ~/.claude/skills/ (Claude Code) or ~/.agents/skills/ (Codex). Inside Codex, $skill-installer can also fetch a skill from GitHub. New to skills? Read How to install agent skills in Claude Code, Codex and Cursor.
google/skills is third-party code. Read SKILL.md and any bundled scripts before you install it.
How the author describes it
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.
From the description field of SKILL.md. Agents read this line to decide when to load the skill.
Sections in SKILL.md
- 1. Mandatory File Header
- 2. Standardized JSON & Array Extraction
- 3. Explicit Type Safety
- 4. Prescriptive String & Date Functions
- 5. Mandatory Deduplication & Joins
- 6. Preserve Jinja Constructs
Files in the skill folder
SKILL.mdreferences/dbt_migration_patterns.mdscripts/bulk_translate_via_gcloud.pyscripts/dbt_translator.py
Suede Skill Check: 89/100 · B
Report snapshot · · graded-v2
The rubric totals 100 points; published scores are capped at 99. Security scan: not scanned.
Source revision: e86adb9e2b80. Report version e9e87286df8c. Badge URLs follow the latest listing; save the report to keep this version.
Download report · Request a fresh review
What to review next
- Example request: 0 of 3 points. 3 when the description quotes an example request (3–60 characters in quotation marks).
- Tool permissions declared: 0 of 2 points. 2 when the frontmatter declares allowed-tools.
- Compatibility declared: 0 of 2 points. 2 when the frontmatter declares compatibility.
Add declarations and bundled files when they describe the skill’s actual needs. Update the source, then request a fresh review with the changed commit or PR.
dbt-sf-to-bq-translator passes the required frontmatter check and all seven graded checks, which cover the SKILL.md format, a declared license and a commit in the last year. Those checks earn 56 of the score’s points; the rest come from description quality, instruction depth, bundled files, maintenance and curated-list citations. How the score works.
See the checks and points
| Check | Result |
|---|---|
| Frontmatter parses and declares a name and a description | Pass |
| Name uses lowercase letters, digits and hyphens, 64 characters or fewer | Pass |
| Name matches the skill's folder name | Pass |
| Description is between 50 and 1,024 characters | Pass |
| Description says when an agent should use the skill | Pass |
| SKILL.md body is 500 lines or fewer | Pass |
| A license is declared in the frontmatter or the repository | Pass |
| Repository has a commit in the last 12 months | Pass |
| Score component | Points |
|---|---|
| Structural checks | 56 of 56 |
| Description length | 5 of 5 |
| Boundary clause | 4 of 4 |
| Example request | 0 of 3 |
| Instruction depth | 7 of 7 |
| Reference files | 3 of 3 |
| Bundled scripts | 2 of 2 |
| Recent maintenance | 9 of 9 |
| Curated-list citations | 3 of 7 |
| Tool permissions declared | 0 of 2 |
| Compatibility declared | 0 of 2 |
Two badges for dbt-sf-to-bq-translator
Choose the numeric badge, the letter badge, or both. Each links to this skill’s Suede AI listing; either valid linked badge can qualify for the feature offer.
[](https://suedeai.directory/google/skills/dbt-sf-to-bq-translator/)
[](https://suedeai.directory/google/skills/dbt-sf-to-bq-translator/)<a href="https://suedeai.directory/google/skills/dbt-sf-to-bq-translator/"><img src="https://suedeai.directory/google/skills/dbt-sf-to-bq-translator/score.svg" alt="Suede Skill Check: 89/100" width="160" height="175"></a>
<a href="https://suedeai.directory/google/skills/dbt-sf-to-bq-translator/"><img src="https://suedeai.directory/google/skills/dbt-sf-to-bq-translator/badge.svg" alt="Suede Skill Check: Grade B" width="160" height="175"></a>Suede Certified on the shield refers to this published structural quality check. Security scan: not scanned. Read the methodology.
Limited-time feature offer: Display either quality badge in your repository or skill README, linked to your listing, then request verification. Suede AI checks the rendered README at a recorded commit. Eligible skills scoring 80–99 with a verified badge can receive a featured placement while the offer is open. Request badge verification.
Publishers: read How to get your agent skill found in search and cited by AI assistants.
Where this skill is cited
google/skills appears in 2 curated lists: VoltAgent/awesome-agent-skills, skillmatic-ai/awesome-agent-skills.