# dataform-bigquery

> Claude/Codex skill by [@googlecloudplatform](https://omgskills.com/library/googlecloudplatform/index.md) · 226 stars · Updated 2026-10-23

Expertise in generating clean, correct, and efficient Dataform pipeline code for BigQuery ELT. Use this when creating or modifying Dataform pipelines, actions, or source declarations, when Dataform, SQLX, or BigQuery are mentioned in a transformation, when data needs to be ingested from GCS into BigQuery via Dataform, or when setting up a new Dataform project or configuring workflow\_settings.yaml.

## Install

```sh
git clone https://github.com/GoogleCloudPlatform/data-agent-kit-plugin /tmp/data-agent-kit-plugin && ln -s /tmp/data-agent-kit-plugin/skills/dataform-bigquery ~/.claude/skills/dataform-bigquery
```

## From README

Dataform Expert Skill for BigQuery Expert-level guidance for building, managing, and optimizing Dataform pipelines targeting Google BigQuery. Role & Persona Act as a BigQuery and Dataform expert specializing in correct and efficient ELT pipelines. Prioritize technical accuracy over agreement — investigate before confirming assumptions. Be direct, objective, and fact-driven. Make reasonable assumptions when details are missing, and clearly state them. Task Execution Workflow Follow these steps when fulfilling Dataform-related requests: Step 0: Environment Verification Ensure dataform and bq CLI are installed by running dataform --version and bq version respectively. If dataform CLI is not installed, ensure Node.js and npm are installed by running node -v and npm -v respectively. If Node.js or npm are not installed already, ask the user to them. If they are both installed, proceed to the dataform CLI by running npm i -g @dataform/cli and verifying the with dataform --version.

## Links

- HTML page: https://omgskills.com/library/googlecloudplatform/data-agent-kit-plugin/skills/dataform-bigquery/
- GitHub: https://github.com/GoogleCloudPlatform/data-agent-kit-plugin
- Author: [@googlecloudplatform](https://omgskills.com/library/googlecloudplatform/index.md)

## More from this repo

- [accidental-data-loss-prevention](https://omgskills.com/library/googlecloudplatform/data-agent-kit-plugin/skills/accidental-data-loss-prevention/index.md) — \*\*STOP AND VERIFY\*\*: Before running any command or tool that results in irreversible data loss, you MUST obtain...
   - [@googlecloudplatform](https://omgskills.com/library/googlecloudplatform/index.md) · 226 stars
- [bigquery-ai-ml](https://omgskills.com/library/googlecloudplatform/data-agent-kit-plugin/skills/bigquery-ai-ml/index.md) — Leverages BigQuery's built-in machine learning and GenAI capabilities for advanced data analytics.
   - [@googlecloudplatform](https://omgskills.com/library/googlecloudplatform/index.md) · 226 stars
- [bigquery-bigframes](https://omgskills.com/library/googlecloudplatform/data-agent-kit-plugin/skills/bigquery-bigframes/index.md) — Generates Python code using BigQuery DataFrames (BigFrames).
   - [@googlecloudplatform](https://omgskills.com/library/googlecloudplatform/index.md) · 226 stars