How can I filter AWS DMS tasks by date?

Last updated: 2019-09-26

How can I filter AWS Database Migration Service (AWS DMS) tasks by date?


To filter AWS DMS tasks by date, use table mappings. When entering your table mappings, the filter-operator parameter can have one of the following values:

  • ste - less than or equal to
  • gte - greater than or equal to
  • eq - equal to
  • between - equal to or between two values

The following JSON example filter uses gte and date_of_record >= 2019-01-08.

  "rules": [
      "rule-type": "selection",
      "rule-id": "1",
      "rule-name": "1",
        "schema-name": "testonly",
        "table-name": "myTable_test"
      "rule-action": "include",
    "filters": [
          "filter-type": "source",
          "column-name": "date_of_record",
    "filter-conditions": [
              "filter-operator": "gte",
    "value": "2019-01-08"

Note: When importing data, AWS DMS uses the date format YYYY-MM-DD and the time format YYYY-MM-DD HH:MM:SS for filtering.

Did this article help you?

Anything we could improve?

Need more help?