🔢Refreshing and Publishing Datasets

Note

Dataset refresh operations only apply to stored datasets.

Live datasets are, by default, "fresh" datasets computed each time a user consults a visualization or a dataset depending on it.

On this page, you will learn how to:

• Refresh datasets:

  • Manually (directly within the datahub, in the "Datasets" tab)

  • Automatically (thought automation)

• Publish data

  • All datasets

  • Specific datasets

Note

Refreshing a dataset will update the data only in Staging mode. If you want also to update it in Production mode, you will have to publish the data after the refresh.

Refreshing datasets manually

Creating and refreshing a dataset

Each time you create a new stored dataset, you can "Save" it or "Save and Refresh" it.

"Save" and "Save and Refresh" options

If you choose "Save," you will see a pending refresh icon in the Dataset tab of the DataHub. If you want to refresh it, simply click on that button.

Pending Refresh

Hint

When you choose to "Save and Refresh," the dataset and all its parent datasets will be refreshed. If you have heavy parent datasets, you might be exposed to a long refresh time before being able to continue working on your app data.

To avoid that, you can simply use "Save" and Refresh the dataset or all datasets later.

Refreshing a dataset and its parent datasets

To refresh a dataset, and all its parent datasets, you can click on the refresh icon in the dataset list (if no refresh is pending, the button is grey)

Refreshing all datasets

To refresh all datasets in your app, click on the "Publish" dropdown and select "Refresh Data."

Refresh all datasets

Refreshing datasets automatically

Toucan provides automation tools, including a Refresh scheduler. To use it:

• Go to the "Automation" interface (accessible in the Settings on top-right of

• Click on "Add an action"

• Give a name to the automation

• Choose "Refresh Data"

• Set the automation frequency

• Choose whether the creator and/or the admin should be notified about a refresh failure.

Data Scheduler interface

Your scheduled refresh is now up and running.

It works as a regular refresh: the dataset and all parent datasets will be refreshed.

You can deactivate this automation thanks to the toggle button in the Automation tab, edit or delete it.

Refresh Status

The dot in the navigation panel indicates the status of the refresh

• Blue dot: the refresh is in progress

• Green dot: the refresh has succeeded, and data in staging is up to date

• Red dot: there is an error. To get more details on the error, click the dot to see operation history details. Don't hesitate to reach out to our support team - [e-mail] - to get assistance on errors you don't understand.

Refresh status

Publishing all datasets

To publish your data so end users can see them in Production, you can either:

• Use the "Publish" button (within the app menu): it will publish the data and layout design changes

• Only publish data by using "Publish Data" in the the "Publish" dropdown button (-> publish Options)

Publish operations pop over

Publishing a specific dataset

To publish a specific dataset into production mode, click on "Publish" on the action menu of your dataset within the data hub.