Can I stop a Dataset refresh?

Question & Answer
1

Is there a way to force stop a refresh currently happening on a Dataset?

2

I believe if you go to “edit” on the dataset it stops the current refresh.

3

thanks rbrady. That does not seem to work for me…

1 Like
4

The only way to stop a refresh on the quicksight website is to edit the dataset that’s currently being refreshed, and to modify it then save it. This will cause the current refresh to fail, and a new one to begin. There is a public API that can cancel an ingestion though.

1 Like
5

If you have API access, you can run the cancel_ingestion to stop the refresh: QuickSight — Boto3 Docs 1.21.5 documentation
How to get the ingestion id? List_ingestions with the dataset id. And then, get the latest active ingestion id from the list.
Furthermore, you can go to the database to cancel the related quicksight “select” query. The quicksight query start with /quicksight …/. Get the process id can kill the process will force the ingestion to be stop.

1 Like
6

Hi,

You can request your DBA to stop the Query/process fetching the data for SPICE in case of if you using the database at the backend.

1 Like