CLOUD LABS
Analyzing S3 Data and CloudTrail Logs Using Amazon Athena
Learn to use AWS Athena to query data stored in S3 and integrate it with CloudTrail to analyze AWS service activity logs.
beginner
Certificate of Completion
Learning Objectives
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:
Relevant Courses
Use the following content to review prerequisites or explore specific concepts in detail.
Trusted by 1.4 million developers working at companies including
Your method is simple, straight to the point and I can practice with it everywhere, even from my phone, that's something I have never had in other learning platforms.
![TestimonialsImg](/static/imgs/FelipeMatheus.png)
I highly recommend Educative. The courses are well organized and easy to understand.
![TestimonialsImg](/static/imgs/AdinaOng.png)
I prefer Educative courses because they have a nice mix of text & images. I find that with full video courses, it can often be too easy to go into passive learning mode.
![TestimonialsImg](/static/imgs/CliffordFajardo.png)
I prefer Educative courses because they have a nice mix of text & images. I find that with full video courses, it can often be too easy to go into passive learning mode.
![TestimonialsImg](/static/imgs/CliffordFajardo.png)
Your method is simple, straight to the point and I can practice with it everywhere, even from my phone, that's something I have never had in other learning platforms.
![TestimonialsImg](/static/imgs/FelipeMatheus.png)
I highly recommend Educative. The courses are well organized and easy to understand.
![TestimonialsImg](/static/imgs/AdinaOng.png)
I prefer Educative courses because they have a nice mix of text & images. I find that with full video courses, it can often be too easy to go into passive learning mode.
![TestimonialsImg](/static/imgs/CliffordFajardo.png)
Get access to Educative Cloud Labs