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.

Screen Shot 2018-03-08 at 5.42.14 PM

Step: 1

Screen Shot 2018-03-08 at 5.53.46 PM

Step: 2
Since we are working with CSV files we select the appropriate date format.

Screen Shot 2018-03-08 at 10.08.08 PM
Step: 3
This is were we define our schema for our data. The screenshot below gets cut off but just add all four columns and all of type string.

Screen Shot 2018-03-08 at 10.37.58 PM

Step: 4
Don’t worry about add partition section, this is a whole other topic to discuss. For now just click on create table.

Screen Shot 2018-03-08 at 10.41.03 PM