---
title: "dbt Transformation Patterns"
type: skill
id: "wshobson-agents/data-engineering/dbt-transformation-patterns"
category: "Data"
publisher: "Seth Hobson"
license: "MIT"
source: "https://github.com/wshobson/agents/tree/7e2fb55"
canonical: "https://labs.pho.chat/en/skills/wshobson-agents/data-engineering/dbt-transformation-patterns"
open_in_pho: "https://pho.chat/customize?item=wshobson-agents%2Fdata-engineering%2Fdbt-transformation-patterns&utm_source=labs&utm_medium=skill-page&utm_campaign=skills-library"
---

# dbt Transformation Patterns

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.

Source: Seth Hobson (MIT), copied at a pinned commit. Free to use. Part of the Phở Skills library (https://labs.pho.chat/en/skills).
Skill set: Data engineering and analytics (https://labs.pho.chat/en/skills/wshobson-agents/data-engineering.md).

## What it covers
- When to Use This Skill
- Core Concepts
  - 1. Model Layers (Medallion Architecture)
  - 2. Naming Conventions
- Quick Start
- Detailed patterns and worked examples
- Best Practices
  - Do's
  - Don'ts

## Other skills in this set
- [Apache Airflow DAG Patterns](https://labs.pho.chat/en/skills/wshobson-agents/data-engineering/airflow-dag-patterns.md): Build production Apache Airflow DAGs with best practices for operators, sensors, testing, and deployment. Use when creating data pipelines, orchestrating workflows, or scheduling batch jobs.
- [Data Quality Frameworks](https://labs.pho.chat/en/skills/wshobson-agents/data-engineering/data-quality-frameworks.md): Implement data quality validation with Great Expectations, dbt tests, and data contracts. Use when building data quality pipelines, implementing validation rules, or establishing data contracts.
- [Apache Spark Optimization](https://labs.pho.chat/en/skills/wshobson-agents/data-engineering/spark-optimization.md): Optimize Apache Spark jobs with partitioning, caching, shuffle optimization, and memory tuning. Use when improving Spark performance, debugging slow jobs, or scaling data processing pipelines.
- [Data Storytelling](https://labs.pho.chat/en/skills/wshobson-agents/data-engineering/data-storytelling.md): Transform data into compelling narratives using visualization, context, and persuasive structure. Use when presenting analytics to stakeholders, creating data reports, or building executive…
- [KPI Dashboard Design](https://labs.pho.chat/en/skills/wshobson-agents/data-engineering/kpi-dashboard-design.md): Design effective KPI dashboards with metrics selection, visualization best practices, and real-time monitoring patterns. Use this skill when building an executive SaaS metrics dashboard tracking…

## Use it
- In Phở: open https://pho.chat/customize?item=wshobson-agents%2Fdata-engineering%2Fdbt-transformation-patterns&utm_source=labs&utm_medium=skill-page&utm_campaign=skills-library and press Try, or add it so Phở loads it whenever a request matches. Phở works with your own API key (OpenAI, Anthropic, Google and others).
- Full instructions (original SKILL.md, unchanged): https://labs.pho.chat/skills/raw/wshobson-agents/data-engineering/skills/dbt-transformation-patterns/SKILL.md
- Original files: https://github.com/wshobson/agents/tree/7e2fb55 (MIT).
- Full machine-readable index: https://labs.pho.chat/skills.json