Incremental refresh with different data sources

[demola]

Hi @miap,

Thank you for posting. To use incremental refresh, you will have to write a single customSQL which joins the tables instead of performing the join in QuickSight.

Please check the link below for previous discussions on this issue

Incremental Refresh Limitations Question

Hi, I’m trying to understand how incremental dataset refreshes work. We have the enterprise edition, and I’m trying to understand what criteria needs to be true for incremental to be displayed as an option on a dataset. In my situation, I have multiple datasets that are set up as SPICE storage and use the same Data Source type (MySQL RDS instance). In some cases, I am able to configure incremental refresh on dataset, but in other cases the only option shown to me is a full dataset refresh. I …

Please let me know if the options solves your issue.

Regards,
Demola