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

Question & Answer
, ,
1

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

2

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,
Kellie

1 Like
3

Thank You Kellie_Burton for the solution

4

But what about on Athena Level.?

5

@Hemant
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.