AWS Athena: Serverless, Interactive Data Manipulation Service by Amazon

Overview

Amazon Athena is an interactive query service offered by Amazon that makes it easy to explore data directly in the Amazon S3 bucket using standard SQL. Athena is serverless, so there is no infrastructure to manage, and we only pay for the queries we run. Athena is easy to use. It simply directs the data that is present in an S3 bucket and starts querying the data using standard SQL. Most results are delivered within seconds.

Athena is used to analyze the data which is already available in the Amazon S3 bucket. Athena can operate with various types of structured and unstructured data types which include data formats like CSV, JSON, and ORC. If you want to do interactive, ad hoc SQL queries against data stored in Amazon S3, you should use Athena. Athena provides us with the easiest way to run queries for data in the Amazon S3 bucket.

Without the need to format data, Amazon Athena can perform interactive queries on the data stored in Amazon S3. For example, if you need to quickly check the web server logs to investigate a problem with our website, Athena can be helpful.

Benefits of Athena

• Flexible
• Serverless
• Cost-Effective
• Widely accessible
• Fast performance
• Secure
• Easy integrations with other AWS services

Workflow of Athena

Demo on Athena

Step 1: Open the AWS S3 console.

Step 2: Click on create a bucket. Enter the bucket name.

Step 3: Click on create a bucket.

Step 4: Create a Test folder in the bucket. And upload one CSV file.

Step 5: We have 3 columns of data in a CSV file.

Step 6: Open the Amazon Athena console.

Step 7: Click on settings and select our S3 bucket in the query result location which is already created in the previous steps.

Step 8: Using the below query we can create a database and we need to select a database.

Step 9: There are many options in the dropdown for creating a table. We need to select S3 bucket data.

Step 10: Enter the table name and choose our existing database.  

Step 11: Select the location where your data is stored.

Step 12: Select the input file format which is uploaded in the bucket.

Step 13: Enter the column name and select the Column type. We have only 3 columns if you have too many columns in your file, then you can use the bulk column feature.

Step 14:  Click on create a table.

Step 15: Now we will query the data which is in the file using standard SQL.

• I am running the below query to display only “Kashyap” name data.
• select * from demo where Name = ‘Kashyap’;

Conclusion

As you can see in the blog, Amazon Athena is not a complex service. We can use it easily and makes our workflow simpler. We just need to write proper queries for an accurate result within the seconds. I have covered all the points of Amazon Athena. If you want more learn about Amazon Athena, you can refer official document of amazon Athena – https://docs.aws.amazon.com/athena/

About CloudThat