Amazon Athena is an interactive query service.
Resource Information:
- Type of Resource: Generic monitorable resource
- Discovery type: AWS SDK discovery type
- Discovery profile selection: Resource can be discovered by “Athena” in the profiler
- ResourceTag: AWS_ATHENA
- Resource Unique Identification: AthenaWorkGroupName+"/"+region (workGroup.name() + “/” + regionName)
- Dependencies: Athena WorkGroup may depend on S3 buckets for data storage and query results
This service simplifies data analytics by:
- Providing analytics directly in Amazon Simple Storage Service (Amazon S3).
- Minimizing action in the AWS management console, to point Athena to data stored in Amazon S3.
- Using standard SQL to run ad-hoc queries and retrieve results in seconds.
Additional benefits include:
- Infrastructure is not set up because Athena is serverless.
- Cost is based only on the queries that are run.
- Automatic scaling and parallel query execution which provides in fast results even even with large datasets and complex queries.
External reference
Setup
To set up the AWS integration and discover the AWS service, go to AWS Integration Discovery Profile and select AWS Athena.
Event support
CloudTrail event support
- Supported
- Configurable in OpsRamp AWS Integration Discovery Profile.
CloudWatch alarm support
- Not Supported
Supported metrics
| OpsRamp Metric | AWS Metric | Metric Display Name | Unit | Aggregation Type | Description |
|---|---|---|---|---|---|
| aws_athena_DPUAllocated | DPUAllocated | DPU Allocated | Count | Average | The total number of DPUs (data processing units) provisioned in a capacity reservation to run queries. |
| aws_athena_DPUConsumed | DPUConsumed | DPU Consumed | Count | Average | The number of DPUs actively consumed by queries in a RUNNING state at a given time in a reservation. T |
| aws_athena_DPUCount | DPUCount | DPU Count | Count | Average | The maximum number of DPUs consumed by your query, published exactly once as the query completes. |
| aws_athena_EngineExecutionTime | EngineExecutionTime | Engine Execution Time | Milliseconds | Average | The number of milliseconds that the query took to run. |
| aws_athena_ProcessedBytes | ProcessedBytes | Processed Bytes | Bytes | Average | The number of bytes that Athena scanned per DML query. |
| aws_athena_QueryPlanningTime | QueryPlanningTime | Query Planning Time | Milliseconds | Average | The number of milliseconds that Athena took to plan the query processing flow. |
| aws_athena_QueryQueueTime | QueryQueueTime | Query Queue Time | Milliseconds | Average | The number of milliseconds that the query was in the query queue waiting for resources. |
| aws_athena_ServicePreProcessingTime | ServicePreProcessingTime | Service Pre Processing Time | Milliseconds | Average | The number of milliseconds that Athena took to preprocess the query before submitting the query to the query engine. |
| aws_athena_ServiceProcessingTime | ServiceProcessingTime | Service Processing Time | Milliseconds | Average | The number of milliseconds that Athena took to process the query results after the query engine finished running the query. |
| aws_athena_TotalExecutionTime | TotalExecutionTime | Total Execution Time | Milliseconds | Average | The number of milliseconds that Athena took to run a DDL or DML query. TotalExecutionTime includes QueryQueueTime, QueryPlanningTime, EngineExecutionTime, and ServiceProcessingTime. |