skills.rest
AubreyHan
AubreyHanCOMMUNITY
Explore all skills by this author →
GitHub

dbt-bigquery

Diagnose and improve dbt pipelines for BigQuery projects.

Updated Jun 10, 2026
Search Tags:#data modeling#dbt#analytics engineering#bigquery#sql optimization#pipeline debugging#dbt tests
One-click install
npx skills add https://github.com/AubreyHan/SKILL_Repo --skill dbt-bigquery-aubreyhan
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dbt-bigquery
Source: https://github.com/AubreyHan/SKILL_Repo/tree/main/dbt-bigquery
Command: npx skills add https://github.com/AubreyHan/SKILL_Repo --skill dbt-bigquery-aubreyhan

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps you create, modify, troubleshoot, and optimize dbt projects that run on Google BigQuery, reducing pipeline errors and making ELT workflows easier to maintain.

Core Features & Use Cases

  • dbt Project Support: Locate, compile, and validate dbt projects while checking model structure and configuration.
  • BigQuery Optimization: Improve SQL patterns and apply BigQuery-specific best practices for safer, faster transformations.
  • Operational Troubleshooting: Diagnose missing profiles, dependency issues, schema mismatches, and compilation failures in local or orchestrated environments.
  • Use Case: Use this Skill when setting up a new dbt project, updating an existing model, or fixing a failing BigQuery pipeline before deployment.

Quick Start

Ask the dbt-bigquery skill to inspect your dbt project, validate the BigQuery configuration, and compile the models for troubleshooting or optimization.

Frequently Asked Questions about dbt-bigquery

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

FAQPage Schema
How do I debug a failing dbt pipeline on BigQuery?▼

Optimize slow dbt models on BigQuery by reviewing compiled SQL, applying BigQuery-specific best practices, and refining model logic and configuration. This Skill diagnoses and improves SQL patterns to ensure faster, safer production-ready transformations.

What causes dbt compilation errors in BigQuery environments?▼

Setting up a new dbt project on BigQuery requires validating BigQuery CLI configuration, structuring sources and models, and defining tests. This Skill supports creating and compiling dbt projects to ensure safe, production-ready ELT workflows.

How do I optimize dbt SQL models for BigQuery?▼

Optimize dbt SQL models for BigQuery by applying BigQuery-specific best practices, refining SQL patterns, and reviewing model configuration. This process diagnoses and improves model logic to ensure safer and faster data transformations.

Do I need bq CLI to troubleshoot dbt BigQuery pipelines?▼

Adding dbt tests to BigQuery models requires defining test logic within the dbt project and validating schema constraints. This Skill supports creating and modifying dbt tests to ensure reliable pipeline data quality and safer transformations.

How to fix missing profiles configuration in dbt BigQuery?▼

Fix missing profiles configuration in dbt BigQuery by validating the profiles.yml setup and ensuring proper BigQuery CLI authentication. This Skill diagnoses missing profiles and schema mismatches to restore local and orchestrated pipeline execution.

Related Skills

Explore More Data & Analytics Skills→
shaprisshapris

configuring-dbt-mcp-server

Generate dbt MCP server configuration JSON and validate connectivity.

Community
Advanced
vignesh2027vignesh2027
6

data-pipeline-pro

Design and optimize batch and streaming ETL/ELT pipelines.

Community
Advanced
dtsongdtsong
1

dbt-skill

Guide dbt data modeling, testing, CI/CD, and performance optimization across Snowflake and BigQuery.

Community
Advanced
interflownexinterflownex
2

dbt-bigquery

Optimize dbt pipelines targeting Google BigQuery with SQL improvements.

Community
Advanced