I have over 1 million records in my AWS Dynamo DB table, and I want to modify the records based on color and size attribute. I want to update the status of all those records whose size is not integer and color is null.
Question is - would it be possible to update the status of records of the order of 10-20k?
I researched something and found batchWriteItem is something that can be used, but it just updates 25 records at a time.
If this is not the right place to ask such question, please let me know where can I found the answer of my query?