Home/ Questions/Q 424
Next
Answered
Kenil Vasani
Kenil Vasani

Kenil Vasani

View Profile
  • 9
Asked: 2020-12-11T20:36:20+00:00 In:

“The provided key element does not match the schema” error when getting an item from DynamoDB

  • 9

This is the table partition key setting
enter image description here

The table content
enter image description here

When I tried to get an item from the table, it prints this error

botocore.exceptions.ClientError: An error occurred
(ValidationException) when calling the GetItem operation: The provided
key element does not match the schema

This is my code

dynamodb = boto3.resource('dynamodb')
table = dynamodb.Table('testDynamodb')
response = table.get_item(Key={'userId': "user2873"})
item = response['Item']
print(item)

Any ideas? thanks.

amazon-dynamodbboto3python
Share

    1 Answer

    1. Rohit Patel

      Rohit Patel

      View Profile
      Best Answer

      Your table schema has both hash key and sort key defined. When using DynamoDB GetItem you must provide both of them, here is an excerpt from documentation

      For the primary key, you must provide all of the attributes. For
      example, with a simple primary key, you only need to provide a value
      for the partition key. For a composite primary key, you must provide
      values for both the partition key and the sort key.

      So given your example, here is how get_item parameters should look like:

      response = table.get_item(Key={'userId': "user2873", 'createdAt': "1489376547"})
      • 8

    You must login to add an answer.