adding new column in dynamo DB using boto3 resource with update_item

Question

I need to update a row in Dynomodb while doing so need to include a new column which is already not there.

resp = table.update_item(
            Key={
                'Pkey': 'key1',
                'Skey': 'skwy2'
            },
            UpdateExpression='ADD dateModified = :input2, SET IsActive = :input1',
            ExpressionAttributeValues={
                ':input1': False,
                ':input2' :  datetime.datetime.now(timezone.utc)
            },
            ReturnValues="UPDATED_NEW"
        )

now I need to update IsActive field to false and insert new dateModified value to that .

getting error as Invalid UpdateExpression: Syntax error; token: "=", near: "dateModified = :input2"

peter · Accepted Answer · 2021-07-16 08:35:08Z

1

you can see in https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Expressions.UpdateExpressions.html#Expressions.UpdateExpressions.ADD that for the ADD operation you don't use =

so the correct expression should be ADD dateModified :input2 SET IsActive = :input1

answered Jul 16, 2021 at 8:35

peter

15.3k12 gold badges64 silver badges100 bronze badges

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

Collectives™ on Stack Overflow

adding new column in dynamo DB using boto3 resource with update_item

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related