Amazon Athena Monitoring in ObserveOps
Overview
The Amazon Athena integration with ObserveOps (formerly known as AIOps) collects operational telemetry from Amazon Athena workgroups and capacity reservations. It monitors workgroup state, DPU allocation, query execution volumes, failure rates, and query performance timings across your serverless analytics environment.
These metrics help data platform teams detect query failures, track capacity consumption, and optimize query performance across Athena workgroups.
Prerequisites
- Amazon Athena is enabled in the target AWS account and region with at least one workgroup configured.
- The IAM role or user used for integration has read access to Athena resources (
athena:ListWorkGroups, athena:GetWorkGroup, athena:ListCapacityReservations, cloudwatch:GetMetricData). - Required Athena and CloudWatch API endpoints are reachable from ObserveOps.
- The AWS account is added in discovery with correct credentials and region configuration.
List of Supported KPIs
Workgroup
| Metric | Description | Type |
|---|
| aws.athena.workgroup.state | Current state of the Athena workgroup. | String |
| aws.athena.workgroup.active | Indicates whether the workgroup is active. | Boolean |
Capacity Reservation
| Metric | Description | Type |
|---|
| aws.athena.capacity.reservations | Total number of capacity reservations in the account. | Count |
| aws.athena.capacity.reservation | Identifier of an individual capacity reservation. | String |
| aws.athena.capacity.reservation.state | Current state of the capacity reservation. | String |
| aws.athena.capacity.reservation.active | Indicates whether the capacity reservation is active. | Boolean |
| aws.athena.capacity.reservation.allocated.dpus | Number of DPUs currently allocated to the reservation. | Count |
| aws.athena.capacity.reservation.target.dpus | Target number of DPUs requested for the reservation. | Count |
| aws.athena.workgroup.queries | Total number of queries executed in the workgroup. | Count |
| aws.athena.query.failures | Number of queries that failed in the workgroup. | Count |
| Metric | Description | Type |
|---|
| aws.athena.query.engine.execution.time.ms | Total engine execution time for queries in milliseconds. | Milliseconds |
| aws.athena.query.queue.time.ms | Time queries spent waiting in the queue in milliseconds. | Milliseconds |
| aws.athena.query.planning.time.ms | Time spent planning query execution in milliseconds. | Milliseconds |
| aws.athena.service.processing.time.ms | Time spent in service-side query processing in milliseconds. | Milliseconds |
| aws.athena.service.preprocessing.time.ms | Time spent in service-side query preprocessing in milliseconds. | Milliseconds |
| aws.athena.data.scanned.bytes | Total bytes of data scanned by queries in the workgroup. | Bytes |
| aws.athena.dpu.consumed | Total DPUs consumed by queries in the workgroup. | Count |
| aws.athena.dpu.peak | Peak DPU utilization observed during query execution. | Count |