How to Query Your DynamoDB Table with SQL using Athena

Video Description

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/2c8e5f89cd812b06929d7306a750c01b Sign up for my Newsletter to receive regular AWS updates https://mailinglist.beabetterdev.com 🎉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 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 - https://twitter.com/BeABetterDevv Instagram - https://www.instagram.com/beabetterdevv/ Patreon - Donations help fund additional content - https://www.patreon.com/beabetterdev #SoftwareEngineer #SoftwareDeveloper