Amazon Athena makes it easy to explore your data stored in S3 using standard SQL queries. Whether you want to query log files, application data or really any other kind of data, Athena effectively lets you treat your S3 files as a database rather than as flat files.
In this beginner-friendly tutorial, I’ll walk you through everything you need to know to get started with Athena. Learn what Athena is, how much it costs, and how to query data stored in S3 using AWS Glue. We’ll cover setting up your S3 bucket, creating tables and an AWS Glue database, running the AWS Glue Crawler, and querying your data in the Athena query editor.
Also be sure to stick around to the end where I’ll walk you through how to delete the resources we spin up.
🌟 ***RESOURCES AND LINKS USED IN THIS VIDEO*** 🌟
• orders.csv file (upload to your S3 bucket): https://drive.google.com/file/d/1HZmmPYDa2ZdSgvu965tMNL6LFGR_EGS0/view?usp=sharing
• Amazon Athena pricing: https://aws.amazon.com/athena/pricing/
🌟 ***OTHER VIDEOS YOU MIGHT ENJOY*** 🌟
• Basics of S3: https://youtu.be/mDRoyPFJvlU
• Basics of CloudWatch: https://youtu.be/Yxl7e88cTAQ
🌟 ***MY AWS COURSES*** 🌟
If you’re interested in getting AWS certifications, check out these full courses. They include lots of hands-on demos, quizzes and full practice exams. Use FRIENDS10 for a 10% discount!
- AWS Certified Cloud Practitioner: https://academy.zerotomastery.io/a/aff_n20ghyn4/external?affcode=441520_lm7gzk-d
- AWS Certified Solutions Architect Associate: https://academy.zerotomastery.io/a/aff_464yrtnn/external?affcode=441520_lm7gzk-d
🌟 ***TIMESTAMPS*** 🌟
00:00 – What is Amazon Athena and why would you use it?
01:32 – How much will this cost me? Athena pricing
02:06 – Creating an S3 bucket and uploading a CSV file to it
03:35 – Opening the Amazon Athena query editor
04:05 – Setting up an S3 bucket for query results
05:16 – How do I query results from an S3 bucket?
06:31 – What is a table, database (schema) and data source (data catalog) in Amazon Athena and AWS Glue?
08:08 – Three different ways to create a table in Athena
09:25 – Creating a new table in Athena using the AWS Glue Crawler
12:30 – Running the AWS Glue Crawler on-demand
13:35 – Big-picture architecture for Amazon Athena, AWS Glue and S3
14:07 – Using Amazon Athena to query S3 data through the AWS Glue Data Catalog
16:33 – IMPORTANT!! Delete your resources