Wildcards in table mapping - AWS Database Migration Service
Services or capabilities described in AWS documentation might vary by Region. To see the differences applicable to the AWS European Sovereign Cloud Region, see the AWS European Sovereign Cloud User Guide.

Wildcards in table mapping

This section describes wildcards you can use when specifying the schema and table names for table mapping.

Wildcard Matches
% Zero or more characters
_ A single character
[_] A literal underscore character
[ab] A set of characters. For example, [ab] matches either 'a' or 'b'.
[a-d] A range of characters. For example,[a-d] matches either 'a', 'b', 'c', or 'd'.

For Oracle source and target endpoints, you can use the escapeCharacter extra connection attribute to specify an escape character. An escape character allows you to use a specified wildcard character in expressions as if it was not wild. For example, escapeCharacter=# allows you to use '#' to make a wildcard character act as an ordinary character in an expression as in the this sample code.

{
    "rules": [
        {
            "rule-type": "selection",
            "rule-id": "542485267",
            "rule-name": "542485267",
            "object-locator": { "schema-name": "ROOT", "table-name": "TEST#_T%" },
            "rule-action": "include",
            "filters": []
        }
    ]
}

Here, the '#' escape character makes the '_' wildcard character act as a normal character. AWS DMS selects tables in the schema named ROOT, where each table has a name with TEST_T as its prefix.