# Data Freshness

> How up to date data is, measured as the time since its last load.

**Field:** Data Engineering  
**Category:** Governance & Quality  
**Also known as:** Timeliness (Data Quality), Data Timeliness, Data Latency

## 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.

## Definition

Data freshness is how up to date the data is. It is measured as the time since the newest record arrived. A table loaded each hour should never be more than about an hour old. When a load silently stops, every number still looks normal, just old. That is why freshness is one of the first things teams watch.

## 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.

## Example code

```sql
SELECT MAX(loaded_at) AS last_load,
       CURRENT_TIMESTAMP - MAX(loaded_at) AS age
FROM orders;
```

The age of the newest row. If it is more than a few hours on an hourly table, a load has stopped.

## Why it matters

Stale data does not look broken. People act on old numbers without knowing it.

## Common mistake

Showing no "last updated" time on a dashboard. Readers then cannot tell stale from real.

## Three principles

- **Time since last load.** The age of the newest row.
- **Set an expectation.** Know how old is too old.
- **Fails quietly.** Old numbers still look normal.

## Related terms

- [Data Quality Dimensions](https://learn.benibix.com/term/data/data-quality-dimensions)
- [Data SLA](https://learn.benibix.com/term/data/data-sla)
- [Data Observability](https://learn.benibix.com/term/data/data-observability)
- [Incremental Load](https://learn.benibix.com/term/data/incremental-load)

![Six tiles, one per quality dimension, each with a small broken example: accuracy shows a wrong price, completeness a blank email, consistency two totals that disagree, freshness a table last loaded 3 days ago, uniqueness an order listed twice, and validity a date of 31 February.](https://learn.benibix.com/diagrams/data-quality-dimensions.svg)

---

Source: https://learn.benibix.com/term/data/data-freshness
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-18
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
