AWS Lab

Getting Started With AWS Athena

We deploy the real environment, you take the scenario-based labs on us. Hands-on, from anywhere, at any time.

Time required: 2 Hours

Suggested Pre Requisites

This is a Beginner's level lab. Pre-requisites include familiarity with Amazon S3.

Objectives

Objective of this lab is to learn how to use AWS Athena to query data stored in S3 buckets.

Overview

This lab allows you to practice analyzing data stored in S3 using SQL queries in AWS Athena. We create a database and table using Hive DDL and further query the data in the table using SQL.

Scenarios

1. Create a database using Hive DDL.
2. Create a table within the database using Hive DDL.
3. Query the data in the table using SQL.
4. Save the results to a CSV file.
5. Change the default query result location and verify that the query results are stored in the new location specified.
6. Use the query result file to create another table using the "Add table" wizard.
7. Further analyze this new table by SQL query.

Share our Labs
Start Your Free Trial

We have the longest and most in depth courses about cloud and engineering topics on the web. All of our training content is included with every membership.