Quick Sight synchronous refresh with Redshift table

Right now my team has a quicksight dashboard connected to tables in redshift as the data source, and we are refreshing the data 1-3 times a day. However, we would like to set up an auto refresh, so that the dashboard can be refreshed as soon as the backend redshift table is loaded with new data. How can I do this?

Hi @baonil

While I haven’t tried this; but when looking at APIs for some other purpose I had come across this

Hope this helps your case.

Hi @baonil,

Just checking back in since this thread hasn’t received a response in a while. Was Giri’s reply helpful to you and/or were you able to find a solution yourself in the meantime? Please help the community by marking this answer as “Solution” or following up in general within the next 3 business days!

Thank you!