Amazon Athena is an interactive query service.

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

Amazon Athena

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 MetricMetric Display NameUnitAggregation Type
aws_athena_EngineExecutionTime

Number of milliseconds that the query took to execute.
EngineExecutionTimeMillisecondsAverage
aws_athena_QueryPlanningTime

Number of milliseconds that Athena took to plan the query processing flow.
QueryPlanningTimeMillisecondsAverage
aws_athena_QueryQueueTime

Number of milliseconds that the query was in the query queue waiting for resources.
QueryQueueTimeMillisecondsAverage
aws_athena_ServiceProcessingTime

Number of milliseconds that Athena took to process the query results after the query engine finished query execution.
ServiceProcessingTimeMillisecondsAverage
aws_athena_TotalExecutionTime

Number of milliseconds that Athena took to run the query.
TotalExecutionTimeMillisecondsAverage
aws_athena_DataScannedInBytes

Total amount of data scanned per query.
DataScannedInBytesBytesAverage