skills.rest
gemini-cli-extensions
gemini-cli-extensionsOFFICIAL
Explore all skills by this author →
GitHub

dbt-bigquery

Automate dbt pipeline design, modification, and optimization for Google BigQuery.

161|37|Updated Apr 2, 2026
Search Tags:#testing#dbt#data-modeling#bigquery#data-pipelines#sql-optimization
One-click install
npx skills add https://github.com/gemini-cli-extensions/data-agent-kit-starter-pack --skill dbt-bigquery
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dbt-bigquery
Source: https://github.com/gemini-cli-extensions/data-agent-kit-starter-pack/tree/main/skills/dbt-bigquery
Command: npx skills add https://github.com/gemini-cli-extensions/data-agent-kit-starter-pack --skill dbt-bigquery

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

dbt-based data pipelines targeting Google BigQuery can be complex and error-prone. This skill provides expert guidance for building, modifying, and optimizing dbt projects to reduce misconfigurations, improve performance, and accelerate delivery across data teams.

Core Features & Use Cases

  • Guided project setup for BigQuery including dbt_project.yml configuration and profile alignment.
  • Model development & optimization with best practices for materializations, testing, and documentation.
  • Use cases: creating new dbt projects, refactoring existing models, and tuning SQL within pipelines to meet SLAs.

Quick Start

Create a new dbt project configured for BigQuery with an initial Bronze model and a basic tests setup.

Frequently Asked Questions about dbt-bigquery

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize dbt models for BigQuery to improve data pipeline performance?▼

Yes, you can set up a new dbt project configured for BigQuery. The skill guides profile alignment and dbt_project.yml configuration, creating an initial Bronze model with a basic tests setup to accelerate delivery.

What is the best way to configure dbt_project.yml for a BigQuery data pipeline?▼

Configuring dbt_project.yml for BigQuery involves aligning your profile settings and project structure. The skill provides guided project setup to ensure correct configuration and reduce misconfigurations in your data pipelines.

Do I need the dbt and bq CLI installed to manage dbt data pipelines?▼

Yes, you need both the dbt and bq CLI installed. The skill satisfies environment verification for these dependencies before applying safe, iterative workflows to your BigQuery data models.

Why does my dbt pipeline fail during testing on Google BigQuery?▼

Troubleshoot failing dbt pipelines on BigQuery using iterative compile and test workflows. The skill identifies misconfigurations and refines SQL optimization to ensure safe deployment in production-grade data environments.

Related Skills

Explore More Data & Analytics Skills→
alex-tgkalex-tgk

senior-data-engineer

Automate and optimize production data pipelines using Python, SQL, Spark, Airflow, dbt, and Kafka.

Community
Intermediate
shaprisshapris

answering-natural-language-questions-with-dbt

Generates and executes SQL to answer natural-language business questions using dbt semantic layer or compiled SQL.

Community
Advanced
rittmananalyticsrittmananalytics
8

dbt-unit-testing

Validate dbt models with mock inputs and expected outputs.

Official
Advanced
scanadyscanady

data-eng-pipeline-architect

Design production-grade data pipelines for batch and streaming workloads.

Community
Advanced