Quicksight - Data Refresh Quarterly

Is there an option to apply data refresh Quarterly on the dataset in Quicksight. I have experimented with this,

  1. Add New Schedule → Full refresh → selected Frequency as Monthly → but it does refresh on one day every month (it is just showing the days of the month).

  2. Incremental Refresh will not work in my case - Data must be refreshed (full refresh) for every Quarter

Hi @shravya

You currently can’t do this in the quicksight ui.

You could look to possible set up a lambda that is triggered every quarter that hits this api

2 Likes

Oh Okay. Thank you @Max - I need to try this.

That’s correct @Max . Hi @shravya , You can use Event trigger ( which follow the cron schedule) and call a lambda function which internally call the create ingestion to refresh the data set. The pipeline will be like

Event Trigger → Lambda → Create ingestion

I used event trigger and lambda for many cloud automation, its easy and very flexible.

Regards - Sanjeeb

1 Like