🛡️Data Quality Check
Also known as Data Test, Data Quality Test, Data Quality Rule
A rule data must pass. The pipeline tests it each time.
Think of it like
It is like the guard at the school gate. Each child must show a pass before going in.
Example
Jack adds a check that no price is below zero. A week later it stops a load with a bad currency fix, before any report sees it.
Why it matters
Checks catch bad data at the door, when it is cheap to fix. Without them, users find the problem in a meeting.
Definition
Example code
yaml
models:
- name: orders
columns:
- name: order_id
data_tests:
- unique
- not_nullCommon mistake
Key takeaways
- 1A clear rule. Pass or fail, nothing in between.
- 2Runs in the pipeline. Right after data lands or changes.
- 3Stop or warn. Decide what a failure blocks.