'Update Target Endpoint Using AWS DMS For Ongoing Replication

I have created a migration task using AWS DMS. The source endpoint is Amazon Aurora database table and the target endpoint is DynamoDB table. The type of migration task is Full load, ongoing replication.

It works as expected for inserts and deletes e.g. inserting or deleting records in Aurora is replicated in real-time on DynamoDB table.

Updates doesn't work as expected. Updating a record in Aurora DB table doesn't update table in DynamoDB. The error is :

Not retriable error: <ValidationException> Invalid UpdateExpression: Two document paths overlap with each other; must remove or rewrite one of these paths

Mapping JSON rules are as below:

{
    "rules": [
       
        {
            "rule-type": "transformation",
            "rule-id": "817788260",
            "rule-name": "817788260",
            "rule-target": "column",
            "object-locator": {
                "schema-name": "source",
                "table-name": "sourcetable",
                "column-name": "col1"
            },
            "rule-action": "remove-column",
            "value": null,
            "old-value": null
        },
        {
            "rule-type": "selection",
            "rule-id": "1",
            "rule-name": "1",
            "object-locator": {
                "schema-name": "source",
                "table-name": "sourcetable"
            },
            "rule-action": "include",
            "filters": []
        }
    ]
}

Please let me know where to provide the UpdateExpression and what I am missing.

Thanks for your time and help.

aws-dms

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source

'Update Target Endpoint Using AWS DMS For Ongoing Replication

Sources

Related Questions