Transform Data Using AWS Glue and Amazon Athena
In this lab, you'll practice transforming data with AWS Glue and then analyzing the result with AWS Athena. When you're finished with this lab, you'll have a solution to transform and query data.
Terms and conditions apply.
Challenge
Crawl Input Sales Data on S3
You’ll learn how to set up a Glue data crawler, then how to crawl the data in a S3 folder to populate the Glue Data Catalog with metadata about the S3 data.
Challenge
Convert Sales Data with a Glue Job
You’ll create a new Glue Job to convert the sales data from the CSV format to the Parquet format.
Challenge
Crawl Output Sales Data on S3
You’ll set up another Glue data crawler, to crawl the Parquet files created in the previous challenge, and write details about them into the Glue Data Catalog.
Challenge
Analyze Sales Data with Athena
You’ll configure Athena and then analyze the sales data with Athena.
Provided environment for hands-on practice
We will provide the credentials and environment necessary for you to practice right within your browser.
Guided walkthrough
Follow along with the author’s guided walkthrough and build something new in your provided environment!
Did you know?
On average, you retain 75% more of your learning if you get time for practice.
Recommended prerequisites
- AWS S3 basics
- SQL basics