Skill

dbt

Provides dbt patterns for building staging, intermediate, and marts data models, incremental materializations, schema tests, and transformation pipelines in analytics engineering.

dbt

SQL

data-engineering

npx claudepluginhub jpoutrin/product-forge --plugin devops-data

Tool Access

This skill uses the workspace's default tool permissions.

Preview

This skill provides dbt patterns for analytics engineering.

SKILL.md

Similar Skills

dbt Transformation Patterns

faos-data-engineer

dbt-transformation-patterns

682

Provides production-ready dbt patterns for model organization (staging, intermediate, marts), testing, documentation, and incremental strategies. Use for data transformation pipelines and analytics engineering.

1 file

rmyndharis-antigravity-skills

dbt-coder

Provides dbt patterns for model organization in staging, intermediate, and marts layers, including project structure, sources, configs, SQL examples, and testing setups. Useful for data transformation projects.

1 tool

majestic-data

Stats

Parent Repo Stars7

Parent Repo Forks0

Last CommitFeb 4, 2026

Actions

View Source View Plugin View on GitHub View README

Help us improve

Share bugs, ideas, or general feedback.

dbt Skill

This skill provides dbt patterns for analytics engineering.

Project Structure

dbt_project/ ├── dbt_project.yml ├── models/ │ ├── staging/ │ │ └── stg_customers.sql │ ├── intermediate/ │ │ └── int_customer_orders.sql │ └── marts/ │ └── fct_orders.sql ├── seeds/ ├── macros/ ├── tests/ └── snapshots/

Model Patterns

Staging Models

-- models/staging/stg_customers.sql with source as ( select * from {{ source('raw', 'customers') }} ), renamed as ( select id as customer_id, lower(email) as email, created_at from source ) select * from renamed

Incremental Models

-- models/marts/fct_orders.sql {{ config( materialized='incremental', unique_key='order_id' ) }} select * from {{ ref('stg_orders') }} {% if is_incremental() %} where updated_at > (select max(updated_at) from {{ this }}) {% endif %}

Testing

# models/schema.yml models: - name: stg_customers columns: - name: customer_id tests: - unique - not_null - name: email tests: - unique

Best Practices

Use staging → intermediate → marts pattern

Source all raw data with source()

Reference models with ref()

Add documentation and tests

Use incremental models for large datasets

dbt Skill

This skill provides dbt patterns for analytics engineering.

Project Structure

dbt_project/
├── dbt_project.yml
├── models/
│   ├── staging/
│   │   └── stg_customers.sql
│   ├── intermediate/
│   │   └── int_customer_orders.sql
│   └── marts/
│       └── fct_orders.sql
├── seeds/
├── macros/
├── tests/
└── snapshots/

Model Patterns

Staging Models

-- models/staging/stg_customers.sql
with source as (
    select * from {{ source('raw', 'customers') }}
),

renamed as (
    select
        id as customer_id,
        lower(email) as email,
        created_at
    from source
)

select * from renamed

Incremental Models

-- models/marts/fct_orders.sql
{{
    config(
        materialized='incremental',
        unique_key='order_id'
    )
}}

select *
from {{ ref('stg_orders') }}
{% if is_incremental() %}
where updated_at > (select max(updated_at) from {{ this }})
{% endif %}

Testing

# models/schema.yml
models:
  - name: stg_customers
    columns:
      - name: customer_id
        tests:
          - unique
          - not_null
      - name: email
        tests:
          - unique

Best Practices

Use staging → intermediate → marts pattern
Source all raw data with source()
Reference models with ref()
Add documentation and tests
Use incremental models for large datasets