Refresh

A refresh loads new data from the source into your Import Data Tables. You refresh a data model, not a single Data Table: one refresh updates every Data Table of the data model, each from its own data source. The refresh schedule also belongs to the data model.

Before you start

• The Data Tables must be in a data model. See Data models.
• To refresh or change the schedule, you need Build permission on the data model. Without it you can only view the schedule.
• Realtime Data Tables are never refreshed: every query reads the source.

Refresh now

1. Open Data models in the sidebar.
2. Open the data model.
3. Click the Refresh tab.
4. Under Refresh, click Refresh now. The list shows the latest refresh of each Data Table.

Fresco BI refreshes every Data Table of the data model, each from its own data source. Explore tables are refreshed after the tables they are built from.

Note

Only one refresh runs at a time for each data model. If one is running, wait until it finishes.

Set a refresh schedule

1. Open the data model and click the Refresh tab.
2. Find the Data model refresh schedule card.
3. Turn on Enabled.
4. Pick the Time zone.
5. Under Days of the week, pick 1 to 7 days.
6. Under Run times, set a time. Click Add time to add more times.
7. Click Save schedule.

Next run shows the next refresh in the schedule time zone and in your browser time zone.

Schedule limits

The plan sets how often a schedule can run. The panel shows your limit.

Plan	Runs a day	Shortest gap between runs
Free	1	1 day
Pro	24	60 minutes
Enterprise	48	30 minutes

On every plan, a schedule has 1 to 48 run times. The gap from the last run of a day to the first run of the next day counts only when the next day is also a schedule day.

If you set too many times, or times too close together, you see “Invalid times: too many, or closer together than your plan allows”. See Plans and limits.

Manual refresh limits

Manual refresh has no plan limit. A few rules still apply:

• One refresh at a time for each data model.
• Each person can start at most 10 refreshes a minute.
• Each organization can start at most 120 refreshes an hour.
• A Data Table whose new data would go above the plan’s data storage fails. The other Data Tables continue.
• A refresh that runs longer than 6 hours fails.

Follow a refresh

The data model page shows Last refresh with one of these states: Queued, Refreshing, Succeeded, Partly succeeded or Failed. A Scheduled tag marks a run that the schedule started.

While a refresh runs, or when it did not fully succeed, the page shows Status of each data table:

Status	Meaning
Waiting for earlier tables	The Explore table waits for the tables it is built from.
Queued	Waiting to start.
Refreshing	Loading data.
Succeeded	Done.
Failed	See the Note column for the reason.
Skipped	Not refreshed, for example because a table it is built from failed.

When a refresh fails

When a Data Table fails, the other Data Tables still finish. The run shows Partly succeeded.

The failed Data Table keeps the data of its last successful refresh, so reports keep working.

Common reasons:

Message	What to do
The new data failed the quality checks; the previous data is kept	Open the refresh details and read the Quality report. Fix the data at the source, then refresh again.
A data table it is built from was not refreshed	Fix the failed input Data Table first.
Your plan limit is reached	Free some data storage, or move to a larger plan. See Plans and limits.
The data source needs the Fresco Enterprise plan	The connector is not in your plan.
The data source has no saved password	Complete the data source settings. See Connect data.
The data source returned an error	Check that the source is up and that the account can read the table.
The data model refresh took too long	The run passed 6 hours. Try again later.

For other messages, see Error codes.

Refresh history

Each Data Table keeps its own refresh history.

1. Open the Data Table.
2. Click the Refresh history tab.

The list shows Started, Status, Rows, Size and Duration. Click Load more to see older runs.

Click a run to see its details: Started, Finished, Rows loaded, Bytes written, Consistency and the Quality report.

The Quality report is Passed or Failed, with its Findings. Findings include:

• Schema mismatch
• Empty table
• Large row-count drop
• Conversion errors
• Lossy column conversion
• New source columns

Note

You need Build permission on the Data Table to see its refresh history.

Common questions

Why is there no Refresh button on the Data Table? Refresh belongs to the data model. Open a data model that uses the Data Table and click Refresh there.

Can I schedule a single Data Table? No. Add it to a data model and set the schedule on the data model.