skills.rest
AltimateAI
AltimateAIOFFICIAL
Explore all skills by this author →
WebsiteGitHub

dbt-troubleshoot

Diagnose and resolve dbt errors across compilation, runtime, tests, and data quality.

792|138|Updated Feb 27, 2026
Search Tags:#debugging#dbt#sql#diagnostics#workflows#data-model#dbt-troubleshoot
One-click install
npx skills add https://github.com/AltimateAI/altimate-code --skill dbt-troubleshoot
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dbt-troubleshoot
Source: https://github.com/AltimateAI/altimate-code/tree/main/.opencode/skills/dbt-troubleshoot
Command: npx skills add https://github.com/AltimateAI/altimate-code --skill dbt-troubleshoot

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Debug dbt errors across compilation failures, runtime database errors, test failures, wrong data, and performance issues to keep dbt projects healthy and reliable. This Skill provides a structured approach to diagnosing, classifying, and resolving issues so teams can restore correctness quickly.

Core Features & Use Cases

  • Diagnostic workflow: health checks, error classification, offline SQL analysis, and guided fixes for dbt projects.
  • References & guidance: quick access to error guides, CLI commands, and best practices to navigate common dbt issues.
  • End-to-end recovery: from compilation to data verification, including upstream checks and downstream impact analysis.

Quick Start

Inspect the error output from a failing dbt run and initiate the following steps to diagnose and fix the issue.

Frequently Asked Questions about dbt-troubleshoot

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

FAQPage Schema
How do I debug dbt compilation and runtime errors?▼

To debug dbt errors, you need a structured diagnostic workflow that performs health checks, classifies the error, and analyzes the SQL offline. This isolates compilation failures and runtime database issues for targeted fixes.

What is the best way to troubleshoot failing dbt tests and data quality issues?▼

Troubleshooting dbt tests and data quality issues requires classifying the failure and validating upstream and downstream models. This approach identifies whether the problem stems from data inputs or model logic.

Do I need the altimate-dbt toolchain to diagnose dbt project issues?▼

Yes, diagnosing dbt project issues with this workflow requires the altimate-dbt toolchain and a ready environment. These dependencies enforce a deterministic process to validate fixes and restore correctness.

Can I use offline SQL analysis to fix dbt data models without a database connection?▼

Yes, offline SQL analysis evaluates dbt data models without direct database execution. It inspects compiled code to identify logical errors and guide targeted fixes before applying changes to the environment.

Why does my dbt workflow fail during runtime execution and how can I resolve it?▼

dbt runtime execution failures often stem from database connectivity or resource constraints. Resolving them requires running health checks, validating environment readiness, and applying guided fixes to restore the workflow.

Related Skills

Explore More Data & Analytics Skills→
matchaconematchacone

pre-flight

Validate environment variables, dependencies, database connectivity, and dev server startup.

Community
Intermediate
miptah21miptah21
2

debugging-dbt-errors

Trace dbt model failures to upstream causes and validate fixes.

Community
Advanced
johnnymo87johnnymo87
4

using-gcloud-bq-cli

Diagnose and fix gcloud and BigQuery authentication and permission issues.

Community
Advanced
Archive228Archive228
746

sql-review

Reviews SQL and ORM queries for injection risks, missing indexes, and bottlenecks.

Community
Intermediate