I want to use source filters in my AWS Database Migration Service (AWS DMS) tasks.
Resolution
To use source filters, complete the following steps:
- Open the AWS DMS console.
- In the navigation pane, under Migrate or replicate, choose Tasks.
- Choose Create task.
- Enter the details for your Task configuration and Settings. By default, the Task settings are Drop tables on target and Limited LOB mode.
- Select Turn on CloudWatch logs.
- In the Table mappings section, choose Wizard.
- Choose Add new selection rule.
- Enter a Schema name and a Schema table name.
- For Action, choose Include.
- Choose Add column filter.
- Enter a Column name.
- Choose a Condition, such as Less than or equal to, and then enter a value.
- Choose Create task.
To modify an existing task, you must first stop the task. Then, you can select the task and choose Modify.
Related information
Using table mapping to specify task settings
Creating a task