skills.rest
RxFit
RxFitCOMMUNITY
Explore all skills by this author →
GitHub

dbt-bigquery

Create, modify, and troubleshoot dbt pipelines for BigQuery.

Updated Jun 5, 2026
Search Tags:#optimization#data pipeline#dbt#BigQuery#ELT
One-click install
npx skills add https://github.com/RxFit/hub-overlay --skill dbt-bigquery-rxfit
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dbt-bigquery
Source: https://github.com/RxFit/hub-overlay/tree/main/hub/skills/dbt-bigquery
Command: npx skills add https://github.com/RxFit/hub-overlay --skill dbt-bigquery-rxfit

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires dbt, bq-cli, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill provides expert-level guidance for creating, modifying, and optimizing dbt pipelines for BigQuery, solving the challenge of efficient and accurate ELT pipelines.

Core Features & Use Cases

  • dbt Expertise: Specializes in dbt (data build tool) pipelines for Google BigQuery.
  • Technical Accuracy: Prioritizes technical accuracy over assumptions.
  • Data Cleaning and SQL Optimization: Applies data cleaning and SQL optimizations to ensure efficient data pipelines.
  • Execution Workflow: Follows a structured workflow for environment verification, understanding the current state, gathering information, applying changes, validating, and iterating.

Quick Start

Activate the dbt BigQuery Expert Skill when you need to create, modify, or troubleshoot a dbt model or project, or when optimizing SQL within a dbt project.

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 pipelines for BigQuery to improve SQL efficiency?▼

Optimizing dbt pipelines for BigQuery requires applying SQL optimizations and data cleaning techniques to ensure efficient data processing. This involves modifying models and troubleshooting to maintain data accuracy and pipeline efficiency.

What is the best way to troubleshoot a failing dbt model in BigQuery?▼

Troubleshooting a failing dbt model involves following a structured workflow: verifying the environment, understanding the current state, gathering information, applying changes, validating, and iterating until the model executes correctly.

Do I need bq CLI installed to create and manage dbt models for BigQuery?▼

Yes, managing and creating dbt models for BigQuery requires both the dbt and bq CLI tools. These dependencies are necessary to execute the environment verification and pipeline modifications effectively.

How does dbt handle BigQuery schema design for accurate ELT pipelines?▼

dbt handles BigQuery schema design by prioritizing technical accuracy over assumptions, applying structured modifications to models. This ensures data accuracy and efficiency throughout the ELT pipeline execution.

Why is my dbt pipeline not working after modifying BigQuery SQL models?▼

A dbt pipeline might not work after modifying SQL models due to schema design issues or unverified environment changes. You must validate the applied changes and iterate through the execution workflow to restore functionality.

Related Skills

Explore More Software Engineering Skills→
AubreyHanAubreyHan

dbt-bigquery

Diagnose and improve dbt pipelines for BigQuery projects.

Community
Advanced
kubiyabotkubiyabot
16

grafana

Manage Grafana dashboards, alerts, and data sources via the HTTP API.

Official
Intermediate
alex-tgkalex-tgk

senior-data-engineer

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

Community
Intermediate
interflownexinterflownex
2

dataform-bigquery

Generate and optimize Dataform pipeline code for Google BigQuery ELT workflows.

Community
Advanced