Can this skill help with data quality and testing?

Absolutely. It provides standardized patterns for defining source freshness, schema tests, and custom data validation tests within your dbt YAML files.

What data warehouses are these patterns compatible with?

The patterns are designed to be compatible with most modern data warehouses supported by dbt, including Snowflake, BigQuery, Redshift, and Databricks.

Does it support incremental data loading?

Yes, it includes specific patterns for various incremental strategies such as merge, delete+insert, and insert overwrite to handle large datasets efficiently.

How does this skill help with dbt model organization?

It implements a strict Medallion architecture, guiding the creation of staging, intermediate, and mart layers with standardized naming conventions like stg_, int_, dim_, and fct_.

dbt Transformation Patterns

Name: dbt Transformation Patterns
Author: Tahir-yamin

byTahir-yamin

•

Database Management

Implements production-ready dbt patterns for analytics engineering, including Medallion architecture, data testing, and incremental processing.

This skill provides a comprehensive set of dbt (data build tool) best practices and implementation patterns to help data engineers build robust, scalable analytics pipelines. It guides Claude in organizing models into a structured Medallion architecture—consisting of staging, intermediate, and marts layers—while implementing rigorous data quality tests and documentation. By leveraging advanced incremental strategies and reusable macros, this skill ensures your data transformations are optimized for performance and maintainability across modern cloud data warehouses.

Key Features

01DRY code implementation using custom dbt macros

02Advanced incremental materialization strategies including Merge and Insert Overwrite

03Automated data quality testing and source freshness patterns

043 GitHub stars

05Medallion architecture implementation (Staging, Intermediate, Marts)

06Standardized naming conventions for Dim and Fact tables

Use Cases

01Implementing automated data lineage and quality assurance tests

02Building scalable data transformation pipelines in modern cloud data warehouses

03Migrating monolithic SQL scripts into a structured, modular dbt project

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add tahir-yamin/dev-engineering-playbook dbt-transformation-patterns

For use in Claude.ai and ChatGPT

Download Skill