table-selector.md

title	summary	aliases
Table Selector of TiDB Data Migration	Learn about Table Selector used by the table routing, binlog event filtering, and column mapping rule of Data Migration.	/docs/tidb-data-migration/dev/table-selector/

Table Selector of TiDB Data Migration

Table selector provides a match rule based on wildcard characters for schema/table. To match a specified table, configure schema-pattern/table-pattern.

Wildcard character

Table selector uses the following two wildcard characters in schema-pattern/table-pattern:

• The asterisk character (*, also called "star")

  • * matches zero or more characters. For example, doc* matches doc and document but not dodo.
  • * can only be placed at the end of the word. For example, doc* is supported, while do*c is not supported.

• The question mark (?)

  ? matches exactly one character except the empty character.

Match rules

• schema-pattern cannot be empty.
• table-pattern can be empty. When you configure it as empty, only schema is matched according to schema-pattern.
• When table-pattern is not empty, the schema is matched according to schema-pattern and table is matched according to table-pattern. Only when both schema and table are successfully matched, you can get the match result.

Usage examples

• Matching all schemas and tables that have a schema_ prefix in the schema name:

  schema-pattern: "schema_*"
  table-pattern: ""

• Matching all tables that have a schema_ prefix in the schema name and a table_ prefix in the table name:

  schema-pattern = "schema_*"
  table-pattern = "table_*"