Athena Query Intelligence
Track query cost, data scanned, slow queries, and who's spending the most , per query, per user, per workgroup. Before the surprise bill arrives.
Athena charges $5 per TB scanned
A single query without proper partitioning or column pruning can scan your entire dataset. At $5/TB, a 10TB table scanned 20 times a day costs $1,000/day. Most teams discover this in the monthly bill , not in real time.
Cost Per Query Breakdown
See exactly how much each query costs in dollars , not just data scanned. Ranked by cost, by user, and by workgroup.
Data Scanned Alerts
Set thresholds for acceptable data scanned per query. Get alerted when a query exceeds them before it becomes a budget problem.
Slow Query Detection
Track query execution time trends. Surface queries that are getting slower over time , often a symptom of table degradation upstream.
User & Workgroup Analysis
Understand which teams and users drive the most cost. Workgroup budget utilization, query frequency, and cost-per-query by principal.
Query Pattern Trends
Identify recurring expensive queries that could be accelerated with better partitioning, columnar format tuning, or caching.
Failed Query Analysis
Track query failure rates, error categories, and which tables or columns are most frequently involved in failures.
How to connect Athena
Deploy read-only IAM role
CloudFormation creates a role with read access to Athena query history and execution statistics.
Select workgroups to monitor
Choose which Athena workgroups to include. All queries within those workgroups are tracked automatically.
Set cost alert thresholds
Define per-query and per-workgroup cost thresholds. Alerts route to Slack, PagerDuty, or email.
Query analytics live within 24h
Per-query cost dashboards, user rankings, and slow query reports populate as query history is ingested.
Required IAM permissions
No access to query results data. Execution metadata and statistics only.
Start with proof,
not a pitch.
Scoped read-only role, 30-day lookback, results in 48 hours.