dbt-artifacts

Monitor dbt execution metadata and track runs across environments and versions.

34|13|Updated Feb 1, 2022
One-click install
npx skills add https://github.com/sfc-gh-dflippo/snowflake-dbt-demo --skill dbt-artifacts
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: dbt-artifacts
Source: https://github.com/sfc-gh-dflippo/snowflake-dbt-demo/tree/main/.claude/skills/dbt-artifacts
Command: npx skills add https://github.com/sfc-gh-dflippo/snowflake-dbt-demo --skill dbt-artifacts

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires brooklyn-data/dbt_artifacts, and includes scripts (resource) components.

What problem does it solve?

This Skill solves the challenge of tracking and analyzing dbt execution history across multiple platforms and environments, providing comprehensive monitoring for data pipeline reliability.

Core Features & Use Cases

  • Execution Monitoring: Track test and model execution status, performance metrics, and data quality results.
  • Historical Analysis: Analyze dbt run patterns, performance trends, and reliability metrics over time.
  • Use Case: When you need to identify flaky tests, detect slow models, or analyze execution patterns across your entire dbt project history.

Quick Start

Use the dbt-artifacts skill to show recent test failures from the last 7 days and identify which tests need immediate attention.

Frequently Asked Questions about dbt-artifacts

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

FAQPage Schema
How do I monitor dbt execution and track test failures over time?

Monitoring dbt execution captures historical run metadata including test results, model status, and runtime performance. This Skill stores per-run artifacts in structured tables (invocations, model_executions, test_executions) joined by command_invocation_id and node_id, enabling you to query patterns across environments and versions to identify flaky tests and performance trends.

What data does dbt generate that I can analyze for performance insights?

dbt produces execution artifacts including test pass/fail status, model runtime duration, data quality results, and dependency metadata. This Skill exposes these artifacts through core tables and join patterns, allowing you to analyze run history, detect slow models, and audit execution context across your entire project.

Can I use dbt-artifacts to track runs across multiple Snowflake environments?

Yes. This Skill tracks dbt runs across environments and versions with support for installation and configuration across platforms. It captures run context and dependencies in standardized tables, enabling cross-environment observability and auditing of your data pipeline execution.

How do I identify which dbt tests are failing most frequently?

Query the test_executions table joined with invocations by command_invocation_id to surface test status and execution history. Aggregate results over time to rank failing tests, identify patterns, and prioritize which tests need immediate attention for data quality improvement.

What's the best way to audit dbt execution history for compliance?

This Skill stores comprehensive execution metadata—status, runtime, test results, run context, and dependencies—in queryable tables with standardized join keys. This creates an auditable record of all dbt runs, enabling compliance tracking, root-cause analysis, and historical comparison across versions.

Do I need a data warehouse to use dbt execution monitoring?

This Skill requires Snowflake and depends on the brooklyn-data/dbt_artifacts package. It captures artifacts into Snowflake tables, so you need Snowflake configured as your dbt target to store and query execution metadata.