Error: DynamoDB Is Not Null

Answered by Rafal Wilinski
What's Causing This Error
In DynamoDB, the "Not Null" constraint is automatically enforced for all primary key attributes and secondary index key attributes. This means that when you insert or update an item, all primary key and secondary index key attributes must have a value, and cannot be null. If you try to insert or update an item with a null value for a primary key or secondary index key attribute, you will receive an error.
Solution: Here's How To Resolve It
There are a few ways to solve the error of trying to insert or update an item with a null value for a primary key or secondary index key attribute in DynamoDB:
- Provide a non-null value for the primary key or secondary index key attribute when inserting or updating the item.
- If the primary key or secondary index key attribute is optional, you can use the
NULLvalue to indicate that the attribute is not present. - You can also change the schema of your table to allow for null values in primary key or secondary index key attributes. However, this is not recommended as it can lead to data inconsistencies and may make it difficult to query your data.
- If you are updating a item, you can use the
update_itemmethod and use acondition_expressionto ensure the value is not null before updating the item - If you are using the AWS SDK, you can also use the ConditionExpression parameter in the PutItem and UpdateItem operations to check for
nullvalues and prevent the item from being inserted or updated if the condition is not met.
Other Common DynamoDB Errors (with Solutions)
- DynamoDB batch write is not working
- could not unmarshal the value dynamodb
- DynamoDB Local Docker Not Working
- DynamoDB Error 413
- DynamoDB Local Cannot Create Preexisting Table
- DynamoDB Delete Not Working
- dynamodb does not support null values
- DynamoDB - The Security Token Included In The Request Is Invalid
- dynamodb could not instantiate class
- dynamodb query is null
- dynamodb table not exists
- dynamodb update fail if not exists
- dynamodb could not load credentials from any providers
- dynamodb cannot create preexisting table
- dynamodb system errors metric
Dynobase is a Professional GUI Client for DynamoDB
Start your 7-day free trial today
Product Features
- New in Dynobase 3.0
- Semantic and Vector Search
- Schema Explorer
- Visual JSON Path Filtering
- Visual Item Diff
- MCP Server for AI Tools
- Use SQL with DynamoDB
- Import CSV To DynamoDB
- Import JSON To DynamoDB
- Export DynamoDB To JSON
- Export DynamoDB To S3
- Export DynamoDB To CSV
- DynamoDB Update Item
- DynamoDB Delete All Items
- DynamoDB Delete Item
- DynamoDB Create Table
- DynamoDB Delete Table
- DynamoDB Conditional Update
DynamoDB Tools
DynamoDB Info
© 2026 Dynobase