Keep the warehouse trustworthy: dbt tests (not_null/unique/accepted_values/relationships) gating the build in CI, source-freshness checks, model contracts at consumer boundaries, singular tests for business invariants, and anomaly detection beyond schema tests.
Scanned 9/23/2026
Skills Directorynpx -y skills add mcorbett51090/RavenClaude --skill data-quality-testing --agent claude-codeInstalls into .claude/skills of the current project.
Are you the author of Data Quality Testing?
Add the live security badge to your README — it updates automatically with every re-scan.
[](https://www.skillsdirectory.com/skills/mcorbett51090-data-quality-testing)More formats (shields.io, HTML) on the badges page. Keep it an A: scan every change in CI with Pro.
---
name: data-quality-testing
description: "Keep the warehouse trustworthy: dbt tests (not_null/unique/accepted_values/relationships) gating the build in CI, source-freshness checks, model contracts at consumer boundaries, singular tests for business invariants, and anomaly detection beyond schema tests."
---
# Data Quality Testing
## Test like code
not_null / unique / accepted_values / relationships on the columns that matter; **build fails** on violation. Untested transforms = silent downstream corruption.
## Freshness
Assert source freshness; **stop** rather than serve stale marts as fresh.
## Contracts
Model contracts (names/types/constraints) on consumer-facing models so upstream changes can't silently break a dashboard.
## Beyond schema
Singular tests for business invariants (line items sum to order total). **Anomaly detection** (row-count drop, distribution shift) catches what schema tests miss -> significance to `applied-statistics`.
Is this your skill, or is something wrong with this listing? Request removal or report an issue. Author removals are honored within 72 hours.
No comments yet. Be the first to comment!
