🛡️Data Freshness
Also known as Timeliness (Data Quality), Data Timeliness, Data Latency
How up to date data is, measured as the time since its last load.
Think of it like
It is like the date on a milk carton. Old milk may look fine, but it is not what you want.
Example
A dashboard shows yesterday's sales as zero. The real problem is that the table is 30 hours old, because last night's load failed.
Why it matters
Stale data does not look broken. People act on old numbers without knowing it.
Definition
Example code
sql
SELECT MAX(loaded_at) AS last_load,
CURRENT_TIMESTAMP - MAX(loaded_at) AS age
FROM orders;Common mistake
Key takeaways
- 1Time since last load. The age of the newest row.
- 2Set an expectation. Know how old is too old.
- 3Fails quietly. Old numbers still look normal.