> ## Documentation Index
> Fetch the complete documentation index at: https://developer.affinity.co/llms.txt
> Use this file to discover all available pages before exploring further.

# Refresh Cadence

> How often Data Share tables are updated

## Refresh Schedule

Data Share tables are refreshed **every 2 hours** using an incremental pipeline. Each refresh cycle
processes only new and changed records since the last run, keeping your data current without
full-table reloads.

## Understanding `last_updated_at`

Every table includes a `last_updated_at` timestamp column. This value represents when the
ETL pipeline last wrote or refreshed the record — it does **not** correspond to when the
underlying data was changed in the Affinity application.

Use `last_updated_at` to identify records that were recently refreshed by the pipeline:

```sql theme={null}
SELECT *
FROM persons
WHERE last_updated_at >= DATEADD('hour', -2, CURRENT_TIMESTAMP())
ORDER BY last_updated_at DESC;
```

<Note>
  Because refreshes are incremental, a record's `last_updated_at` is only updated when the
  pipeline detects a change. Unchanged records retain their previous `last_updated_at` value.
</Note>