How does it handle data quality and testing?

The skill provides patterns for schema tests, unique/null constraints, relationship testing between models, and custom data validation macros.

Can this skill help with dbt documentation?

Yes, it includes standardized YAML patterns for documenting models, sources, and columns to ensure clear data lineage and discovery.

Does it support incremental loading for large datasets?

Yes, it includes patterns for various incremental strategies including merge, delete+insert, and partition-based insert-overwrite.

What architecture does this dbt skill follow?

It implements the Medallion architecture, organizing data into staging (raw cleaning), intermediate (business logic), and marts (analytics-ready) layers.

dbt Transformation Patterns

Name: dbt Transformation Patterns
Author: wshobson

bywshobson

•

23,194

•

Database Management

Implements production-ready dbt patterns for scalable data modeling, automated testing, and analytics engineering workflows.

This skill equips Claude with specialized knowledge of dbt (data build tool) best practices, enabling the architecting of robust, scalable analytics pipelines. It provides standardized implementation patterns for Medallion architecture (staging, intermediate, and marts layers), advanced incremental loading strategies, and comprehensive data quality testing. Whether you are refactoring legacy SQL or building a new data warehouse, this skill ensures your models follow strict naming conventions, maintainable project structures, and DRY code principles through macro development.

Key Features

01Medallion architecture implementation (staging, intermediate, marts)

02Automated data quality testing and documentation patterns

03Reusable macro development for DRY SQL transformations

04Standardized naming conventions and directory structures

05Advanced incremental model strategies for large-scale data

0623,194 GitHub stars

Use Cases

01Migrating legacy monolithic SQL scripts into modular dbt models

02Implementing automated data freshness and relationship testing

03Building scalable data transformation pipelines from raw cloud sources

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add wshobson/agents dbt-transformation-patterns

For use in Claude.ai and ChatGPT

Download Skill