A data engineering team runs a nightly reporting pipeline that executes several Amazon Athena queries orchestrated by AWS Step Functions. Recently, some queries intermittently fail, and the team needs to programmatically detect which specific queries failed and capture the error reason so they can automatically retry or alert. What is the MOST effective way to identify the exact failure cause for each Athena query execution?