Categories
aws aws-athena

Query data stored in an S3 bucket with AWS Athena

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. username,user_id,firstname,lastname aldomatic,094,Aldo,Lugo cooluser,043,John,Jones cooluser1,223,Bryan,Baker Our bucket path will be: ~/bucket-name/folder-name/users.csv  Creating a […]