Does this skill support incremental dbt models?

Yes, it includes detailed patterns for Merge, Delete+Insert, and Insert Overwrite strategies to handle large-scale data processing efficiently.

Can I use this to create custom dbt macros?

Absolutely. It includes patterns for common macros like currency conversion, custom schema generation, and environment-based data limiting for development.

What is the Medallion architecture used in this skill?

The Medallion architecture organizes data into three distinct layers: Staging (raw cleaning), Intermediate (business logic and joins), and Marts (final analytics-ready dimensions and facts).

How does it help with data quality?

It provides standardized YAML patterns for schema tests, unique/not-null constraints, and relationship checks to ensure data integrity across your entire pipeline.

dbt Analytics Engineering Patterns

Name: dbt Analytics Engineering Patterns
Author: duanbiao2000

byduanbiao2000

0•

Database Management

Implements production-grade dbt patterns for organized, scalable, and well-tested analytics engineering pipelines.

This skill provides a comprehensive framework for building robust data transformation pipelines using dbt (data build tool). It guides developers through the implementation of the Medallion architecture, organizing data into staging, intermediate, and marts layers while enforcing industry-standard naming conventions. By providing ready-to-use patterns for incremental processing, custom Jinja macros, and automated testing, it enables teams to build maintainable, high-performance data warehouses with clear lineage and rigorous documentation.

Key Features

01Standardized naming conventions for dimensions and facts

02Reusable Jinja macros for DRY (Don't Repeat Yourself) SQL code

03Automated data quality testing and documentation patterns

040 GitHub stars

05Medallion architecture implementation (Staging, Intermediate, Marts)

06Advanced incremental loading strategies including Merge and Insert Overwrite

Use Cases

01Refactoring complex SQL transformations into a layered, maintainable model architecture.

02Setting up a professional dbt project structure for a new data warehouse.

03Optimizing performance for large datasets using incremental materialization patterns.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add duanbiao2000/obsidiandoc26 dbt-transformation-patterns

For use in Claude.ai and ChatGPT

Download Skill