How to Query Your DynamoDB Table with SQL using Athena

DynamoDB is a NoSQL database that provides exceptional performance for OLTP workloads. However, it isn't suitable when trying to query datasets using broad criteria. In this video, I show you how to export your DynamoDB table and query it using SQL. You'll learn how to export your table into S3, set up a glue crawler, and finally interact with your data through Athena using SQL. I also show you how to query nested objects like DynamoDB Maps and Lists.

Athena queries - https://gist.github.com/beabetterdevv...

Sign up for my Newsletter to receive regular AWS updates https://mailinglist.beabetterdev.com

🎉SUPPORT BE A BETTER DEV🎉
Become a Patron:   / 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 Driven 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

🌎 Find me here:
Twitter -   / beabetterdevv  
Instagram -   / beabetterdevv  
Patreon - Donations help fund additional content -   / beabetterdev  

#SoftwareEngineer
#SoftwareDeveloper