How can I filter AWS DMS tasks by date?
I want to filter my AWS Database Migration Service (AWS DMS) tasks by date. How can I do that?
"I want to filter my AWS Database Migration Service (AWS DMS) tasks by date. How can I do that?ResolutionTo 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:lte – less than or equal to one valueste – less than or equal to one value (lte alias)gte – greater than or equal to one valueeq – equal to one valuenoteq – not equal to one valuebetween – equal to or between two valuesnotbetween – not equal to or between two valuesThe following JSON example filter uses gte and date_of_record >= 2019-01-08.{  "rules": [    {      "rule-type": "selection",      "rule-id": "1",      "rule-name": "1",      "object-locator": {        "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.Related informationUsing table mapping to specify task settingsUsing source filtersFiltering by time and dateFollow"