Refreshing multi-joined dataset

Question & Answer
, , ,
1

dataset
dataset1120×634 102 KB

I have a question regarding refreshing datasets in QuickSight.

The order_monitoring dataset is created by left joining three independent custom SQL datasets into a single large dataset. This order_monitoring dataset is then left joined with another dataset called store_setting, which exists as a SPICE dataset.

Currently, only the store_setting dataset is refreshed daily. However, since the dependent datasets within order_monitoring are not refreshed automatically, the data in order_monitoring does not get updated.

Is there a way to configure the refresh settings so that all dependent datasets within the order_monitoring hierarchy can be refreshed and cached simultaneously with a single refresh action?

Thank you in advance for your guidance and support!

Best regards,
Alex

2

Hi @9haeng

Currently its not possible to refresh all the dependant datasets together in one refresh. Would recommend to use the API to refresh the dependent datasets first and followed by Order_monitoring dataset.

At AWS, our roadmap is primarily driven by our customers.
Your feedback helps us build a better service, I have tagged this as feature request.

Thanks
Vinod