How to keep existing data everytime I run a incremental refresh?

Question & Answer
,
1

I have a custom SQL query that pulls data from RDS on a daily basis, but when i do a incremental refresh the existing data is replaced , is there a workaround for this ?

2

Is your RDS data getting replaced? Are you using filters on your query?

3

RDS data does not get replaced, the data gets added to a table.
Yes, my query has filters.

4

This video may help you:

5

@suraj - This depends on how you are setting the Look Back Window. Please go through the link that @David_Wong suggested, it should give you a clear explanation of how incremental refresh works in QuickSight. Thank you!