This topic describes how to add a prefix to the names of the destination tables when you migrate multiple tables to the cloud at a time.

Prerequisites

Required connections are added. For more information, see Add multiple connections at a time.

Procedure

  1. Log on to the DataWorks console. In the left-side navigation pane, click Workspaces. On the Workspaces page, find the target workspace and click Data Integration in the Actions column.
    If you have logged on to a module of DataWorks, click the DataWorks icon in the upper-left corner and choose All Products > Data Integration to go to Data Integration page.
  2. On the Data Integration page, click Sync Tables in the left-side navigation pane.
  3. On the Sync Tables page, click Sync Tables in the upper-right corner. On the page that appears, select the source connections and destination MaxCompute connection.
  4. In the Configure Sync Rules step, click Add Rule, select Change Table Names from the drop-down list, and then enter the regular expression for converting table names.
    In this example, (. +) is used to match all table names, and ods_$1 means to add an ods_ prefix to the table names.
  5. Click Apply Rules. After the rule is run, you can view the converted table names in the Select Tables step.
  6. In the Select Tables step, select the tables to be synchronized and click Commit.