36. AWS Athena Explained

Link to the md file : https://github.com/bedwalsanjay/aws-d... n this video, we dive deep into AWS Athena, a powerful serverless query service that allows you to analyze data directly in Amazon S3 using standard SQL—without managing any infrastructure. You’ll learn the core concepts of Athena, how it works behind the scenes, and why it is widely used in modern data engineering architectures. We also demonstrate a practical approach to creating tables in Athena without using AWS Glue Crawlers, which is an important skill for optimizing cost and improving control over schema design. 🔍 What you’ll learn in this video: What is AWS Athena and how it works Key components and architecture Benefits of using Athena in data engineering How Athena queries data directly from S3 Creating external tables manually using SQL (without crawler) When to use crawlers vs manual table creation Important concepts like schema-on-read and partitioning Best practices and real-world usage scenarios This video is perfect for beginners as well as working professionals who want to strengthen their understanding of serverless analytics and improve their AWS data engineering skills.