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 (
reffunction):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
dei-assessment
Assess diversity, equity, and inclusion with metrics. TRIGGERS - Use when user needs help with dei-assessment related tasks.
dei-action-plan
Create DEI action plans with goals and initiatives. TRIGGERS - Use when user needs help with dei-action-plan related tasks.
culture-fit-assessment
Design culture add assessment processes. TRIGGERS - Use when user needs help with culture-fit-assessment related tasks.
cowork-to-code-bridge
Use an already-installed, independently verified cowork-to-code bridge to run narrowly approved actions on the user's own macOS, Linux, or WSL2 machine through a local file queue.
counter-offer-response
Draft counter-offer responses for retention. TRIGGERS - Use when user needs help with counter-offer-response related tasks.
continuous-feedback-system
Design continuous feedback systems. TRIGGERS - Use when user needs help with continuous-feedback-system related tasks.