Querying Real Estate Data in S3 Using Amazon Athena

Libraries: If you want this lab, consider one of these libraries.
Cloud
Data

Querying Real Estate Data in S3 Using Amazon Athena

In this AWS hands-on lab, you’ll use Amazon Athena to query sample data of sold Manhattan houses stored in Amazon S3. To do so, you’ll first upload the sample data to Amazon S3, partition the data in Hive format, create an underlying table in Amazon Athena, and finally, use the Amazon Athena query editor to run SQL queries against the estate data.

Get started Contact sales

Lab Info

Level

Beginner

Last updated

Sep 23, 2025

Duration

1h 30m

Challenge

Populate S3 with Manhattan Real Estate Data

Download the CSV files from this lab's GitHub repository, and upload them to Amazon S3.

Note: For partitioning purposes, make sure to create a respective folder for each CSV file.
Challenge

Set Up Amazon Athena

Create a folder in Amazon S3 and update query results in Amazon Athena using that folder.
Challenge

Create a Table from the S3 Bucket Metadata

Create a database and a table using the first and second queries found in the README file. If everything is successful, you should see the table listed under Tables and views.
Challenge

Add Partition Metadata

Load the partitions and confirm they have been loaded using the third command in the README file.
Challenge

Query Data Using SQL

Query the data using SQL. You can use several different SQL queries to explore the data; for example, you can use the fourth command in the README file.

About the author

Pluralsight Skills

Pluralsight Skills gives leaders confidence they have the skills needed to execute technology strategy. Technology teams can benchmark expertise across roles, speed up release cycles and build reliable, secure products. By leveraging our expert content, skill assessments and one-of-a-kind analytics, keep up with the pace of change, put the right people on the right projects and boost productivity. It's the most effective path to developing tech skills at scale.

Real skill practice before real-world application

Hands-on Labs are real environments created by industry experts to help you learn. These environments help you gain knowledge and experience, practice without compromising your system, test without risk, destroy without fear, and let you learn from your mistakes. Hands-on Labs: practice your skills before delivering in the real world.

Learn by doing

Engage hands-on with the tools and technologies you’re learning. You pick the skill, we provide the credentials and environment.

Follow your guide

All labs have detailed instructions and objectives, guiding you through the learning process and ensuring you understand every step.

Turn time into mastery

On average, you retain 75% more of your learning if you take time to practice. Hands-on labs set you up for success to make those skills stick.