How to use SQL to Query S3 files with AWS Athena | Step by Step Tutorial

Video Description

In this video, I show you how to use AWS Athena to query JSON files located in an s3 bucket. I show you how to set up an Athena Database and Table using AWS Glue's Crawler. Looking to get hands on experience building on AWS with a REAL project? Check out my course - The AWS Learning Accelerator! https://courses.beabetterdev.com/courses/aws-learning-accelerator 00:16 Introduction to our S3 Dataset 01:57 Specifying an Athena Output Path 02:35 Connecting S3 Data Source to Athena Database 04:08 Using a Glue Crawler to Populate our Database 06:38 Testing our Athena Database with a Simple Query 🎉SUPPORT BE A BETTER DEV🎉 Become a Patron: https://www.patreon.com/beabetterdev 📚 MY RECOMMENDED READING LIST FOR SOFTWARE DEVELOPERS📚 Clean Code - https://amzn.to/37T7xdP Clean Architecture - https://amzn.to/3sCEGCe Head First Design Patterns - https://amzn.to/37WXAMy Domain Driver Design - https://amzn.to/3aWSW2W Code Complete - https://amzn.to/3ksQDrB The Pragmatic Programmer - https://amzn.to/3uH4kaQ Algorithms - https://amzn.to/3syvyP5 Working Effectively with Legacy Code - https://amzn.to/3kvMza7 Refactoring - https://amzn.to/3r6FQ8U 🎙 MY RECORDING EQUIPMENT 🎙 Shure SM58 Microphone - https://amzn.to/3r5Hrf9 Behringer UM2 Audio Interface - https://amzn.to/2MuEllM XLR Cable - https://amzn.to/3uGyZFx Acoustic Sound Absorbing Foam Panels - https://amzn.to/3ktIrY6 Desk Microphone Mount - https://amzn.to/3qXMVIO Logitech C920s Webcam - https://amzn.to/303zGu9 Fujilm XS10 Camera - https://amzn.to/3uGa30E Fujifilm XF 35mm F2 Lens - https://amzn.to/3rentPe Neewer 2 Piece Studio Lights - https://amzn.to/3uyoa8p 💻 MY DESKTOP EQUIPMENT 💻 Dell 34 inch Ultrawide Monitor - https://amzn.to/2NJwph6 Autonomous ErgoChair 2 - https://bit.ly/2YzomEm Autonomous SmartDesk 2 Standing Desk - https://bit.ly/2YzomEm MX Master 3 Productivity Mouse - https://amzn.to/3aYwKVZ Das Keyboard Prime 13 MX Brown Mechanical- https://amzn.to/3uH6VBF Veikk A15 Drawing Tablet - https://amzn.to/3uBRWsN    📚 Resources: Part 2 - Query Athena from Lambda - https://youtu.be/a_Og1t3ULOI Athena Overview - https://youtu.be/1lzpeVV2hDQ Getting started with AWS: https://youtu.be/lTyqzyk86f8 ☁Topics covered include: AWS Athena AWS Athena Database Setup AWS Athena Table Setup AWS Glue Crawler AWS Athena with S3 Json Files AWS Athena SQL Select 🌎 Find me here: Twitter - https://twitter.com/BeABetterDevv Instagram - https://www.instagram.com/beabetterdevv/ Patreon - Donations help fund additional content - https://www.patreon.com/beabetterdev #AWS #Serverless #BigData