Dbt
dbt data transformation with SQL. Use for data pipelines.From its SKILL.md
npx -y skills add G1Joshi/Agent-Skills --skill dbtAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
One thing to look at
- 12 stars12 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
SKILL.md
1.0 KB, 244 tokens by cl100k_base, as published. Nobody here has run it
dbt (Data Build Tool)
dbt manages data transformation in the warehouse using SQL. v2.0 introduces the Fusion Engine (Rust) for performance.
When to Use
- Data Modeling: Converting raw tables into "Gold" tables.
- Testing:
not_null,uniquetests defined in YAML. - Documentation: Auto-generating data dictionaries.
Core Concepts
Models (.sql)
Select statements that dbt compiles into CREATE VIEW/TABLE.
Refs ({{ ref('users') }})
Dependency management. dbt builds the DAG automatically.
Semantic Layer
Defining metrics ("Revenue") in code so all BI tools use the same definition.
Best Practices (2025)
Do:
- Use Git: Treat data models like software code.
- Use Incremental Models: Only process new data to save cost.
- Use dbt Mesh: For cross-project dependencies in large orgs.
Don't:
- Don't put logic in BI tools: Put it in dbt.
References
What ships with it
Read from the repository
Just SKILL.md. No reference files, no scripts.