How to skip partition changes in DMS replication task

To Nha Notes | March 8, 2025, 2:39 p.m.

If partition modifications are frequent, configure DMS to ignore DDL changes:

aws dms modify-replication-task \
    --replication-task-arn <task-arn> \
    --table-mappings file://table-mappings.json

Example table-mappings.json:

{
  "rules": [
    {
      "rule-type": "selection",
      "rule-id": "1",
      "rule-name": "select_table",
      "object-locator": {
        "schema-name": "ebdb",
        "table-name": "analytics_enduseractivitytag"
      },
      "rule-action": "include"
    },
    {
      "rule-type": "transformation",
      "rule-id": "2",
      "rule-name": "ignore_ddl",
      "rule-action": "ignore",
      "rule-target": "table",
      "object-locator": {
        "schema-name": "ebdb",
        "table-name": "analytics_enduseractivitytag"
      },
      "rule-options": "type=ddl"
    }
  ]
}
This prevents DMS from stopping due to partition changes.