# Dbt Transformation Patterns > Production-ready patterns for dbt (data build tool) including model organization, testing strategies, documentation, and incremental processing. Use when this capability is needed. - Skill: `tomevault-io/dbt-transformation-patterns-3` (Agent Skill, multi-file: 2 files) - Install (CLI): `npx skillmds@latest add tomevault-io/dbt-transformation-patterns-3` - Raw SKILL.md: https://api.skillmd.com/api/skills/tomevault-io/dbt-transformation-patterns-3/raw - Safety review: pending - Works with: Claude Code, Claude.ai, OpenAI Codex - Category: AI & ML - Author: tomevault-io (https://skillmd.com/u/tomevault-io) - Updated: 2026-09-17 - Page: https://skillmd.com/skills/tomevault-io/dbt-transformation-patterns-3 --- # dbt Transformation Patterns Production-ready patterns for dbt (data build tool) including model organization, testing strategies, documentation, and incremental processing. ## Use this skill when - Building data transformation pipelines with dbt - Organizing models into staging, intermediate, and marts layers - Implementing data quality tests and documentation - Creating incremental models for large datasets - Setting up dbt project structure and conventions ## Do not use this skill when - The project is not using dbt or a warehouse-backed workflow - You only need ad-hoc SQL queries - There is no access to source data or schemas ## Instructions - Define model layers, naming, and ownership. - Implement tests, documentation, and freshness checks. - Choose materializations and incremental strategies. - Optimize runs with selectors and CI workflows. - If detailed patterns are required, open `resources/implementation-playbook.md`. ## Resources - `resources/implementation-playbook.md` for detailed dbt patterns and examples. --- > Converted and distributed by [TomeVault](https://tomevault.io/claim/sickn33) — claim your Tome and manage your conversions.