Incremental refresh dataset

Question & Answer
,
1

Hello,
I’ve created a dataset with an incremental refresh. I use this dataset in another dataset with other tables from a different database.
I also need to schedule a refresh to the second dataset, right? Is it running only the tables included in the second dataset and not the first one?

Hope that the question is clear.

Thanks in advance, Mia.

2

Hi @miap,

I think a refresh of the second dataset will only refresh the tables included in the second dataset. My basis to say this is that the SPICE dataset basically stores data. So if you use the first dataset in the second one you are basically querying the stored data in the first dataset.

You could do the following to prove this is the case:
a. Create dataset 1 on a table with a filter criteria so you can get x rows from the table
b. Note down count of rows
c. Create dataset 2 using dataset 1 and an additional table
d. Note down count of rows…I presume this will have the same count as in step b
e. Insert some new rows in the table for the dataset 1 that meets the criteria specified in the dataset so the table has new rows.
f. Refresh dataset 2.
g. Note down count of rows in dataset 2. It should not change since dataset 1 has not been refreshed.

Regards,
Giri

3

Hi @miap,
It has been awhile since we last heard from you. Do you have any additional questions regarding Giridhar’s response?

If we do not hear back in the next 3 days, I’ll go ahead and mark the response as the solution. But, if you need additional help, feel free to create a new topic.

Thank you!

4

Hi @miap. Checking in. We have not heard back from you regarding your question. We’d still like to help. If we do not hear back in the next 3 days, we will archive the question. In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and post it here. (Details on using Arena can be found here - QuickSight Arena).

5

Hi @miap, 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!