AWS Athena

Introduction

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.

To set up the OpsRamp AWS integration and discover the AWS service, go to AWS Integration Discovery Profile and select AWS Athena.


OpsRamp Metric	Metric Display Name	Unit	Aggregation Type	Description
aws_athena_EngineExecutionTime	EngineExecutionTime	Milliseconds	Average	Number of milliseconds that the query took to execute.
aws_athena_QueryPlanningTime	QueryPlanningTime	Milliseconds	Average	Number of milliseconds that Athena took to plan the query processing flow.
aws_athena_QueryQueueTime	QueryQueueTime	Milliseconds	Average	Number of milliseconds that the query was in the query queue waiting for resources.
aws_athena_ServiceProcessingTime	ServiceProcessingTime	Milliseconds	Average	Number of milliseconds that Athena took to process the query results after the query engine finished query execution.
aws_athena_TotalExecutionTime	TotalExecutionTime	Milliseconds	Average	Number of milliseconds that Athena took to run the query.
aws_athena_DataScannedInBytes	DataScannedInBytes	Bytes	Average	Total amount of data scanned per query.