dbt

DE//AGENT currently lists 9 resources under dbt: 5 skills, 2 templates, 1 rule pack. Everything below is derived from the live registry — counts, capabilities, verification state and security posture come from the curated records, never from marketing copy.

Also present: 1 project.

Documented learning objectives across these resources:

• Rank tests by the cost of the failure they prevent — via dbt Test Writer
• Write a custom singular test — via dbt Test Writer
• Wire freshness on a source — via dbt Test Writer
• State a model's grain and match it to its unique key test — via dbt Model Review
• Choose table vs incremental vs view deliberately — via dbt Model Review
• Handle late data in an incremental model — via dbt Model Review
• Apply backward/forward compatibility rules to a diff — via Schema Change Contract Review
• Detect a breaking change hidden behind a "safe" rename — via Schema Change Contract Review

14 more objectives live on the individual resource pages.

These resources map to stages: Python + SQL (1), Warehousing (4), Data Quality (3), Orchestration (1). 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. dbt Test Writer score 40.5 — beginner
2. dbt Model Review score 40.5 — intermediate
3. Schema Change Contract Review score 40.5 — intermediate

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

Start here if you're new: dbt Test Writer, SQLFluff Core Rule Pack, dbt → warehouse → tests → docs, dbt Project Template.

Reach for these with production experience: Backfill Planner.

Security-flagged entries: dbt Test Writer (1 flag), dbt Model Review (1 flag), Schema Change Contract Review (1 flag), SQLFluff Core Rule Pack (1 flag), Backfill Planner (1 flag), Data Contract Author (1 flag), Data Contract Template (2 flags), dbt → warehouse → tests → docs (4 flags), dbt Project Template (4 flags). Flags mean the record declares capabilities like credential use or write access — read the security posture on each page before connecting.

• dbt Test Writer — Proposes dbt tests ranked by blast radius: uniqueness/not-null on the grain key, accepted values on enums, relationships on foreign keys, and freshness on sources. details
• dbt Model Review — Checks a dbt model's grain statement, ref/dependency hygiene, incremental strategy and late-arriving-data handling, then proposes a test set. details
• Schema Change Contract Review — Diffs an old and new schema, classifies the change (compatible / risky / breaking) against consumers, and produces the migration and comms plan. details
• SQLFluff Core Rule Pack — A curated SQLFluff configuration with rules optimized for modern data engineering workflows. Includes dialect-specific rules for dbt (Jinja), Spark SQL, Snowflake, BigQuery, and Re… details

Real install commands from the registry — read the source before running any of them:

npx de-agent-platform add dbt-test-writer

dbt Test Writer — review first

npx de-agent-platform add dbt-model-review

dbt Model Review — review first

npx de-agent-platform add schema-change-contract-review

Schema Change Contract Review — review first

pip install sqlfluff==3.0.0 sqlfluff-templater-dbt

SQLFluff Core Rule Pack — review first

Official source: dbt (license: Apache-2.0) — start there for the canonical documentation, then come back for the vetted registry entries.

Adjacent topics: Apache Avro (2 shared), Apache Spark (2 shared), data-quality (2 shared), ci (2 shared), testing (2 shared), template (2 shared).

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.