Remove item from DynamoDB with composite sorting key

Question

I have a composite sorting key "123#abc" and I want to remove the item starting with "123".
I can query with such a prefix but I didn't find how to delete an item using a prefix.
AWS doc says I need to provide both partition and sorting keys.
Is it possible to remove an item using a prefix of sort key?

I can query for exact sorting key before removal but I'm curious if delete operation supports this.

Leeroy Hannigan · Accepted Answer · 2023-08-03 11:07:26Z

3

Unfortunately its not supported, for a singleton operations such as DeleteItem, GetItem, PutItem etc... you must know the entire primary key, that is Partition and Sort keys (if a sort key exists).

The only option is to read using Query, then loop the results and call DeleteItem with the keys obtained.

answered Aug 3, 2023 at 11:07

Leeroy Hannigan

20.5k4 gold badges23 silver badges46 bronze badges

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

1 Comment

Tofig Hasanov Over a year ago

Probably worth batching deletes using BatchWriteItem for better performance

Collectives™ on Stack Overflow

Remove item from DynamoDB with composite sorting key

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related