skills.rest
interflownex
interflownexCOMMUNITY
Explore all skills by this author →
GitHub

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
One-click install
npx skills add https://github.com/interflownex/All-in-One --skill dbt-bigquery-interflownex
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
AubreyHanAubreyHan

dbt-bigquery

Diagnose and improve dbt pipelines for BigQuery projects.

Community
Advanced
RDEWAIRDEWAI
5

create-integration-test

Generates integration tests for Docker-based apps with CI/CD pipelines and automated workflows.

Official
Advanced
levanminhduclevanminhduc

docker

Guide containerization of applications with Dockerfiles, Compose, and CI/CD pipelines.

Community
Advanced
luokai25luokai25

data-engineering

Design and implement scalable data pipelines with Apache Spark and dbt workflows.

Community
Advanced