Quality rules

A quality rule is a verifiable condition that the data must meet, linked to a dimension: a required field, an email format, a date that is not in the future, a checksum. A well-formulated rule is precise, measurable, and automatable, with a tolerance threshold.

Example

SELECT COUNT(*) FROM clients WHERE email NOT LIKE '%@%';

Related concepts

The whole glossary