DynamoDb truncating attribute value upto certain length

Question

Hi AWS experts,
I have a use case where I am trying to insert a large xml string as an attribute value to an item. I do see that the value is getting truncated to 32604 characters after saving it. I do know that an item max size can be 400KB which includes sum of all attribute names and attribute values and this is inclusive of the same item which is projected in LSI of that DynamoDB table. My question is this what is expected if we try to insert large String in an item ? Is my assumption correct ?

Accepted Answer

Yes your assumption is likely to be correct if the item's other attributes add up to take it over 400Kb.

Note DynamoDB is intended as on OLTP DB supporting large amounts of small operations.  If you have a large piece of data associated with your record it might not be best to store that directly in your database. You'll clog up the RAM and churn your disk I/O as you read and write that blob, and may get expensive.  Put the blob in S3 instead.  Your database record can include a pointer to the object in S3, and you can load it out when it's needed. S3 has a better pricing model for reading and writing large blobs of data, and it won't put extra strain on your database.

Answer

You can have string values in excess of 32kb in DynamoDB. I wouldn't want to do it frequently, but it's allowed.

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/ServiceQuotas.html says:
"The length of a String is constrained by the maximum item size of 400 KB."

My guess is something else in your stack is truncating the string if you're seeing truncation. It's not DynamoDB itself.

DynamoDb truncating attribute value upto certain length

相關內容