# Dbt sf to bq translator

> Dbt sf to bq translator is an open-source agent skill for databases. Translates Snowflake dbt SQL models to Standardized BigQuery SQL. It is available on Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf and Goose.

- **Kind:** Skill
- **Pricing:** Open source
- **Platforms:** Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf, Goose
- **Website:** https://github.com/google/skills/tree/main/skills/cloud/dbt-sf-to-bq-translator
- **Repository:** https://github.com/google/skills
- **GitHub stars:** 24,379
- **License:** Apache-2.0
- **Skill name:** dbt-sf-to-bq-translator
- **Collection:** https://github.com/google/skills
- **Categories:** databases
- **Listing updated:** 2026-11-17

## About

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 your agent uses 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.

## What it can access

From a static check of the files on GitHub; nothing was run.

- [Runs Python scripts](https://github.com/google/skills/tree/HEAD/skills/cloud/dbt-sf-to-bq-translator)
- [No network calls found in its scripts](https://github.com/google/skills/tree/HEAD/skills/cloud/dbt-sf-to-bq-translator)
- [License: Apache-2.0](https://github.com/google/skills/tree/HEAD/skills/cloud/dbt-sf-to-bq-translator)

## Install

### Claude Code

Copy the skill folder to `~/.claude/skills/dbt-sf-to-bq-translator` to use it in all your projects:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/google/skills.git "$tmp" &&
mkdir -p ~/.claude/skills &&
rm -rf ~/.claude/skills/dbt-sf-to-bq-translator &&
cp -R "$tmp/skills/cloud/dbt-sf-to-bq-translator" ~/.claude/skills/dbt-sf-to-bq-translator &&
rm -rf "$tmp"
```

For one project only, put the folder in `.claude/skills/dbt-sf-to-bq-translator` inside it instead.

### Codex

Copy the skill folder to `~/.agents/skills/dbt-sf-to-bq-translator` to use it in every repository:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/google/skills.git "$tmp" &&
mkdir -p ~/.agents/skills &&
rm -rf ~/.agents/skills/dbt-sf-to-bq-translator &&
cp -R "$tmp/skills/cloud/dbt-sf-to-bq-translator" ~/.agents/skills/dbt-sf-to-bq-translator &&
rm -rf "$tmp"
```

For one repository only, put the folder in `.agents/skills/dbt-sf-to-bq-translator` inside it instead.

### Cursor

Copy the skill folder to `~/.cursor/skills/dbt-sf-to-bq-translator` to use it in every project:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/google/skills.git "$tmp" &&
mkdir -p ~/.cursor/skills &&
rm -rf ~/.cursor/skills/dbt-sf-to-bq-translator &&
cp -R "$tmp/skills/cloud/dbt-sf-to-bq-translator" ~/.cursor/skills/dbt-sf-to-bq-translator &&
rm -rf "$tmp"
```

For one project only, put the folder in `.cursor/skills/dbt-sf-to-bq-translator` inside it instead.

### Gemini CLI

Run in a terminal (add `--scope workspace` to install it for the current workspace only):

```sh
gemini skills install https://github.com/google/skills.git --path skills/cloud/dbt-sf-to-bq-translator
```

Or copy the folder to `~/.gemini/skills/dbt-sf-to-bq-translator` yourself.

### VS Code

For GitHub Copilot in VS Code, copy the skill folder to `~/.copilot/skills/dbt-sf-to-bq-translator`:

```sh
tmp=$(mktemp -d) &&
git clone --depth 1 https://github.com/google/skills.git "$tmp" &&
mkdir -p ~/.copilot/skills &&
rm -rf ~/.copilot/skills/dbt-sf-to-bq-translator &&
cp -R "$tmp/skills/cloud/dbt-sf-to-bq-translator" ~/.copilot/skills/dbt-sf-to-bq-translator &&
rm -rf "$tmp"
```

For one project only, put the folder in `.github/skills/dbt-sf-to-bq-translator` inside it instead.

### Other agents

Get the folder:

```sh
git clone --depth 1 https://github.com/google/skills.git
```

Then copy `skills/skills/cloud/dbt-sf-to-bq-translator` into your agent's skills folder as `dbt-sf-to-bq-translator`. Agents that support SKILL.md read one folder per skill.

## FAQ

### How do I install Dbt sf to bq translator in Claude Code?

Copy the skill folder from GitHub to ~/.claude/skills/dbt-sf-to-bq-translator to use it in all your projects, or to .claude/skills/dbt-sf-to-bq-translator in one project.

### Does Dbt sf to bq translator run scripts?

Yes. It runs Python scripts. No network calls were found in its scripts. This comes from a static check of the files on GitHub; nothing was run. Read the files before you install it.

### Which AI agents can use Dbt sf to bq translator?

Claude Code, Codex, Cursor, Gemini CLI, GitHub Copilot, Windsurf and Goose. Each reads skills in the SKILL.md format from its own folder; the install steps on this page list them.

### What are the best alternatives to Dbt sf to bq translator?

The closest alternatives to Dbt sf to bq translator are Snowflake semanticview, SQL server table reconciliation, Postgresql optimization, Bigquery pipeline audit and Pinecone rag.

## Alternatives

- [Snowflake semanticview](https://ai-powered.com/skills/snowflake-semanticview): Snowflake semanticview is an open-source agent skill for databases.
- [SQL server table reconciliation](https://ai-powered.com/skills/sql-server-table-reconciliation): SQL server table reconciliation is an open-source agent skill for databases.
- [Postgresql optimization](https://ai-powered.com/skills/postgresql-optimization): Postgresql optimization is an open-source agent skill for databases.
- [Bigquery pipeline audit](https://ai-powered.com/skills/bigquery-pipeline-audit): Bigquery pipeline audit is an open-source agent skill for databases.
- [Pinecone rag](https://ai-powered.com/skills/pinecone-rag): Pinecone rag is an open-source agent skill for knowledge and memory.
- [Efcore d2 db diagram](https://ai-powered.com/skills/efcore-d2-db-diagram): Efcore d2 db diagram is an open-source agent skill for databases.
- [Creating oracle to postgres migration integration tests](https://ai-powered.com/skills/creating-oracle-to-postgres-migration-integration-tests): Creating oracle to postgres migration integration tests is an open-source agent skill for databases.
- [SQL object impact analysis](https://ai-powered.com/skills/sql-object-impact-analysis): SQL object impact analysis is an open-source agent skill for databases.

---
Source: https://ai-powered.com/skills/dbt-sf-to-bq-translator
