How Can i automate the Dataset Refresh on athena or Quicksight level

If i want my dataset to refresh automatically on every 1st day of the month than how can we do it ?

Hi @Hemant -
Welcome to the QuickSight Community! You can set a refresh schedule on your dataset. Please see the details in this documentation.

Best Regards,

1 Like

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.