Datasets whose latest refresh failed

Hi Team,

Is there an option to get list of all datasets in quicksight whose latest refresh failed?

Currently we get an email whenever any datasets refresh is failed. I am looking for CLI or API to fetch the list if possible

Hi @pbneelqs

You can automate this using the AWS CLI or the boto3 API

  1. Use the ListDataSets API (or CLI) to get every DataSetId in your account.
  2. Call ListIngestions for that DataSetId to retrieve its ingestion history (status, timestamps, error info).
1 Like

Hi @pbneelqs

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

Hi @pbneelqs - As mentioned by @Xclipse you have to use 2 API’s to get the details. A custom python code using boto3 and quicksight API can be developed to collect these details.

Regards - Sanjeeb