Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →wshobson/dbt-transformation-patterns
Master dbt (data build tool) for analytics engineering with model organization, testing, documentation, and incremental strategies.
Passed 19 of 23 test cases with the skill, and 17 of 23 without it.
2 fixed17 passed either way4 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
One of 2 test cases the skill fixed. Same model, same prompt, with and without the skill.
In our `dbt_project.yml` configuration file, we need to specify the custom schema target for models in the marts directory. Developers suggested leaving them in the default target schema or naming it `main`. What schema setting should be configured for the marts block?
| Checked | Without skill | With skill |
|---|---|---|
| Sets +schema to analytics for marts models. | Missed | Passed |
The instructions your model reads when the skill loads.
Production-ready patterns for dbt (data build tool) including model organization, testing strategies, documentation, and incremental processing.
sources/ Raw data definitions
↓
staging/ 1:1 with source, light cleaning
↓
intermediate/ Business logic, joins, aggregations
↓
marts/ Final analytics tables
| Layer | Prefix | Example |
|---|---|---|
| Staging | stg_ | stg_stripe__payments |
| Intermediate | int_ | int_payments_pivoted |
| Marts | dim_, fct_ | dim_customers, fct_orders |
# dbt_project.yml
name: "analytics"
test cases passed, vs 17 / 23 without
Published skills whose descriptions closely match this one, with their headline benchmark lift.
More skills from the same source and nearby in the registry, with their headline benchmark lift.