Is there any query which can help get list of failed batches from a dataset.

[ShivaniM]

Hello All,

I want to fetch list of failed batches of a dataset in specific time window. Is there any  query which can help me with it for AEP.

[ShivaniM]

Hello, it would be great if I can get the error also against those batch IDs

[brekrut]

I would recommend using the Catalog API to look for batches over a timeframe and see their status.  You can also filter on the dataSet using the Catalog API.

https://developer.adobe.com/experience-platform-apis/references/catalog/#tag/Batches

[itsme_ssj]

failed batches cannot be retrieved using query. As per the previous comment can be done using API.

--ssj

[SaurabhM]

Remember failed batches of data are not mastered in the dataset in the data lake. They are quarantined and kept separately for inspection. The Catalog API is the best way to get those or better take a look at the monitoring dashboard.

[kautuk_sahni]

@ShivaniM Did you find the suggestions helpful? Please let us know if you require more information. Otherwise, please mark the answer as correct for posterity. If you've discovered a solution yourself, we would appreciate it if you could share it with the community. Thank you!