Datasets whose latest refresh failed

Q&A
, ,
1

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

2

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).
3

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!

4

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

5

Thanks very much all. Sorry for the delay, I was off last few weeks. Will try the options. Once again thanks very much.

6

Hello @pbneelqs

It has been awhile since we have heard from you. Were @Xclipse or @Sanjeeb2022’s comments helpful, and if so could you mark on of them as the solution?