Athena & Glue: Query a Data Lake
Crawl S3 data with AWS Glue, query it with Athena, and see how partition pruning cuts cost and latency in a serverless data lake.
Lab Overview
Build a serverless data lake pattern end-to-end. You will upload partitioned CSV sales data to S3, create a Glue crawler that automatically discovers the schema and populates the Data Catalog, then query the data interactively with Athena. Finally, you will compare a full-table scan against a partition-pruned query to see the cost and performance difference first-hand.
You'll learn to:
- Organize S3 data using Hive-style partitioning (year=YYYY/month=MM)
- Create an AWS Glue IAM role, database, and crawler
- Run a Glue crawler and inspect the resulting Data Catalog table
- Execute SQL queries with Amazon Athena from the CLI
- Use partition filters to reduce data scanned and lower query cost
What You'll Learn
Upload partitioned data to S3 using Hive-style key prefixes
Create an AWS Glue database, IAM role, and crawler
Run a Glue crawler and verify the Data Catalog table
Query data with Athena SQL from the AWS CLI
Apply partition pruning to reduce data scanned and cost
Prerequisites
AWS CLI basics
S3 bucket fundamentals
Basic SQL knowledge
Technologies Covered
Choose your plan
Simple, Transparent Pricing
Unlock full access to TeKanAid courses, labs, and bootcamps
Pro
Course content without labs
Renews automatically. Cancel anytime.
Final price verified at checkout.
- Full access to all courses
- Progress tracking
- Certificate of completion
- Community access
- Bootcamp participation
- New content access
Premium
Full access with hands-on labs
Renews automatically. Cancel anytime.
Final price verified at checkout.
- Everything in Pro
- Unlimited hands-on labs
- Lab AI Assistant
- Accelerator bootcamps with live office hours
- Priority support
Prefer a single course?
Purchase individual courses for a one-time fee of $79. Full access to course content, quizzes, certificates, and community features, lab access is not included.
Browse CoursesTry it free, no credit card
Three free ways to start. All bridge into the paid Premium catalog when you're ready.
Not ready to commit? The crash course is email-only. No academy account required.
Ready to Get Started?
Start this hands-on lab and build real-world Platform Engineering skills
Get Access Now