Amazon Athena Explained: Querying S3 Data | Step by Step AWS Tutorial for Beginners

Video Description

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