dataform-bigquery
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
With your agent
Install OMGSkills skill "googlecloudplatform/data-agent-kit-plugin:skills/dataform-bigquery" into this agent's normal skills directory: call the OMGSkills MCP get_install_plan tool for your agent and run the script it returns (it installs only the pinned commit and verifies SKILL.md), and stop if MCP or the pin is unavailable. Do not overwrite or change existing skills without asking me.
Manual command
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-bigqueryFrom 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.
More from this repo
accidental-data-loss-prevention
**STOP AND VERIFY**: Before running any command or tool that results in irreversible data loss, you MUST obtain...
bigquery-ai-ml
Leverages BigQuery's built-in machine learning and GenAI capabilities for advanced data analytics.
bigquery-bigframes
Generates Python code using BigQuery DataFrames (BigFrames).