Query and GetItem on a DynamoDB Table | Step by Step Tutorial

In this video I show you how to perform DynamoDB GetItem and Query on a DynamoDB Table. I start out by explaining my DynamoDB Table schema, followed by the question I am trying to answer with my query. From there, I create an appropriate IAM role and attach it to my Lambda function. Afterwards, I code up my queries using Python and execute them on a Lambda function.

📚 MY RECOMMENDED READING LIST FOR SOFTWARE DEVELOPERS📚

🎙 MY RECORDING EQUIPMENT 🎙

💻 MY DESKTOP EQUIPMENT 💻

📚 References:

☁Topics covered include:
- DynamoDB Table Design
- DynamoDB Access Policy
- DynamoDB IAM Role
- DynamoDB GetItem
- DynamoDB Query
- DynamoDB KeyConditionExpression
- DynamoDB Partition Key
- DynamoDB Sort Key

🌎 Find me here:

#AWS
#DynamoDB
#Lambda

[alexf]

The partition key and sort key aren’t supposed to be a unique combination? How come there are several PURSHASE _USA as primary key?

[KS-tfri]

Since we're voting; thanks for using Python :)

[kelvinnganga]

is there any good documentation you recommend for doing this in Java, would appreciate it, otherwise thanks a lot your videos are great.By the way with no offense meant, when you say "what's up guys" you sound/remind me of Becky from thenewBoston...

[shristigupta]

why I am not able to see the execution result as shown in video.I am just getting START, END, REPORT

[shaikabdulrahim]

Can you explain hoe to retrieve data items in dynamodb using Java

[Kdb.]

Nice Vid!. Is there a way that Dynamodb able to query multiple attributes filter like
'SELECT * FROM order WHERE userId = 1 and status IN ('processing', 'shipped') AND created_at between (2020, 2021)' by using GSI? thanks

[Overthought]

9:54 Hol up, why is your data showing up so nicely? When I do this, I get some extra garbage in the dict, which the internet says is "dynamoDB JSON". It looks like: `{"Amount":{"N":"25"}, "CustomerId":{"S":"UM3DR7"}}`

[leandrorampim]

Thanks for the Lambda/DynammoDB combo, quite useful^2

[franciskolms]

Would be great if this could be shown with Javascript too. Great video otherwise!

Thanks for the video! Never knew string greater / smaller than string is possible!

[MauriceBoulard]

thanks, in javascript had been great too

[tanmayrane]

great tutorial !! how to connect to API Gateway?

[windowcrystal]

I guess get_item works internally the same as query?

[CaminoalaNube]

Excellent video. A question, how could a specific item of the obtained information be stored in a variable?

[pavelow]

exactly what I needed. great help thanks!

[karimfayed]

Great video! What if I want to get a list of all primary keys that I have in a table? should I still use query and if so how?

[antoniogigliotti]

Is there a reason that your output does not include the type of each value? When I try to run get_item, my output always includes the type of each value.

[mtin]

Would have loved to see this being done with javascript

[hellehofnar]

I know this is just a demo, but isn't the primary key (partition key and sort key) questionable since there will be many dublicates (or overwrites rather)? e.g. Several transactions of same type on one date in one region. Or do i misunderstand the primary key concept?

[aashi]

I am new in this field. Can you let me know if we can have two connection in the same lambda. Query redshift and query DynamoDB in the same lambda . I am working in python.