Skip to content

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.
  • Labs icon Lab
  • A Cloud Guru
Google Cloud Platform icon
Labs

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.

Try for free Contact sales
Google Cloud Platform icon
Labs

Path Info

Level
Clock icon Beginner
Duration
Clock icon 1h 30m
Published
Clock icon Oct 21, 2022

Contact sales

By filling out this form and clicking submit, you acknowledge our privacy policy.

Table of Contents

  1. 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.

  2. Challenge

    Set Up Amazon Athena

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

  3. 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.

  4. Challenge

    Add Partition Metadata

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

  5. 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.

A Cloud Guru - Labs - Querying Real Estate Data in S3 Using Amazon Athena
Author
A Cloud Guru

The Cloud Content team comprises subject matter experts hyper focused on services offered by the leading cloud vendors (AWS, GCP, and Azure), as well as cloud-related technologies such as Linux and DevOps. The team is thrilled to share their knowledge to help you build modern tech solutions from the ground up, secure and optimize your environments, and so much more!

What's a lab?

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.

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.

Start learning by doing today

View Plans