Refreshing Data - Amazon QuickSight

Refreshing Data

You can refresh your SPICE datasets at any time. Refreshing imports the data into SPICE again, so the data includes any changes since the last import.

You can refresh SPICE data by taking any of the following approaches:

  • You can use the options on the Your Data Sets page.

  • You can refresh a dataset on the data preparation page while editing a dataset.

  • You can schedule refreshes of the data.

When you create or edit a SPICE dataset, you can enable email notifications for data loading status. This option notifies the owners of the dataset if the data fails to load or refresh. To turn on notifications, enable the Email owners when a refresh fails option that displays on the Finish data set creation. This option isn't available for datasets that you create by using Upload a File on the datasets page.

In the following sections, you can find an explanation of each approach.

For data that is not stored in SPICE, you can do the following:

  • To refresh file-based data, you must delete and recreate the dataset.

  • To refresh data from a database, reopen your dataset or the visualization you created from it.

Refreshing a Dataset from the Your Data Sets Page

Use the following procedure to refresh a SPICE dataset based on an Amazon S3 or database data source on the Your Data Sets page.

To refresh SPICE data from the Your Data Sets page

  1. On the Your Data Sets page, choose the dataset, and then choose Refresh Now.

  2. Leave the refresh type as Full refresh.

  3. If you are refreshing an Amazon S3 dataset, choose one of the following options for S3 Manifest:

    • To use the same manifest file you last provided to Amazon QuickSight, choose Existing Manifest. If you have changed the manifest file at the file location or URL that you last provided, the data returned reflects those changes.

    • To specify a new manifest file by uploading it from your local network, choose Upload Manifest, and then choose Upload manifest file. For Open, choose a file, and then choose Open.

    • To specify a new manifest file by providing a URL, enter the URL of the manifest in Input manifest URL. You can find the manifest file URL in the Amazon S3 console by opening the context (right-click) menu for the manifest file, choosing Properties, and looking at the Link box.

  4. Choose Refresh.

  5. If you are refreshing an Amazon S3 dataset, choose OK, then OK again.

    If you are refreshing a database dataset, choose OK.

Refreshing a Dataset During Data Preparation

Use the following procedure to refresh a SPICE dataset based on an Amazon S3 or database data source during data preparation.

To refresh SPICE data during data preparation

  1. On the Your Data Sets page, choose the dataset, and then choose Edit Data Set.

  2. On the dataset screen, choose Refresh now.

  3. Leave the refresh type set to Full refresh.

  4. (Optional) If you are refreshing an Amazon S3 dataset, choose one of the following options for S3 Manifest:

    • To use the same manifest file you last provided to Amazon QuickSight, choose Existing Manifest. If you have changed the manifest file at the file location or URL that you last provided, the data returned reflects those changes.

    • To specify a new manifest file by uploading it from your local network, choose Upload Manifest, and then choose Upload manifest file. For Open, choose a file, and then choose Open.

    • To specify a new manifest file by providing a URL, enter the URL of the manifest in Input manifest URL. You can find the manifest file URL in the Amazon S3 console by opening the context (right-click) menu for the manifest file, choosing Properties, and looking at the Link box.

  5. Choose Refresh.

  6. If you are refreshing an Amazon S3 dataset, choose OK, then OK again.

    If you are refreshing a database dataset, choose OK.

Refreshing a Dataset on a Schedule

Use the following procedure to schedule refreshing the data. If your dataset is based on a direct query and not stored in SPICE, you can refresh your data by opening the dataset. You can also refresh your data by refreshing the page in an analysis or dashboard.

To refresh SPICE data on a schedule

  1. On the Your Data Sets page, choose the dataset, and then choose Schedule refresh.

  2. For Schedule Refresh, choose Create.

  3. On the Create a Schedule screen, choose settings for your schedule.

    1. For Time zone, choose the time zone that applies to the data refresh.

    2. For Repeats, choose one of the following:

      • For Standard or Enterprise editions, you can choose Daily, Weekly, or Monthly.

        • Daily: Repeats every day

        • Weekly: Repeats on the same day of each week

        • Monthly: Repeats on the same day number of each month. To refresh data on the 29th, 30th or 31st day of the month, choose Last day of month from the list.

      • For Enterprise edition only, you can choose Hourly. This setting refreshes your dataset every hour, beginning at the time you choose. So, if you select 1:05 as the starting time, the data refreshes at five minutes after the hour, every hour.

        If you decide to use an hourly refresh, you can't also use additional refresh schedules. To create an hourly schedule, remove any other existing schedules for that dataset. Also, remove any existing hourly schedule before you create a daily, weekly, or monthly schedule.

    3. Starting: Choose a date for the refresh to start.

    4. For At, Specify the time that the refresh should start. Use HH:MM and 24-hour format, for example 13:30.

  4. Choose Create.

You can create five schedules for each dataset. When you have created five, the Create button is disabled.