Can I get multiple items by partition key in aws management console for Ddynamodb without using BatchGetItem. My Partition key is abcd1 abcd1 abcd2.
CodePudding user response:
You cannot do this within the DynamoDB web UI because a Query which is used can only retrieve a single item collection, but you can achieve it using the PartiQL editor using SQL language.
SELECT * FROM mytable WHERE pk IN ['abc1','abc2']
You will need to modify the statement to suit your specific needs