AGENT SKILL

dbt

Data build tool: SQL compilation, Jinja templating, incremental models, snapshots (SCD Type 2), and automated testing

License 许可
MIT
最近更新
2026-11-09
Stars
★ 0
Forks
0

01 前言 Front Matter

name
dbt
risk
low
source
https://github.com/Mr-Nobody-Anonymous/All-skills
license
MIT
version
1.0.0
category
data-engineering
description
Data build tool: SQL compilation, Jinja templating, incremental models, snapshots (SCD Type 2), and automated testing
imported_at
2026-09-20
source_path
awesome_skills/data-engineering/dbt/SKILL.md
source_repository
Mr-Nobody-Anonymous/All-skills
disable-model-invocation
false

03 SKILL.md 正文

dbt (Data Build Tool) Modeling

Scope

dbt enables analytics engineering by bringing software engineering best practices (modularity, version control, testing, CI/CD) to SQL transformations inside data warehouses.

Core Features & Design

  • Lineage Graph (ref function): SELECT * FROM {{ ref('stg_orders') }} compiles dependencies into a directed acyclic execution graph.
  • Incremental Materialization:
    {{ config(materialized='incremental', unique_key='event_id') }}
    SELECT * FROM {{ ref('stg_events') }}
    {% if is_incremental() %}
      WHERE event_timestamp > (SELECT MAX(event_timestamp) FROM {{ this }})
    {% endif %}
    
  • Snapshots (Slowly Changing Dimensions Type 2): Tracking historical state changes over time using valid-from and valid-to timestamps.

Tools & Standards

  • Software: dbt Core, dbt Cloud.

04 同仓库更多 Skills