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


## Related topics

- [OAuth Apps and MCP Clients (CIMD)](https://developer.affinity.co/pages/external-api-v2/oauth-apps.md)
- [Troubleshooting](https://developer.affinity.co/pages/mcp/troubleshooting.md)
- [Data Access](https://developer.affinity.co/pages/data-share/data_access.md)
- [Changelog](https://developer.affinity.co/pages/data-share/changelog.md)
- [Deletes & Merges](https://developer.affinity.co/pages/data-share/deletes.md)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.