skills.rest
shapris
shaprisCOMMUNITY
Explore all skills by this author →
GitHub

dbt

Automate dbt model building, unit tests, semantic layer YAML, and job failure diagnosis.

Updated Mar 22, 2026
Search Tags:#troubleshooting#cli#dbt#unit-tests#model-discovery#semantic-layer#analytics-engineering
One-click install
npx skills add https://github.com/shapris/svarus-darbas --skill dbt-shapris
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: dbt
Source: https://github.com/shapris/svarus-darbas/tree/main/.kilocode/skills/dbt
Command: npx skills add https://github.com/shapris/svarus-darbas --skill dbt-shapris

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Analytics teams need a consistent, safe, and repeatable way to author, test, validate, and troubleshoot dbt projects across dbt Core, Fusion, and dbt Cloud. This Skill centralizes guidance and operational instructions so engineers and AI agents can build models, add unit tests, query the semantic layer, and diagnose job failures without guesswork.

Core Features & Use Cases

  • Model authoring & planning: guidance for planning models, choosing materializations, and following DRY best practices.
  • Test-driven development: generate and run dbt unit tests, fixture management, and CI-friendly recommendations.
  • Semantic layer & metrics: create or modify semantic models, metrics, time spines, and validate via MetricFlow or dbt sl tools.
  • CLI & job troubleshooting: format and run dbt CLI commands safely, analyze run_results.json, and investigate dbt Cloud job failures.
  • Docs & discovery: fetch dbt docs in LLM-friendly markdown and explore project artifacts for discovery and impact analysis.

Quick Start

Ask the dbt skill to "build and unit-test model orders, list downstream impact, and show the first 10 rows of the compiled model."

Frequently Asked Questions about dbt

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

FAQPage Schema
How do I write unit tests for dbt models?▼

To write dbt unit tests, generate YAML unit test fixtures validating model logic against expected inputs and outputs. This Skill automates fixture management and provides CI-friendly recommendations for test-driven development.

How do I troubleshoot dbt job failures and analyze run_results.json?▼

Troubleshoot dbt job failures by analyzing run_results.json artifacts to identify error sources, formatting safe dbt CLI commands, and investigating dbt Cloud execution issues. This Skill provides clear remediation guidance for failed runs.

What is the best way to create semantic models and metrics in dbt?▼

Create dbt semantic models and metrics by authoring semantic layer YAML files for metrics and time spines. This Skill helps you build and validate semantic structures using MetricFlow or dbt sl tools.

Can I use this for dbt Core, Fusion, and dbt Cloud projects?▼

Yes, this Skill applies to dbt Core, Fusion, and dbt Cloud projects. It supports CLI command formatting, semantic layer edits, unit-test generation, and MCP/Admin API troubleshooting across these dbt environments.

How do I discover downstream impact and fetch dbt docs for my project?▼

Discover downstream impact and fetch dbt docs by exploring project artifacts in LLM-friendly markdown. This Skill enables model discovery and impact analysis to understand dependencies before modifying dbt models.

Why should I use unit tests instead of just data tests in dbt?▼

Unit tests validate model transformation logic against mocked inputs, whereas standard dbt data tests check raw output state. This Skill generates unit test fixtures to catch logic errors during development before CI execution.

Related Skills

Explore More Data & Analytics Skills→
astronomerastronomer
419

cosmos-dbt-core

Convert dbt Core projects into Airflow DAGs or TaskGroups using Astronomer Cosmos.

Official
Advanced
shaprisshapris

using-dbt-for-analytics-engineering

Build and modify dbt models with ref() and source() macros.

Community
Advanced
shaprisshapris

answering-natural-language-questions-with-dbt

Generates and executes SQL to answer natural-language business questions using dbt semantic layer or compiled SQL.

Community
Advanced
borgheiborghei
467

analytics-engineer

Model data and build dbt pipelines from staging to marts.

Community
Advanced