Use Athena to Query Data in S3
This is a simple video just to show how to have files available in a /folder in s3, from which you can specify variables for the csv variables discovered in the folder, from which Athena will load tables into automatically from into a database you've created within Athena.
The important thing to remember (other than correct file formatting, which I've displayed in a text view of what my cats.csv file looks like), is that if you're specifying an S3 folder to search for the csv file, it's going to go through the whole folder, which can add a lot of undesirable complexity to that table. You must isolate the file you want in a special folder if you're interested only in the contents of the one csv file. I named this folder '/athena'