dbt

Analytics engineering as software: models, refs, tests, docs and incremental materialisations. This path sequences the category's 20 resources by roadmap stage and composite score — work top-down inside each step.

Warehousing

1. dbt Test Writer 40.5 — Generate the minimum test set that actually protects a model.
2. dbt Model Review 40.5 — Review a dbt model for grain, materialisation, and incremental correctness.
3. dbt MCP Server 38.2 — dbt MCP Server
4. dbt as Models + Tests + Docs 35.75 — dbt as Models + Tests + Docs
5. Run the dbt warehouse tests starter end to end 34.15 — Run the dbt warehouse tests starter end to end
6. The warehouse mental model — micro-partitions, clustering, scan vs compute 34.15 — The warehouse mental model — micro-partitions, clustering, scan vs compute

14 more on the category page.

Documented prerequisites, deduplicated: skill-dbt-model-review, skill-sql-review.

• Rank tests by the cost of the failure they prevent
• Write a custom singular test
• Wire freshness on a source
• State a model's grain and match it to its unique key test
• Choose table vs incremental vs view deliberately
• Handle late data in an incremental model
• Layer staging, intermediate, and marts models
• Run the seed/build/docs loop the starter ships with

Security-flagged: dbt Test Writer, dbt Model Review, dbt MCP Server, dbt → warehouse → tests → docs, dbt Full-Refresh Guard, dbt Workbench, dbt Project Template — review the security posture first. Verification on these records: 20 community. Nothing here is independently audited — the trust scan and your own review are the controls.

Phase 1 of the roadmap. Stage context: Warehousing · side-by-side comparison · all learning topics