Scan or Query operation on DynamoDB using python Boto3

Question

I have users table, users have user_id field.

I need to get all the user details with given list, like ["1234","3456"].

There is no contain like queries in Boto3.

I'm using

response = table.scan(FilterExpression=Attr('user_id').is_in(["1234","3456"]))

But I'm not getting the expected results.

Correct me If I missed anything.

try to use in(["1234","3456"]) instead of is_in.

Sergey Pugach
– Sergey Pugach

2019-12-19 12:38:51 +00:00
Commented Dec 19, 2019 at 12:38 — Sergey Pugach
– Sergey Pugach, Commented Dec 19, 2019 at 12:38
In Boto3 we dont have any option like "in"

Seetharaman GR
– Seetharaman GR

2019-12-19 12:54:15 +00:00
Commented Dec 19, 2019 at 12:54 — Seetharaman GR
– Seetharaman GR, Commented Dec 19, 2019 at 12:54

Gustavo Tavares · Accepted Answer · 2019-12-19 22:06:22Z

1

One question that you need to answer is: user_id is your DynamoDB Hash/Partition Key? If it is, then the operation that you are looking for is: BatchGetItem. You can see how it works here.

If user_id is not your Partition/Hash Key, a first (and wrong) solution would be to scan the entire table and filter its data (a very expensive method that should be avoided at all costs). A second, more efficient solution would be to create a global index (GSI) using user_id as Hash/Partition Key and project the data to be returned in the index. You can learn more about GSI's here.

answered Dec 19, 2019 at 22:06

Gustavo Tavares

2,81517 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Scan or Query operation on DynamoDB using python Boto3

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related