Note: I’m assuming that you’re an IAM user with admin access.
Adding some data to an S3 bucket.
The data format we will be using for this example is a CSV. Below is a sample of the data and how it’s structured, nothing complicated.
Our bucket path will be:
Creating a table and schema in AWS Athena
Head over to the Athena dashboard and lets create a new table manually. We will be going through the creation wizard. I will provide screenshots along the way. Note that we will also be creating a database along with our table. See step 1.
Lets kick things off.
Since we are working with CSV files we select the appropriate date format.
Don’t worry about add partition section, this is a whole other topic to discuss. For now just click on create table.