Athena is a serverless query service that allows you to run SQL queries on your data stored in S3. It can easily query large datasets (or Data Lakes), whether they are structured, unstructured, or semi-structured data. A database in Athena is a logical grouping for tables you create in it.
In this short guide, you will learn how to connect to CSV data in S3 bucket with Athena database. Let’s get started.
The AWS glue crawler will help to catalog the table and give it the right schema. The steps are highlighted below.
Step 1: Open the Athena database from your AWS console and toggle to the database you want to create the table on. Click on Create table.
Step 2: Click on “from AWS Glue Crawler”. The “from S3 bucket data” is the manual process where you will enter the data columns manually.
After you have clicked on the from AWS Glue Crawler you will be transferred to the AWS Glue platform for the crawler definition.
