Querying Data in S3 with Amazon Athena

Lab Details

  1. This lab walks you through the steps to query the data present in S3 Bucket with Amazon Athena. 

  2. You will practice using Amazon Athena to create a table with a CSV file present in the S3 bucket and query using SQL statements.

  3. Duration: 1 hour

  4. AWS Region: US East (N. Virginia)

Introduction 

What is Amazon Athena?

  1. Amazon Athena provides an interactive query editor where you can easily analyze data present in S3 Bucket using SQL statements.

  2. Since this is a serverless service, you will only be charged for the queries that you run.

  3. In the backend, Amazon Athena uses Presto which supports standard SQL statements and works with different flavors of standard data formats, which includes CSV, ORC, JSON, Arvo and Apache Parquet. 

  4. You can access Athena with AWS Management console, ODBC / JDBC drivers or API.

Task Details

  1. Log into AWS Management Console.

  2. Create a Workgroup in Amazon Athena.

  3. Create a table with data present in S3 Bucket.

  4. Query SQL statements in the query editor of Amazon Athena to fetch data from the CSV file present in an S3 bucket.

Architecture Diagram




Join Whizlabs_Hands-On to Read the Rest of this Lab..and More!

Step 1 : Login to My-Account
Step 2 : Click on "Access Now" to view the course you have purchased
Step 3 : You will be taken to our Learn Management Solution (LMS) to access your Labs,Quiz and Video courses