dbt-bigquery

Optimize dbt pipelines targeting Google BigQuery with SQL improvements.

2|1|Updated May 25, 2026

Search Tags:#dbt #data engineering #sql #pipeline #etl #bigquery

Ready to run

npx skills add https://github.com/interflownex/All-in-One --skill dbt-bigquery-interflownex

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: dbt-bigquery
Source: https://github.com/interflownex/All-in-One/tree/main/.gemini/skills/dbt-bigquery
Command: npx skills add https://github.com/interflownex/All-in-One --skill dbt-bigquery-interflownex

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This skill resolves the complexity of building, maintaining, and optimizing dbt data pipelines specifically for Google BigQuery, ensuring high performance and technical accuracy.

Core Features & Use Cases

Automated Optimization: Automatically applies SQL performance improvements and data cleaning protocols to all dbt models.
Pipeline Management: Provides expert guidance on dbt project initialization, DAG compilation, and unit testing.
Use Case: When you need to refactor a slow-running dbt model, this skill will analyze your SQL, suggest BigQuery-specific optimizations, and help you implement unit tests to ensure data integrity.

Quick Start

Use the dbt-bigquery skill to compile the current project and identify potential SQL optimization opportunities.

Frequently Asked Questions about dbt-bigquery

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

FAQPage Schema

How do I optimize slow dbt models in BigQuery?▼

To optimize slow dbt models in BigQuery, this skill analyzes your SQL and automatically applies BigQuery-specific performance improvements alongside strict data cleaning protocols to resolve bottlenecks.

What's the best way to compile a dbt project for BigQuery?▼

The best way to compile a dbt project for BigQuery is to use guided DAG compilation, which initializes your project structure and identifies SQL optimization opportunities during the build process.

How do I add unit tests to a dbt pipeline on Google BigQuery?▼

You add unit tests to a dbt pipeline on Google BigQuery by leveraging expert guidance that helps you implement tests ensuring data integrity after applying SQL optimizations.

When do I need to apply data cleaning protocols in dbt pipelines?▼

You need to apply data cleaning protocols in dbt pipelines when building any model, as this skill enforces strict cleaning standards automatically to ensure high technical accuracy and performance.

Does dbt work effectively with BigQuery for large ETL pipelines?▼

dbt works effectively with BigQuery for large ETL pipelines by utilizing automated SQL optimization and DAG compilation to maintain high performance across complex data engineering workflows.