Amazon Athena is an interactive query service that quickly analyzes data in Amazon S3 using standard SQL. With Athena, you can analyze large amounts of data stored in S3 without setting up and managing any infrastructure. Athena is serverless, meaning it automatically scales to handle any data stored in S3, and you only pay for the queries you run.
This Cloud Lab comprises two sections: Athena basics and integrating Athena with CloudTrail. In the first section, you’ll gain an understanding of how to use Amazon Athena to analyze data in Amazon S3 by employing SQL queries. You’ll also learn t how to use the AWS Glue crawler to convert CSV files into tables which can then be queried in Athena. The second section will demonstrate integrating Athena with CloudTrail to analyze AWS API activity and monitor changes to AWS resources. This section will cover enabling CloudTrail logging, creating an Athena table to analyze CloudTrail logs, and exploring CloudTrail logs for insights into AWS API activity using the Athena query editor.
By the end of this Cloud Lab, you’ll have practical experience in using Athena to analyze data in Amazon S3 and integrating Athena with CloudTrail to monitor AWS API activity and resource changes. These skills are essential for anyone working with AWS infrastructure and applications and will help you ensure the health and performance of your AWS resources.
The following are the high-level architecture diagrams of the infrastructure that you’ll create in this lab:
