I want to use transformations in AWS Database Migration Service (AWS DMS) to modify a schema, table, or column.
Short description
To define your transformation rules, use the AWS Command Line Interface (AWS CLI) or API, or use the AWS DMS console.
Resolution
Note: If you receive errors when you run AWS CLI commands, then see Troubleshoot AWS CLI errors. Also, make sure that you're using the most recent AWS CLI version.
Add transformations to a new task
To add transformations to a new task, complete the following steps:
- Open the AWS DMS console.
- In the navigation pane, choose Database migration tasks.
- Choose Create task.
- Enter the details for Task configuration and Task settings.
- Select Turn on CloudWatch logs.
- From the Table mappings section, choose Guided UI. Or, choose JSON editor to enter the mappings in JSON format.
- Expand the Selection rules section, and then choose Add a new selection rule.
- Enter a Schema and Table name.
- Choose Action, and then select either Include or Exclude.
Note: To add multiple rules, choose Add new selection rule. Then, enter the details for your selection rule. You must have at least one selection rule to use transformations.
- Expand the Transformation rules section, and then choose Add a new transformation rule.
- Choose a target.
Note: If you choose Column, then you must enter the Schema, Table, and Column names. If you choose Table, then you must enter the Schema and Table names. If you choose Schema, then you must enter the Schema name.
- Choose Action, and then select an option for the transformation.
- To save the transformation rule, choose Add a new transformation rule.
- Choose Create task.
Add transformations to an existing task
To add transformations to an existing task, complete the following steps:
- Open the AWS DMS console.
- In the navigation pane, choose Database migration tasks.
- Choose the task that you want to add the transformation to.
- Choose Actions, and then choose Modify.
- Under Table mappings, expand Selection rules, and then choose Add new selection rule.
- Expand Transformation rules, choose Add a new transformation rule, and enter the rule details.
- Choose Save.
For more information, see Using table mapping to specify task settings.
Related information
Transformation rules and actions
Specifying table selection and transformations rules from the console