testing

DE//AGENT currently lists 12 resources under testing: 5 tutorials, 2 skills, 2 templates. 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 plugin, 1 agent, 1 pattern.

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
• Test a transform without a Spark cluster — via Pipeline Test Author
• Assert invariants instead of golden files — via Pipeline Test Author
• Make a pipeline test deterministic — via Pipeline Test Author
• Layer staging, intermediate, and marts models — via Run the dbt warehouse tests starter end to end
• Run the seed/build/docs loop the starter ships with — via Run the dbt warehouse tests starter end to end

13 more objectives live on the individual resource pages.

These resources map to stages: Warehousing (7), Data Processing (2), Reliability (2), Data Quality (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. Pipeline Test Author score 38 — intermediate
3. dbt as Models + Tests + Docs score 35.75 — beginner

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

Start here if you're new: dbt Test Writer, dbt as Models + Tests + Docs, Run the dbt warehouse tests starter end to end, Start a PySpark project from the template.

Security-flagged entries: dbt Test Writer (1 flag), Pipeline Test Author (2 flags), PySpark Project Template (2 flags), Data Quality Reviewer (2 flags), dbt Workbench (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.

Known limits: A single ad-hoc query,Non-SQL-heavy processing (dbt as Models + Tests + Docs)

• 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
• Pipeline Test Author — Builds a local DuckDB/pyarrow harness with tiny fixtures so pipeline logic is testable in CI without a cluster, and asserts on invariants, not snapshots. details
• Run the dbt warehouse tests starter end to end — Clone the dbt-warehouse-tests starter, seed its deterministic customers and orders data, and build the staging → intermediate → marts pipeline with dbt build --target dev. You serv… details
• Start a PySpark project from the template — Scaffold a testable PySpark project with one command and learn where each piece lives: transforms in src/, 3-10 row fixtures in tests/data/, and a Makefile that runs lint plus test… 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 pipeline-test-author

Pipeline Test Author — review first

amp template new de-agent/pyspark-project ./my-pipeline

PySpark Project Template — review first

amp plugin add de-agent/dbt-workbench

dbt Workbench — review first

Adjacent topics: tutorial (5 shared), data-quality (3 shared), ci (3 shared), template (3 shared), dbt (2 shared), review (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.