Can I use it to automate dbt documentation?

Absolutely. It includes patterns for YAML-based documentation and descriptions that power the dbt docs generated site.

How does this skill handle large datasets?

It implements various incremental materialization strategies including Merge, Delete+Insert, and Insert Overwrite to optimize processing time and cost.

What layers of the Medallion Architecture are supported?

This skill provides specific patterns for Staging (stg_), Intermediate (int_), and Marts (fct_ and dim_) layers to ensure clear data lineage.

Does it include data quality testing?

Yes, it provides boilerplate for source freshness checks, unique/not-null tests, and relationship testing between models.

dbt Transformation Patterns

Name: dbt Transformation Patterns
Author: EngineerWithAI

byEngineerWithAI

データベース管理

Implements production-ready dbt patterns for scalable data modeling and analytics engineering.

概要

This skill equips Claude with specialized dbt (data build tool) expertise to architect and build robust data transformation pipelines. It follows the Medallion Architecture—organizing code into Staging, Intermediate, and Marts layers—while enforcing best practices for naming conventions, source definitions, and modular testing. Whether you are refactoring monolithic SQL into manageable models or optimizing large-scale data processing with advanced incremental strategies, this skill ensures your data warehouse remains reliable, well-documented, and highly maintainable.

主な機能

Medallion Architecture implementation (Staging, Intermediate, Marts)
Automated data quality testing and source freshness patterns
0 GitHub stars
DRY (Don't Repeat Yourself) macro development for reusable SQL
Advanced Incremental loading strategies (Merge, Delete+Insert, Overwrite)
Surrogate key generation and relationship documentation

ユースケース

Implementing data governance through schema testing and documentation
Optimizing performance for large datasets using incremental materialization
Migrating legacy monolithic SQL scripts into modular dbt models

概要

主な機能

Medallion Architecture implementation (Staging, Intermediate, Marts)
Automated data quality testing and source freshness patterns
0 GitHub stars
DRY (Don't Repeat Yourself) macro development for reusable SQL
Advanced Incremental loading strategies (Merge, Delete+Insert, Overwrite)
Surrogate key generation and relationship documentation

ユースケース

Implementing data governance through schema testing and documentation
Optimizing performance for large datasets using incremental materialization
Migrating legacy monolithic SQL scripts into modular dbt models