Running Queries with Amazon Athena
With so much valuable data within CloudTrail and other logs, finding effective ways to query the data for specific entries is always a top priority. The Amazon Athena service makes running ad hoc queries on extensive datasets much more straightforward. When discussing storing logs on the S3 service earlier in the chapter, one of the feature’s shortcomings was the ability to query the logs. This gap in capabilities is filled by using the Amazon Athena service.
Amazon Athena is a serverless service that allows you to quickly analyze data stored within Amazon S3, such as your CloudTrail logs. Athena does this by using an interactive query service and letting you write your queries using standard Structured Query Language (SQL). As a result, it is an efficient service to help you scan massive datasets.
The following are some key facts to understand about Amazon Athena:
- Athena separates storage from compute by utilizing Amazon S3 for...