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

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! courses.beabetterdev.com/courses/aws-learning-a…

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: patreon.com/beabetterdev

📚 MY RECOMMENDED READING LIST FOR SOFTWARE DEVELOPERS📚
Clean Code - amzn.to/37T7xdP
Clean Architecture - amzn.to/3sCEGCe
Head First Design Patterns - amzn.to/37WXAMy
Domain Driver Design - amzn.to/3aWSW2W
Code Complete - amzn.to/3ksQDrB
The Pragmatic Programmer - amzn.to/3uH4kaQ
Algorithms - amzn.to/3syvyP5
Working Effectively with Legacy Code - amzn.to/3kvMza7
Refactoring - amzn.to/3r6FQ8U

🎙 MY RECORDING EQUIPMENT 🎙
Shure SM58 Microphone - amzn.to/3r5Hrf9
Behringer UM2 Audio Interface - amzn.to/2MuEllM
XLR Cable - amzn.to/3uGyZFx
Acoustic Sound Absorbing Foam Panels - amzn.to/3ktIrY6
Desk Microphone Mount - amzn.to/3qXMVIO
Logitech C920s Webcam - amzn.to/303zGu9
Fujilm XS10 Camera - amzn.to/3uGa30E
Fujifilm XF 35mm F2 Lens - amzn.to/3rentPe
Neewer 2 Piece Studio Lights - amzn.to/3uyoa8p

💻 MY DESKTOP EQUIPMENT 💻
Dell 34 inch Ultrawide Monitor - amzn.to/2NJwph6
Autonomous ErgoChair 2 - bit.ly/2YzomEm
Autonomous SmartDesk 2 Standing Desk - bit.ly/2YzomEm
MX Master 3 Productivity Mouse - amzn.to/3aYwKVZ
Das Keyboard Prime 13 MX Brown Mechanical- amzn.to/3uH6VBF
Veikk A15 Drawing Tablet - amzn.to/3uBRWsN   

📚 Resources:
Part 2 - Query Athena from Lambda - youtu.be/a_Og1t3ULOI

Athena Overview - youtu.be/1lzpeVV2hDQ
Getting started with AWS: 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 - twitter.com/BeABetterDevv
Instagram - instagram.com/beabetterdevv/
Patreon - Donations help fund additional content - patreon.com/beabetterdev

#AWS
#Serverless
#BigData