A walkthrough example of how you can query the S3 files using AWS Athena

Amazon Athena is an interactive query service that makes it easy to analyze data directly in S3 using SQL. In this tutorial, we will show how to connect Athena with S3 and start using SQL for analyzing the files. Athena is serverless, and you pay only for the queries you run. It scales automatically which means that the queries run fast even with large datasets.ScenarioAssume that you have a csv file at your computer and you want to create a table in Athena and start running queries on it. For simplicity, we will work with the iris.csv dataset. The steps that we are going to follow are:

• Create an S3 BucketUpload the iris.csv dataset to the S3 BucketSet up a query location in S3 for the Athena queriesCreate a Database in AthenaCreate a tableRun SQL queries

#sql #athena #aws #amazon #s3