best-practices

DE//AGENT currently lists 2 resources under best-practices: 1 tutorial, 1 reference. Everything below is derived from the live registry — counts, capabilities, verification state and security posture come from the curated records, never from marketing copy.

Documented learning objectives across these resources:

• Audit a warehouse project against the model-tests-docs triad — via Capstone — the warehousing checklist, end to end
• Verify layering, grain, incremental lookback, and CI staging on one project — via Capstone — the warehousing checklist, end to end
• Leave a repo whose structure a new joiner can read — via Capstone — the warehousing checklist, end to end

These resources map to stage: Warehousing (2). Follow the four-phase roadmap to place this topic inside a progression instead of learning it in isolation.

Every entry, its shape and its trust state — sorted by the registry's composite score. This table is the honest version of a marketing comparison: no sponsored placements, no unverifiable claims.

How scores are computed: source quality score.

Highest composite score first:

1. Capstone — the warehousing checklist, end to end score 34.15 — intermediate
2. dbt Best Practices Guide score 27.7 — difficulty not documented

Scores rank provenance, completeness and trust — read how verification works before adopting anything.

• Capstone — the warehousing checklist, end to end — Close the series by auditing one warehouse project against everything it taught: models with tests and docs, layered staging to marts with a declared grain, incremental loads with … details
• dbt Best Practices Guide — dbt Labs' official best practices guide — project structure, staging/marts layering, naming conventions, testing conventions (unique, not_null, relationships, accepted_values), mod… details

Study path: the roadmap places this topic in a progression · the scoring model explains the numbers · the trust rule catalog shows every security check these entries passed through.