Download PDF
Download page Amazon Athena.
Amazon Athena
Amazon Athena is a serverless, interactive analytics service built on open-source frameworks, supporting open-table and file formats. Amazon Athena provides a simplified, flexible way to analyze petabytes of data where it lives.
You must configure cloud connections to monitor this entity. See Set up Cisco AppDynamics Cloud Collectors to Monitor AWS.
Cisco Cloud Observability displays AWS entities on the Observe page. Metrics are displayed for specific entity instances in the list and detail views.
This document contains references to third-party documentation. Splunk AppDynamics does not own any rights and assumes no responsibility for the accuracy or completeness of such third-party documentation.
Detail View
To display the detail view for an Amazon Athena instance:
- Navigate to the Observe page.
- Under Analytics, click AWS Athena Workgroups.
The list view now displays. - From the list, click an instance Name to display the detail view.
The detail view displays the metrics, key performance indicators, and properties (attributes) related to the instance you selected.
Metrics and Key Performance Indicators
Cisco Cloud Observability displays the following metrics and key performance indicators (KPIs) for Amazon Athena. For more information, see Monitoring Athena queries with CloudWatch metrics.
| Display Name | Source Metric Name | Description |
|---|---|---|
| Processed Bytes | ProcessedBytes | The number of bytes that Athena scanned per DML query. For queries that were canceled (either by the users, or automatically, if they reached the limit), this includes the amount of data scanned before the cancellation time. This metric is not reported for DDL queries. |
| Engine Execution Time (ms) | EngineExecutionTime | The number of milliseconds that the query took to run. |
| Query Planning Time (ms) | QueryPlanningTime | The number of milliseconds that Athena took to plan the query processing flow. This includes the time spent retrieving table partitions from the data source. Note that because the query engine performs the query planning, query planning time is a subset of EngineExecutionTime. |
| Query Queue Time (ms) | QueryQueueTime | The number of milliseconds that the query was in the query queue waiting for resources. Note that if transient errors occur, the query can be automatically added back to the queue. |
| Service Processing Time (ms) | ServiceProcessingTime | The umber of milliseconds that Athena took to process the query results after the query engine finished running the query. |
| Total Execution Time (ms) | TotalExecutionTime | The number of milliseconds that Athena took to run a DDL or DML query. TotalExecutionTime includes QueryPlanningTime, QueryQueueTime, EngineExecutionTime, and ServiceProcessingTime. |
Properties (Attributes)
Cisco Cloud Observability displays the following properties for Amazon Athena.
| Display Name | Property Name | Description |
|---|---|---|
| State | aws.athena_workgroup.state | The state of the Athena workgroup. |
| Created At | aws.athena_workgroup.created_at | The timestamp when the Athena workgroup was created. |
| Engine Version | aws.athena_workgroup.engine_version | The version of the query engine. |
| ARN | aws.athena_workgroup.arn | The ARN of the workgroup. |
| Name | aws.athena_workgroup.name | The name of the workgroup, unique for each region. |
| Description | aws.athena_workgroup.description | The description of the Athena workgroup. |
| Encryption Configuration Option | aws.athena_workgroup.encryption_configuration_option | If query and calculation results are encrypted in Amazon S3, this property indicates the encryption option used (for example, SSE_KMS or CSE_KMS). |
| Kms Key | aws.athena_workgroup.kms_key | The Key Management Service (KMS) key used for encryption. |
| Publish Cloud Watch Metrics Enabled | aws.athena_workgroup.publish_cloud_watch_metrics_enabled | Indicates if the workgroup metrics are published to Amazon CloudWatch. |
| Result Configuration Output Location | aws.athena_workgroup.result_configuration.output_location | The location for results that are written to Amazon S3. |
| Data Limit Per Query | aws.athena_workgroup.data_limit_per_query | The limit for the maximum amount of data a query is allowed to scan. |
| Cloud Provider | cloud.provider | The name of the cloud provider. |
| Cloud Account ID | cloud.account.id | The cloud account ID the resource is assigned to. |
| Cloud Region | cloud.region | The geographical region the resource is running. |
| Cloud Platform | cloud.platform | The cloud platform in use. |
Retention and Purge Time-To-Live (TTL)
For all cloud and infrastructure entities, the retention TTL is 180 minutes (3 hours) and the purge TTL is 525,600 minutes (365 days).
Amazon Web Services, the AWS logo, AWS, and any other AWS Marks used in these materials are trademarks of Amazon.com, Inc. or its affiliates in the United States and/or other countries.