skills.rest
DKSang
DKSangCOMMUNITY
Explore all skills by this author →
GitHub

des-dbt-engineering

Convert DES phase artifacts into dbt implementations with contract-aware validation.

2|Updated May 20, 2026
Search Tags:#testing#data modeling#dbt#data contracts#evidence pack#staging-intermediate-marts
One-click install
npx skills add https://github.com/DKSang/DES-SKILL --skill des-dbt-engineering
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: des-dbt-engineering
Source: https://github.com/DKSang/DES-SKILL/tree/main/skills-stack/des-dbt-engineering
Command: npx skills add https://github.com/DKSang/DES-SKILL --skill des-dbt-engineering

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

It helps agents translate DES lifecycle artifacts into correct, testable, and well-documented dbt work so implementations respect DES meaning, contracts, and Done Gates instead of becoming ad-hoc SQL changes.

Core Features & Use Cases

  • DES-to-dbt implementation workflow: uses DES phase outputs (Silver/Gold specifications, data contracts, handoffs, evidence) to plan and implement dbt models that align with the intended grain and responsibilities.
  • dbt modeling, testing, and documentation guidance: structures staging/intermediate/mart work using DES-aware conventions, focusing on ref()/source(), model grain clarity, and high-value tests (including unit tests for complex logic).
  • Evidence-first completion: produces dbt evidence packs and review reports aligned to DES phase Done Gates using command results (e.g., manifest/run/test artifacts) rather than relying on untracked runs.

Quick Start

Use this skill when implementing DES Phase 10–16 dbt work by first reading the relevant DES planning artifacts and then building the needed dbt models, tests, docs, and evidence in a DES-safe, scoped manner.

Frequently Asked Questions about des-dbt-engineering

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

FAQPage Schema
How do I convert data contracts into dbt models with proper staging and marts layering?▼

Structure dbt staging, intermediate, and mart layers by reading DES planning artifacts to define model grain and responsibilities. Apply ref() and source() functions correctly to establish dependencies and capture evidence in the DES output structure for Done Gate validation.

What is the best way to generate dbt evidence packs from run and test artifacts?▼

Capture manifest, run, and test command artifacts to build dbt evidence packs aligned to DES Done Gates. This validates implementations using tracked command results rather than untracked runs, ensuring contract-aware verification.

Does dbt unit testing work for complex intermediate model logic across multiple adapters?▼

dbt unit testing applies to complex logic across multiple dbt adapters by structuring scoped CI and runtime checks. This validates intermediate transformations while enforcing DES-aware conventions and contract alignment regardless of the target adapter.

How to plan dbt source onboarding without an existing dbt project?▼

Generate an implementation plan to safely onboard dbt sources and staging models when an existing project is missing. This enforces DES handoff alignment by using source() functions and capturing evidence in the DES output structure from the start.

Why does my dbt model grain not align with the intended data contract specifications?▼

dbt model grain misalignment occurs when DES Silver/Gold specifications are not mapped to correct staging, intermediate, and mart layer responsibilities. Enforce grain clarity by applying DES-aware conventions, ref() functions, and contract-aware validation during implementation.

Related Skills

Explore More Software Engineering Skills→
DKSangDKSang
2

des-gold-layer-design

Designs and validates Gold Layer specifications from Silver inputs for Phase 11 data engineering workflows.

Community
Advanced
DKSangDKSang
2

des-airflow-orchestration

Orchestrate DES workflows into scheduled Apache Airflow DAGs with validation gates.

Community
Advanced
heaptracetechnologyheaptracetechnology
13

contract-test

Automate API contract testing with schema validation and OpenAPI checks.

Community
Advanced
AltimateAIAltimateAI

migrating-sql-to-dbt

Convert SQL stored procedures, views, and raw SQL files into dbt models.

Official
Intermediate