Monitoring Amazon Athena Queries using Amazon CloudWatch

Опубликовано 4 января 2021, 23:35

Amazon Athena now publishes Amazon CloudWatch Events for query state transitions. When a query transitions between states -- for example, from Running to a terminal state such as Succeeded or Cancelled -- Athena publishes a query state change event to CloudWatch Events. The event contains information about the query state transition. Athena also publishes query-related metrics to Amazon CloudWatch.

These are: Query Planning Time, the time taken to plan the query. This includes the time spent retrieving table partitions from the data source, Query Queuing Time, the time that the query was in a queue waiting for resources, Service Processing Time, the time taken to write results after the query engine finished its execution, Total Execution Time, time Athena took to run the query.

This video demonstrates how to create custom dashboards, set alarms and triggers on metrics in CloudWatch, or use pre-populated dashboards directly from the Athena console to consume these new query metrics.

Learn more about monitoring Amazon Athena queries at - amzn.to/3aFAnjR

Subscribe:
More AWS videos bit.ly/2O3zS75
More AWS events videos bit.ly/316g9t4

#AWS #AWSDemo