Creating a Table Group and Adding Tables to the Group

Notes and Constraints

• A maximum of 10,000 tables can be imported at a time.
• The tables to be imported must come from the same metadata source.
• When a table is imported, the system does not verify how many table groups the table is added to or what verification rules are configured for those groups. You are advised to import a table into a maximum of three table groups with different verification rules.
• When you create a table group for verifying the consistency of data migrated from MaxCompute to DLI, you are advised to configure basic verification rules, such as count, sum, and allsum, for the group. After all the verification rules are met and the data volumes at the source and the target are the same, you can create a table group with the content verification rule to verify the content consistency.

Prerequisites

• You have completed all preparations.
• A source connection has been created.

Creating a Table Group

1. Sign in to the MgC console. In the navigation pane, under Project, select a big data migration project from the drop-down list.
2. In the navigation pane on the left, choose Migrate > Big Data Verification.
3. In the Features area, click Table Management.
4. Under Table Groups, click Create.
5. Configure the parameters listed in Table 1.

   Table 1 Parameters for creating a table group

   Parameter	Description
   Table Group	Enter a name.
   Metadata Source	Select the created source connection. CAUTION: A table group can only contain tables coming from the same metadata source.
   Verification Rule	Select the method for verifying data consistency and the inconsistency tolerance. MgC provides multiple verification rules for you to choose. For details about these rules, click View More.
   Description (Optional)	Enter a description to identify the table group.

6. Click Confirm. The table group is created. In the table group list, you can view information about the created table group.

   After the table group is created, you can add tables to the table group by referring to Adding Tables to a Table Group.

Adding Tables to a Table Group

1. On the Table Management page, click the Tables tab.
2. Choose Table Management > Import above the list.
3. Select a metadata connection and the table groups that tables are added to.
4. Click Download to download the import template to the local PC. Open the import template and fill in the information of the tables to be added.
   

   • A maximum of 10,000 tables can be imported at a time.
   • Tables in a table group must come from the same metadata source.
   • Cells in the template must not contain formulas and must be in text format. Otherwise, the table parsing will fail.
   • If a Delta Lake (with metadata) or Hudi (with metadata) connection is selected for Metadata Connection, the source_path parameter in the template is mandatory.
   • If a Delta Lake (without metadata) or Hudi (without metadata) connection is selected for Metadata Connection, the source_path and target_path parameters in the template are mandatory.

5. Go back to the console and click Select File to upload the populated template to MgC.
6. Click Confirm. Then you can view the tables in the table list.

Exporting Data Tables

You can export information about tables from Delta Lake (with metadata) and Hudi (with metadata) to CSV files. Information about data tables from sources without metadata cannot be exported.

1. On the Table Management page, click the Tables tab.
2. Choose Export > Export Data Table above the list.

   

3. Select the table groups that contain the data tables to be exported and click Confirm.
4. After the export is complete, choose Export > Manage Exports.
5. Click Download in the Operation column to download the data table information to the local PC.