Trace dbt model failures to upstream causes and validate fixes.
npx skills add https://github.com/miptah21/skills --skill debugging-dbt-errors
Please help me install this Agent Skill. Skill: debugging-dbt-errors Source: https://github.com/miptah21/skills/tree/main/.agents/skills/debugging-dbt-errors Command: npx skills add https://github.com/miptah21/skills --skill debugging-dbt-errors
This Skill helps you quickly diagnose and resolve dbt errors and failing tests without guessing, by working from the full error outward to upstream causes and validating the fix end-to-end.
dbt build (not just compile), then verify output data and run relevant tests, including downstream impact.Run the Skill when your dbt model is failing, and ask it to debug the issue by reading the full error, checking upstream models, applying the most likely fix, then rebuilding with dbt build and verifying the resulting data.
High-intent search queries and answers about installing and using this skill.
Debug failing dbt models by reading the complete error message, classifying it as compilation, database, or test failure, then inspecting compiled SQL and upstream models to pinpoint the root cause before applying fixes.
dbt models break after upstream changes when referenced columns or logic shift; trace the root cause by verifying upstream models and sources, inspecting compiled SQL, and confirming the actual data output before fixing the correct file.
Verify a dbt fix by running dbt build to rebuild the model, not just compiling, then validating output data with dbt show and running dbt test to confirm correctness including downstream rebuilds.
Resolve dbt test failures by reading the full error, investigating upstream models and sources first, inspecting compiled SQL and actual data, then applying corrections to the correct file and rebuilding with dbt build.
Inspect compiled SQL during dbt error troubleshooting when a model fails or produces unexpected output, as it reveals how dbt translated macros and references, helping identify mismatches between upstream models and downstream dependencies.
Debugging dbt errors systematically resolves downstream model breaks by tracing failures back to upstream root causes, fixing the correct source file, and validating end-to-end correctness through dbt build and dbt test with downstream rebuilds.
Snowflake-LabsDiagnose and correct compilation errors in dbt models within Snowflake environments.
AltimateAIAnalyze downstream dependencies and validate dbt model refactoring changes.
niitsMigrate dbt projects between data platforms using dbt Fusion compilation.
cwidaBuild, run, and debug the LPTS SQL transpilation test suite.