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 19, 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"python3 ~/.codex/skills/.system/skill-installer/scripts/install-skill-from-github.py \
--repo google/skills \
--path skills/cloud/dbt-sf-to-bq-translatorgoogle/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 32834020a1d5. 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 listing; either valid linked badge can qualify for the feature offer.
[](https://skills.suedeai.ai/directory/google/skills/dbt-sf-to-bq-translator/)
[](https://skills.suedeai.ai/directory/google/skills/dbt-sf-to-bq-translator/)<a href="https://skills.suedeai.ai/directory/google/skills/dbt-sf-to-bq-translator/"><img src="https://skills.suedeai.ai/directory/google/skills/dbt-sf-to-bq-translator/score.svg" alt="Suede Skill Check: 89/100" width="160" height="175"></a>
<a href="https://skills.suedeai.ai/directory/google/skills/dbt-sf-to-bq-translator/"><img src="https://skills.suedeai.ai/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 the numeric or letter badge in your repository or skill README (both also qualify), then request badge verification. Eligible skills scoring 80–99 can receive a featured placement after Suede verifies at least one valid badge linked to the skill’s listing. Suede has not announced an end date.
Where this skill is cited
google/skills appears in 2 curated lists: VoltAgent/awesome-agent-skills, skillmatic-ai/awesome-agent-skills.