I am unable to set up a spice dataset refresh schedule the way I want.
What i want to do is have a spice dataset refreshed at a specific time every day from the 28th of one month through the 3rd day of the following month. So at the end of February, it would run 4 times (2/28, 3/1, 3/2, 3/3), and at the end of March it would 7 times: (3/28, 3/29, 3/30, 3/31, 4/1, 4/2, 4/3). I thought about 7 monthly schedules, one monthly schedule on the 3rd of each month, one monthly schedule for the 2nd of each month, one monthly schedule for the 1st of each month, but I can’t select the 29th or 30th or 31st. All I can select is last day of month.
Any ideas? My only idea so far is a daily refresh even though I don’t need a refresh for 25 days of each month.
Hi @cgreenacre,
One option, but that requires a little bit of coding and extra infrastructure is to have a scheduled Lambda, that runs on the days you want. Lambda allow you triggering it using cron expressions.
The API call you want to make is CreateIngestion
If you use python, you can use this reference.
https://boto3.amazonaws.com/v1/documentation/api/latest/reference/services/quicksight/client/create_ingestion.html
This solution also gives you the possibility to create more complex scheduling than the ones you see directly on the dataset now.
At AWS, our roadmap is primarily driven by our customers. Your feedback helps us build a better service. I have tagged this as a feature request.
Kind regards,
Andres.
1 Like
Thanks for the idea. I was hoping to do it via the GUI, and not lambda. “Hope is NOT a strategy” is a favorite saying of one of our VPs. Thanks for tagging it as a feature enhancement.