Help Center/ Migration Center/ User Guide/ Big Data Verification/ Creating a Table Group and Adding Tables to the Group
Updated on 2024-11-01 GMT+08:00
View PDF
Share

Creating a Table Group and Adding Tables to the Group

Group source tables before verifying their consistency.

  • 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.

Prerequisites

Creating a Table Group

  1. Sign in to the MgC console.
  2. In the navigation pane on the left, choose Migrate > Big Data Verification. Select the created migration project in the upper left corner of the page.
  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 metadata 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.
Parent topic: Big Data Verification