I’ve created a scheduled incremental refresh on a dataset which uses RDS as a datasource.
I set the incremental refresh with a window size of 6 hours, by using the column LAST_UPDATE_QS on database’s table.
(I wasn’t able to quickly change the language on the browser, so I’ll translate the relevation information in the descriptions below the pictures)
Now there are 14496 rows imported on QuickSight; on RDS I have 14497, so I expect that with an incremental refresh the new line would be added to QuickSight.
On the database I have the following values for LAST_UPDATE_QS:
So, given that the first row is inside the window (and was not already present on QuickSight), it should be updated on QuickSight (in my case, inserted).
This is the schedule configuration, with repetions set to every 15 minutes:
Update: Incremental Update
Update column: LAST_UPDATE_QS
Windows size: 6 hours
Repetitions: Every 15 minutes
Start: 22022-06-01 10:05
What I understand is: at 2022-06-01 10:05 the first incremental update will start, the second will be scheduled at 2022-06-01 10:20 and so on.
However, the dataset is never updated (as you can see in the first picture - Last update: 17 hours ago).
If I check the list of updates, this is the result:
|2022/05/31 14:58:08 | Completato |15 secondi |0| 14496 |14496 | Manuale, Aggiornamento completo|
|2022/05/25 14:40:15 | Completato | 14 secondi |0| 14494 | 14494 | Manuale, Modifica|
|2022/05/25 14:39:06 | Completato | 15 secondi |0| 14494 | 14494 | Manuale, Modifica|
Where the description says: Manual, update completed.
What I understand is that the scheduled update has never started.
Is there some misconfiguration? Do I have to change something on QuickSight? Is the date format on RDS wrong?