skills.rest
Claudfather
ClaudfatherOFFICIAL
Explore all skills by this author →
WebsiteGitHub

dbt

Runs dbt build, test, compile, and full-refresh commands against Snowflake.

Updated May 3, 2026
Search Tags:#build#data modeling#dbt#analytics engineering#test#incremental#snowflake
One-click install
npx skills add https://github.com/Claudfather/clauDNA --skill dbt-claudfather
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dbt
Source: https://github.com/Claudfather/clauDNA/tree/main/skills/dbt
Command: npx skills add https://github.com/Claudfather/clauDNA --skill dbt-claudfather

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires dbt.

What problem does it solve? Running dbt commands against Snowflake requires correct project context and authentication, and mistakes like missing credentials or wrong model selections waste time. This Skill standardizes common dbt operations so builds, tests, and compiles run correctly the first time. ## Core Features & Use Cases - Model Builds: Build a single model or include upstream dependencies with dbt build --select +model_name. - Testing & Compilation: Run tests on selected models or compile SQL without executing it against the warehouse. - Full Refresh: Rebuild incremental models from scratch with --full-refresh when logic changes. - Auth Awareness: Checks for Snowflake credentials via .env files, project auth helpers, or shell exports before running commands. - Use Case: After editing an incremental model, ask to full-refresh it and run its tests, and get results plus any test failures reported back. ## Quick Start Ask the assistant to build and test a specific dbt model, for example by saying run dbt build and test for the fct_orders model.

Frequently Asked Questions about dbt

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

FAQPage Schema
How do I run dbt build for a specific model?▼

Run dbt build --select model_name from the dbt project directory. To include upstream dependencies, use dbt build --select +model_name, which builds everything the model depends on first.

How do I test a dbt model without rebuilding it?▼

Run dbt test --select model_name to execute only the tests defined for that model. This skips the build step and reports any test failures directly.

How do I full-refresh an incremental dbt model?▼

Run dbt run --select model_name --full-refresh to rebuild the incremental model from scratch. This is needed when the model's logic changes in ways that incremental merges cannot apply.

Why does dbt fail with Snowflake authentication errors?▼

dbt needs Snowflake credentials exported in the shell before running. Source the project's .env file or auth helper, or check the project CLAUDE.md for the documented authentication method.

Can I compile dbt SQL without running it against Snowflake?▼

Yes, dbt compile --select model_name renders the SQL without executing it against the warehouse. This is useful for verifying Jinja templating and generated SQL before a full run.

Related Skills

Explore More Data & Analytics Skills→
CannerCanner
17.7k

onboarding

Guides agents through Wren Engine installation, project scaffolding, connection setup, and first query.

Official
Advanced
warpdotdevwarpdotdev
64.1k

diagnose-ci-failures

Diagnose CI failures for a pull request and generate a fix plan.

Official
Advanced
Datus-aiDatus-ai
1.5k

transfer-reconciliation

Verify post-transfer row count parity and target table accessibility.

Official
Intermediate
reason-machinesreason-machines
5

zomato-ai-data-engineering-pipeline

Builds a batch data pipeline with S3, Snowflake, dbt, Airflow, and OpenAI for food delivery analytics.

Official
Advanced