DynamoDB validation exception on lambda

Question

I am getting the following error when calling my lambda skill

ClientError: An error occurred (ValidationException) 
when calling the CreateTable operation: 1 validation error detected: 
Value '[com.amazonaws.dynamodb.v20120810.KeySchemaElement@2273ace6, 
com.amazonaws.dynamodb.v20120810.KeySchemaElement@4d13ab9, 
com.amazonaws.dynamodb.v20120810.KeySchemaElement@115e22b2]' at 
'keySchema' failed to satisfy constraint: Member must have length less than or equal to 2

Here is the code:

def write_values_to_db(ddid, token, intent):
    pid = ...
    dynamodb_client = boto3.client('dynamodb')
    try:
        response = dynamodb_client.create_table(
            AttributeDefinitions=[
                {
                    'AttributeName': 'pid',
                    'AttributeType': 'S',
                },
                {
                    'AttributeName': 'ddid',
                    'AttributeType': 'S',
                },
                {
                    'AttributeName': 'token',
                    'AttributeType': 'S',
                },
            ],
            KeySchema=[
                {
                    'AttributeName': 'pid',
                    'KeyType': 'HASH',
                },
                {
                    'AttributeName': 'ddid',
                    'KeyType': 'RANGE',
                },
                {
                    'AttributeName': 'token',
                    'KeyType': 'RANGE',
                },
            ],
            ProvisionedThroughput={
                'ReadCapacityUnits': 5,
                'WriteCapacityUnits': 5,
            },
            TableName='Values',
        )
    except dynamodb_client.exceptions.ResourceInUseException:
        dynamodb_client.put_item(
            TableName='Values',
            Item={
                'pid': pid,
                'ddid': ddid,
                'token': token
            }
        )

According to my dashboard the error is on the TableName='Values' line. I was following a tutorial and only changed certain things so I don't see why this is not working. I can't test on a local environment because I have region/credential issues.

DynamoDB requires one hash key and not more than one range key in the primary key, does it not? — Michael - sqlbot
– Michael - sqlbot, Commented Sep 9, 2017 at 0:32

Kannaiyan · Accepted Answer · 2017-09-11 18:26:30Z

6

The KeySchema in your code should be as below,

AttributeDefinitions=[
            {
                'AttributeName': 'pid',
                'AttributeType': 'S',
            }
        ],
KeySchema=[
                {
                    'AttributeName': 'pid',
                    'KeyType': 'HASH'
                }
]

You can have only one Hash Key and One Range Key Max.

If you want to additional indexes, you can create them with secondary indexes.

http://docs.aws.amazon.com/amazondynamodb/latest/developerguide/LSI.html

Below would be the syntax for Global Secondary Index.

Reference: http://docs.aws.amazon.com/AWSJavaScriptSDK/latest/AWS/DynamoDB.html

GlobalSecondaryIndexes: [
    {
      IndexName: 'STRING_VALUE', /* required */
      KeySchema: [ /* required */
        {
          AttributeName: 'STRING_VALUE', /* required */
          KeyType: HASH | RANGE /* required */
        },
        /* more items */
      ],
      Projection: { /* required */
        NonKeyAttributes: [
          'STRING_VALUE',
          /* more items */
        ],
        ProjectionType: ALL | KEYS_ONLY | INCLUDE
      },
      ProvisionedThroughput: { /* required */
        ReadCapacityUnits: 0, /* required */
        WriteCapacityUnits: 0 /* required */
      }
    },
    /* more items */
  ]

edited Sep 11, 2017 at 18:26

answered Sep 9, 2017 at 1:51

Kannaiyan

13.1k4 gold badges52 silver badges91 bronze badges

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

4 Comments

Jeremy Fisher Over a year ago

I'm not sure if I want additional indices, I just want additional attributes. I want pid to be the primary key and ddid and consent_token to be attributes

Kannaiyan Over a year ago

Let me modify the answer. You can have only primary key without a range key.

Jeremy Fisher Over a year ago

Yes I tried that but that causes a mismatch between the number of attribtues in KeySchema and the number in AttributeSchema. I was able to resolve my problem by creating the table in console.aws.amazon.com/dynamodb and using the put_item method

Kannaiyan Over a year ago

You don't need to define attribute definitions other than the primary key. Rest of them dynamo will accept as it is. No schema definition needed. You may not be able to add a property with null, empty in their values. Other than that it will take any type.

Abraham · Accepted Answer · 2023-01-17 21:32:27Z

5

AWS explicate that in the documentation:

For a composite primary key (partition key and sort key), you must provide exactly two elements, in this order: The first element must have a KeyType of HASH, and the second element must have a KeyType of RANGE.

They only allow two KeySchema: one KeyType as HASH and another KeyType as RANGE.

{
  "KeySchema": [
    {
      "AttributeName": "ForumName",
      "KeyType": "HASH"
    },
    {
      "AttributeName": "Subject",
      "KeyType": "RANGE"
    }
  ]
}

edited Jan 17, 2023 at 21:32

Abraham

9,9936 gold badges56 silver badges58 bronze badges

answered Jan 17, 2020 at 20:50

Jose Carlos Ramos Carmenates

2,9632 gold badges45 silver badges59 bronze badges

Collectives™ on Stack Overflow

DynamoDB validation exception on lambda

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related