How does it handle failing data tests?

The skill compiles the test SQL and uses data discovery techniques to query the underlying warehouse data, helping you understand if the failure is a code bug or a data quality issue.

Does it help in preventing future failures?

Yes, the resolution workflow specifically recommends adding unit tests for logic issues or data tests for quality issues to prevent regressions.

When should I use the troubleshooting-dbt-job-errors skill?

Use this skill when a dbt Cloud or platform job fails in a remote environment. It is designed for production or CI/CD job diagnostics rather than local development errors.

Can this skill work without dbt Admin API access?

Yes, if the API is unavailable, the skill provides instructions for the user to provide manual artifacts like run_results.json and debug logs for analysis.

What if the root cause cannot be identified?

Instead of guessing, the skill guides the agent to create a detailed findings document that tracks what was checked, ensuring the investigation trail is preserved for human review.

dbt Job Error Diagnostics

Name: dbt Job Error Diagnostics
Author: dbt-labs

bydbt-labs

•

304

•

分析与监控

Diagnoses and resolves dbt Cloud job failures by analyzing run logs, Admin API data, git history, and underlying data issues.

This skill provides a systematic workflow for identifying the root cause of failures in dbt Cloud and platform environments. It enables AI agents to query the dbt Admin API for run history, analyze execution artifacts like run_results.json, and perform deep-dive investigations into infrastructure, code compilation, and data test failures. By integrating git history analysis and data discovery techniques, it ensures that fixes address the actual source of the problem rather than merely hiding symptoms through test modifications, making it essential for maintaining production data reliability.

主要功能

01Standardized resolution patterns including unit testing and structured findings documentation

02Automated dbt Cloud Admin API integration for fetching run history and error context

03Systematic classification of errors into infrastructure, code, or data-driven categories

04Step-by-step data investigation workflow to query failing test results directly

05Correlation of git history with job failures to identify breaking changes in recent merges

06304 GitHub stars

使用场景

01Diagnosing intermittent or unclear failures in scheduled dbt Cloud production jobs

02Investigating post-merge regressions where a recent code change caused data quality issues

03Automating the retrieval and analysis of run_results.json artifacts for detailed error context

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add dbt-labs/dbt-agent-skills troubleshooting-dbt-job-errors

For use in Claude.ai and ChatGPT

Download Skill