Creating a dynamodb table using Lambda function (python) - error

Question

I have defined 3 attributes in that table definition. agentId, agentName, agentRole. I want to create KeySchema on agentId (partitionkey) , agentRole (range key).

In my understanding the table can have 10 attributes. All those 10 attributes don't have to be part of the KeySchema. Because Keyschema is used to identify unique records. Right?

It throws the following error:

Response

 {

     "errorMessage": "An error occurred (ValidationException) when calling the 
     CreateTable operation: One or more parameter values were invalid: Number of attributes in 
     KeySchema does not exactly match number of attributes defined in AttributeDefinitions",

    "errorType": "ClientError",

    "requestId": "d8d07c59-f36c-4989-9ac2-6ada9d8f6521",

    "stackTrace": [

               "  File \"/var/task/lambda_function.py\", line 8, in lambda_handler\n    
               response = client.create_table(\n",

              "  File \"/var/runtime/botocore/client.py\", line 391, in _api_call\n    return 
              self._make_api_call(operation_name, kwargs)\n",

              "  File \"/var/runtime/botocore/client.py\", line 719, in _make_api_call\n    
      raise error_class(parsed_response, operation_name)\n"

   ]

 }

    import json
    import boto3
    client = boto3.client("dynamodb")
    def lambda_handler(event, context):  

             response = client.create_table(

                  AttributeDefinitions=[
                 {
                      'AttributeName': 'agentId',
                      'AttributeType': 'N'
                 },
                 {
                      'AttributeName': 'agentRole',
                      'AttributeType': 'S'
                 }, 
                 {
                      'AttributeName': 'agentName',
                      'AttributeType': 'S'    
                 }

                ],

                TableName='CallCenterCallsTable,
                KeySchema=[
                {
                      'AttributeName': 'agentId',
                      'KeyType': 'HASH'                 

                },                
               {

                      'AttributeName': 'agentRole',
                      'KeyType': 'RANGE'

               }

             ],

              BillingMode='PROVISIONED',
              ProvisionedThroughput={
                  'ReadCapacityUnits': 1,
                  'WriteCapacityUnits': 1

              }
          )  

         print(response)

Mark B · Accepted Answer · 2022-07-01 19:59:06Z

2

Remove agentName from the Attribute definitions.

See the documentation for Attribute Definitions:

Represents an attribute for describing the key schema for the table and indexes.

You aren't using agentName in the key schema or indexes, so it shouldn't be included in the table definition. DynamoDB is schemaless. You only need to define the hash key and sort key at creation time. DynamoDB doesn't care about any other attributes you may want to insert into your table.

answered Jul 1, 2022 at 19:59

Mark B

203k27 gold badges339 silver badges332 bronze badges

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

1 Comment

Jason Over a year ago

Greatly appreciate Your response. Thank you

Collectives™ on Stack Overflow

Creating a dynamodb table using Lambda function (python) - error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related