title: 'Full Refresh Mode'
sidebar_label: 'Full'
description: 'Replace the entire accelerated dataset on each refresh.'
sidebar_position: 1
pagination_prev: null
pagination_next: null
The full refresh mode replaces the entire accelerated dataset on every refresh. It is the default refresh mode and the simplest way to keep an acceleration in sync with its source.
Use full when:
- The dataset is small enough to be re-read on each refresh.
- Source rows can be inserted, updated, or deleted, and incremental tracking is not available.
- Strong consistency with the source is preferred over minimizing source load.
Configuration
On each refresh, the runtime issues a single SELECT against the source, materializes the result into the acceleration engine, and atomically swaps the new data in.
Behavior
- Each refresh fully scans the source. Any
refresh_sql and refresh_data_window filters are pushed down to limit data transferred.
- Queries continue to be served from the previous result set until the new refresh completes.
- Supported with all data connectors and all acceleration engines.
Related Topics
For cross-cutting refresh behavior that applies to full mode, see:
