DynamoDB Scan vs Query - The Things You Need To Know

DynamoDB Scans and Queries are two important operations you're going to be performing regularly as a user of DynamoDB. In this video, learn the key differences between these operations (with examples) and when to use one over the other.
Become a Better Developer Using the Courses I Recommend Below:
- Master FAANG Coding Interviews - bit.ly/3CVgRN9
- Learn AWS From Scratch - bit.ly/3gasoAm
- Master Python here - bit.ly/3yJFJpI
🎉SUPPORT Daniel @ BE A BETTER DEV🎉
Become a Patron: / 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 Driven 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
🌎 Find me here:
Twitter - / beabetterdevv
Instagram - / beabetterdevv
Patreon - Donations help fund additional content - / beabetterdev
#AWS
#DynamoDB
#Serverless

[@ralfrolfen5504]

Really good content! Well presented! No annoying background music. No annoying intro to the channel. No "Hey what's up guys". No strange accent; Just good, plain English.

[@BeABetterDev]

Glad you enjoyed it!

[@srb1855]

Excellent video! The release of your video is fortuitous - I am studying for my first AWS certification and just completed a dynamoDB lab the other night. However none of these subtleties you described were highlighted. Thanks for providing your insights. 👍

[@mumtazirteqaahmed8553]

Great explanation! On Point!

[@BullishBuddy]

Wonderful video!!

[@jesusesquivelroman7524]

Very nice video! Very educational. What if in my Customer Order table I have other fields like "Country" and "Product Type" and I want to filter, for example, "Tech" products bought in the "US". How will I query or fetch that data?

[@tiagosantos680]

Super well done video

[@jonathanduran2921]

Can you do operations like give me all customers with id greater than 1 on the partition key? Or are you limited to one value for the partition key for each query?

[@kerisnarendra]

Is it additional cost when querying on GSI?

[@fafapw]

Great video, dude! In my case, I'm using PK , but I have others 3 GSIs. The behavior is the same using GSI and his sort key comparing with PK + his sort key? thanks in advance!

[@BeABetterDev]

Hi Fabricio! The Sort key logic applies the same way to GSIs as it does to PKs. Hope this clarifies!

[@DuyLe-gq6cu]

I use query to get data, but it also limit 1mb data like you explain scan.

[@rickharold7884]

Cool.

[@hoddybhaba6704]

impeccable!!!

[@BeABetterDev]

Thanks Hoddy!

[@karimfayed3050]

Great Video! But what if I want to return a list with all my primary keys which method should I use and how to use it?

[@albintsafack1232]

Hi ! please did you find the answer of this question ? I'm also asking me this question

[@hetalraval3928]

In my case i want to scan all data each time to compare with my response to know where update occur or insert and according to that i want to perform other requests...so what could be the best possible way?

[@fadichamieh]

put a modified/created timestamp in your data, and filter based on that

[@moneeshkumar1838]

Is it possible to parallel query operation? Just like parallel scan operation

[@BeABetterDev]

Hi Moneesh, I don't know of any built-in method to do this beyond using multiple threads and firing off separate queries. There's a good article on this topic by AWS here: aws.amazon.com/blogs/database/use-parallelism-to-optimize-querying-large-amounts-of-data-in-amazon-dynamodb/ Hope this helps

[@moneeshkumar1838]

@@BeABetterDev Thanks Man Appreciated

[@pablogonzalezrobles4429]

Nice video. Question: How should be format the datetime for using query with between? dd:mm:yyyy hh:mm:ss? Or do we need to separate date and time? Any suggestions about querying dt columns.

[@adds-kz3oc]

Personally, I convert DateTimes to Unix timestamps. 28:10:2021 20:00:00 => 1635447600. You can then query for values less than, greater than, or between the dates.

[@vimalpatel44]

are RangeKey and sortkey same?

[@dadestor]

Yes

[@naga_sai]

Do we need to Partition key all the times while querying (When I want to filter based on other normal keys)?

[@zagamendes2438]

You said when using query I need to know my pk, but what if I just want to list my data? Eg to do list, Will I have to use scan?