DevOps & Infrastructure
Querying AWS Athena
Runs SQL queries on Amazon Athena query history exported as an Apache Iceberg table in S3 Tables. The query_executions system table captures per-query metadata (query text, IAM principal, work group, statement type, data scanned, timing breakdown, error details, tables accessed, result reuse, engine version) for every completed query. Applies when analyzing Athena usage and cost, finding who ran a query, auditing table access, tracking data scanned by user or work group, investigating slow or failed queries, detecting performance regressions, reporting query history beyond the 45-day API window, or enabling Athena system tables. Prefers the system table over the ListQueryExecutions and GetQueryExecution APIs at scale. Trigger phrases: Athena query history, who ran this query, data scanned by user, most queried tables, slowest queries, failed query analysis, Athena cost by work group, query audit trail, enable Athena system tables.
- Publisher / source
- aws/agent-toolkit-for-aws (found on skills.sh)
- Upstream record
- aws/agent-toolkit-for-aws
- Version
- Version 1
- Published
- Publication review
- Approved for publication
- Content fingerprint
b0216adad07ade9e09558329e874e8aee5430cba7dc83312584259e5e16a0c02