Articles → AWS → Athena In AWS

Athena In AWS

In this article, we will discuss Athena in AWS.

Purpose

Athena is used to query the data in S3 bucket using SQL.

For this article, we will work on the following steps: -

Let us work on each step.

First, create a sample CSV file. For this article, I am creating this file.

In the second step, we will upload the CSV file on the S3 bucket. For creating the S3 bucket, you can refer to this article.

First, search the word athena in the search box and click on the Athena service in the search result.

Click to Enlarge

An Athena service screen will appear. Click on the Explore the query editor button.

Click to Enlarge

In the next screen, click on the View settings button to navigate to the settings screen.

Click to Enlarge

In the settings screen, click on the Manage button to navigate to the manage settings screen.

Click to Enlarge

In the manage settings screen, enter the location of the S3 bucket and click on the Save button.

To create the database, click on the Create → S3 bucket data in the Editor tab in the Athena service screen.

Click to Enlarge

A screen appears to enter the Table name.

Click to Enlarge

Scroll down to enter the Database name and the S3 bucket location.

Click to Enlarge

Scroll down further to select the Data Format as CSV.

Click to Enlarge

Scroll further down to enter the column details

Click to Enlarge

Scroll to the bottom and click on the Create table button.

To create the data, write the SQL query and click on the Run button.

Click to Enlarge

You will get the following results.

Yes, Athena is serverless because you do not manage any infrastructure like EC2, EBS etc.

Query/Feedback