# Dbt Transformation Patterns

> <!-- AUTO-GENERATED by export-skills.py — DO NOT EDIT -->

- Skill: `frank-luongt/dbt-transformation-patterns-3` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx get-skill add frank-luongt/dbt-transformation-patterns-3`
- Raw SKILL.md: https://api.skillmd.com/api/skills/frank-luongt/dbt-transformation-patterns-3/raw
- Safety review: pending (external: skill-scanner PASS, skillspector CAUTION)
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: frank-luongt (https://skillmd.com/u/frank-luongt)
- Updated: 2026-09-21
- Page: https://skillmd.com/skills/frank-luongt/dbt-transformation-patterns-3

---

<!-- AUTO-GENERATED by export-skills.py — DO NOT EDIT -->
---
name: dbt-transformation-patterns
description: Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies. Use when building data transformations, creating data models, or implementing analytics engineering best practices.
---

# 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.

## Resources


<!-- Source: .faos/custom/skills/data/dbt-transformation-patterns/SKILL.md -->

