Wildcards in table mapping - Amazon Database Migration Service
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

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. Amazon DMS selects tables in the schema named ROOT, where each table has a name with TEST_T as its prefix.