Refreshing datasets in a QuickSight Q topic - Amazon QuickSight

Refreshing datasets in a QuickSight Q topic

When you add a dataset to a topic, you can specify how often you want that dataset to refresh. When you refresh datasets in a topic, Q refreshes the index for that topic with any new and updated information.

Q doesn't replicate your datasets when you add them to a topic. Q creates an index of unique string values and doesn't index metrics. For example, measures stored as integers are not indexed by Q. Questions asked always fetch the latest sales metrics based on data in your dataset.

For more information about refreshing the topic index, see Refreshing Amazon QuickSight Q topic indexes

You can set a refresh schedule for a dataset in a topic, or refresh the dataset manually. You can also see when the data was last refreshed.

To set a refresh schedule for a topic dataset

  1. Open the topic that you want to change.

  2. On the Summary page, under Datasets, expand the dataset that you want to set a refresh schedule for.

  3. Choose Add schedule, and then do one of the following in the Add refresh schedule page that opens.

    Image of the Add schedule button.

    • If the dataset is a SPICE dataset, select Refresh topic when dataset is imported into SPICE.

      Currently, hourly refresh SPICE datasets aren't supported in Q. SPICE datasets that are set to refresh every hour are automatically converted to a daily refresh. For more information about setting refresh schedules for SPICE datasets, see Refreshing SPICE data.

    • If the dataset is a direct query dataset, do the following:

      1. For Timezone, choose a time zone.

      2. For Repeats, choose how often you want the refresh to happen. You can choose to refresh the dataset daily, weekly, or monthly.

      3. For Refresh time, enter the time that you want the refresh to start.

      4. For Start first refresh on, choose a date that you want start refreshing the dataset on.

  4. Choose Save.

To manually refresh a dataset

  1. On the topic Summary page, under Datasets, choose the dataset that you want to refresh.

  2. Choose Refresh now.

    Image of the refresh now button.
To view refresh history for a dataset

  1. On the topic Summary page, under Datasets, choose the dataset that you want to see refresh history for.

  2. Choose View history.

    Image of view refresh history button.

    The Update history page opens with a list of the times the dataset was refreshed.