If i want my dataset to refresh automatically on every 1st day of the month than how can we do it ?
Thank You Kellie_Burton for the solution
But what about on Athena Level.?
If you are using an Athena connection in QuickSight that results in a SPICE dataset, the same documentation above applies. The other option would be a direct query to Athena. In that case, each time the dashboard is accessed the Athena query would run and thus no schedule is created for update in QuickSight.