Data-quality tooling spans multiple categories
Data quality can be validated through SQL, pipeline tests, rule engines, profiling tools, reconciliation utilities, observability platforms, and data-contract frameworks.
Core capabilities
- Schema validation
- Null/range rules
- Uniqueness
- Referential integrity
- Reconciliation
- Profiling
- Drift detection
- Lineage
- Alerting
- Audit trail
Tool families
| Category | Typical role |
|---|---|
| SQL/dbt-style tests | Transformation and model validation |
| Rule frameworks | Reusable data-quality checks |
| Data observability | Freshness, volume, schema, anomaly monitoring |
| Reconciliation tools | Source-to-target comparison |
| Enterprise DQ platforms | Profiling, governance, stewardship, rules |
Examples
Common approaches include SQL-based validation, dbt tests, Great Expectations-style frameworks, Soda-style checks, and enterprise data-quality platforms.
Evaluate business-rule support
Technical checks are not enough. The selected approach should support meaningful business rules and exception reporting.
Auditability matters
For enterprise use, retain rule version, execution time, dataset/version, result, owner, and exception evidence.