Hi - I currently have a bunch of QuickSight datasets sourcing their data from an RDS instance (I will call it DWH), and they are refreshed daily. The RDS instance is an offline mirror of some production data which is also refreshed daily. The ETL process from production to DWH takes place at midnight and it takes few minutes to complete, depending on the table. Unfortunately, QuickSight daily refresh also takes place at midnight and sometimes it fails due to the ETL process that didn’t end yet.
At first I thought that setting up a first refresh date and time it would make all subsequent refresh taking place at the same time, but it actually didn’t work. Is there a way around this other than moving the ETL process schedule?
I also tried the route of scheduling an hourly refresh but this just increased transfer costs disproportionally.