The Refresh Settings guide

View and Dictionary popups carry a short built-in guide to their refresh schedule. Open it while you fill in Refresh Settings, when you want to check what the interval, the offset or the retries do. The window is titled Refresh Settings, and its subtitle reads "How the refresh schedule is built".

Open the guide

1. In a View or Dictionary popup, go to General and find the Refresh Settings section.
2. Click the book icon beside the section title. Its tooltip reads Refresh settings guide.
3. Read the timeline and the four cards that follow it.
4. Click Got it to close the guide.

• The guide opens over the popup and is a reference window: nothing in it edits or saves your settings.
• The icon sits in the section header; clicking it opens the guide and does not expand or collapse the section.

Read the timeline

The timeline draws one schedule as a picture:

• A dashed line marks the period boundary the schedule is aligned to, such as midnight for a daily refresh.
• The gap between that boundary and the first run is the offset.
• Dots mark the refresh runs, and the spacing between two runs is the interval.

The diagram's description reads: "Timeline: the offset shifts the first refresh away from the period boundary, then the interval sets the spacing between refreshes."

The four cards

Below the timeline, four cards explain the fields of Refresh Settings:

• Refresh Interval + Unit: "How often the view rebuilds. Both the number and its unit are required, and neither has a default."
• Refresh Offset + Unit: "Shifts the run inside each period, so a daily refresh lands at 03:00 instead of midnight. Optional; pick None to clear it."
• Retries: "How many times a failed refresh is retried. Empty uses ClickHouse's default of 2, and -1 retries indefinitely."
• Where it runs: "These fields become the refresh clause on the materialized view itself, with no separate scheduler in between."

The footer of the guide adds a hint: "Offset the run so it lands after your source sync finishes."

The guide explains the schedule only. The fields and the controls that run the refresh live with the object: see Views and the Dictionary General step.

Questions, answered

Where do I find the refresh settings guide?

In a View or Dictionary popup, on its General step. The book icon sits beside the Refresh Settings title, and its tooltip reads Refresh settings guide. Click it to open the window, and Got it to close it.

Which fields does the guide explain?

The four cards cover Refresh Interval + Unit, Refresh Offset + Unit, Retries and Where it runs. The timeline above them shows the offset and the interval on one schedule.

What do offset and interval mean on the timeline?

The offset shifts the first refresh away from the period boundary, and the interval sets the spacing between refreshes. The timeline is labelled offset and interval, and its description reads: "Timeline: the offset shifts the first refresh away from the period boundary, then the interval sets the spacing between refreshes."

What does the offset change about when a refresh runs?

It shifts the run inside its period, so a daily refresh lands at 03:00 instead of midnight. The offset is optional, and None clears it.

What happens if I leave Retries empty?

Empty uses ClickHouse's default of 2, so a failed refresh is retried twice. Enter -1 to retry indefinitely.

Why should the offset land after my source sync finishes?

So the run does not start before your source has finished syncing. The footer of the guide reads: "Offset the run so it lands after your source sync finishes."

Is a refresh run by a separate scheduler?

No. The Where it runs card reads: "These fields become the refresh clause on the materialized view itself, with no separate scheduler in between."