Hi,
What does the query in RDS which was sent from QuickSight show ? Are you able run the same query and check if there were any records returned ?
I have tested the incremental refresh and below are a few screenshots to understand what is happening , hopefully this should help you debug at your end.
Setup ( Window size : 6 hours )
Schedule
History of executions ( Every 15 minutes )
How does a select look like for incremental refresh ?
Note : included from_unixtime… as part of the query to show the time which is considered to extract records.
In this scenario , -6 hours . As per screenshot history of executions , the schedule which ran at 11:30:24(UTC) takes -6 hours from the previous incremental run ( 2022/06/03 11:15:24 - 6 hours = 2022-06-03 5:15:24 ) . This is visible in _col6
Data before update
Updated data in QuickSight (Amount 1000 )
Regards,
Koushik