Dataset page cannot configure incremental refresh

Question & Answer
,
1

I found from the QuickSight documentation that the dataset can be incrementally refreshed [Refreshing SPICE data - Amazon QuickSight], but the page does not configure the function of incremental updates. What is the situation?

image
image1919×901 167 KB

2

Hi @zhangjie, welcome to the QuickSight Community. There could be several reasons why you are not seeing the incremental updates option. Let’s try to go through the list:

  1. Data Source Support:
  • Ensure that your data source supports incremental refresh. As of now, data sources like Amazon RDS, Amazon Redshift, and Amazon S3 typically support this feature. Other data sources might not have this capability.
  1. Dataset Configuration:
  • Verify that your dataset is configured correctly. Go to the Datasets page in QuickSight, select the dataset, and ensure that it is set up with a suitable column for incremental refresh, such as a timestamp or an auto-incrementing ID.
  1. Permissions:
  • Check if you have the necessary permissions to configure dataset settings. You might need specific roles or permissions within AWS QuickSight to enable and manage incremental refresh.
  1. Column for Incremental Refresh:
  • Ensure that the dataset includes a column that QuickSight can use for identifying new or updated records. This column should ideally be a timestamp or a sequential ID that reliably indicates data changes.
  1. Incremental Refresh Configuration:
  • Go to the dataset details pane, select Refresh, and look for the Configure Incremental Refresh option. If this option is not visible, it could be due to the data source not supporting incremental refresh or the dataset lacking a suitable column.
  1. Schema Changes:
  • Ensure there have been no recent schema changes that might affect the incremental refresh setup. Any changes to the structure of the dataset could impact the ability to perform incremental updates.
  1. Console Updates:
  • Sometimes, UI updates or changes in the AWS Management Console could impact how options are displayed. Ensure that you are using the latest version of the AWS Console and that there are no ongoing issues.

If you have checked all these aspects and still do not see the incremental updates option, I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!