Analyzing S3 Data and CloudTrail Logs Using Amazon Athena
Analyzing S3 Data and CloudTrail Logs Using Amazon Athena

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.

8 Tasks

beginner

1hr 30m

Certificate of Completion

Desktop OnlyDevice is not compatible.
No Setup Required
Amazon Web Services

Learning Objectives

A thorough understanding of core Amazon Athena concepts, including setting up a query editor and running SQL queries
Proficiency in integrating Athena with AWS CloudTrail to explore and analyze logs of AWS account activity
Familiarity with setting up and configuring an S3 bucket to store data and files securely
The ability to create and configure AWS Glue crawlers to automatically discover and infer the schema of data stored in S3 buckets

Technologies
AWS logoAWS
Athena
S3
CloudTrail
Glue
Skills Covered
Using AWS Cloud Services
Cloud Lab Overview

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:

Process S3 bucket data using AWS Glue crawler and Athena
Process S3 bucket data using AWS Glue crawler and Athena
Process CloudTrail logs with Athena
Process CloudTrail logs with Athena

Cloud Lab Tasks
1.Introduction
Getting Started
2.Process S3 Bucket Data Using AWS Glue Crawler and Athena
Create an S3 Bucket and Upload Data
Configure AWS Glue Crawler
Run an SQL Query Using Athena
3.Process CloudTrail Logs with Athena
Enable CloudTrail Logging
Create Athena Table and Analyze Logs
4.Conclusion
Clean Up
Wrap Up
Labs Rules Apply
Stay within resource usage requirements.
Do not engage in cryptocurrency mining.
Do not engage in or encourage activity that is illegal.

Trusted by 1.4 million developers working at companies including

Don’t take our word for it. See what our developers have to say.

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.

Felipe Matheus
TestimonialsImg

I highly recommend Educative. The courses are well organized and easy to understand.

Adina Ong
TestimonialsImg

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.

Clifford Fajardo
TestimonialsImg

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.

Clifford Fajardo
TestimonialsImg
Don’t take our word for it. See what our developers have to say.

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.

Felipe Matheus
TestimonialsImg

I highly recommend Educative. The courses are well organized and easy to understand.

Adina Ong
TestimonialsImg

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.

Clifford Fajardo
TestimonialsImg

Get access to Educative Cloud Labs

Course Footer Image
Course Footer Image