This lab walks you through the steps to query the data present in S3 Bucket with Amazon Athena.
You will practice using Amazon Athena to create a table with a CSV file present in the S3 bucket and query using SQL statements.
Duration: 1 hour
AWS Region: US East (N. Virginia)
What is Amazon Athena?
Amazon Athena provides an interactive query editor where you can easily analyze data present in S3 Bucket using SQL statements.
Since this is a serverless service, you will only be charged for the queries that you run.
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.
You can access Athena with AWS Management console, ODBC / JDBC drivers or API.
Log into AWS Management Console.
Create a Workgroup in Amazon Athena.
Create a table with data present in S3 Bucket.
Query SQL statements in the query editor of Amazon Athena to fetch data from the CSV file present in an S3 bucket.