Create a manual table

更新时间:
复制 MD 格式

Create a manual table on the Dataphin analysis platform.

Procedure

  1. In the top navigation bar of the Dataphin homepage, choose Analyze > manual table.

  2. In the manual table list, click the image..png icon to open the Create manual table dialog box.

  3. In the Create manual table dialog box, configure the following parameters.

    Parameter

    Description

    Table name

    The name must contain only letters, digits, and underscores (_) and be no longer than 128 characters.

    Directory

    Select the directory to store the manual table.

    If a directory does not exist, you can create a new folder as follows:

    1. Above the manual table list on the left, click the image icon to open the Create Folder dialog box.

    2. In the Create Folder dialog box, enter a Name for the folder and select a parent Directory as needed.

    3. Click OK.

    Destination project

    The project in which to create the manual table. Select a Basic or Prod project within the current tenant for which you have table creation permissions.

    Schema

    Create the table schema in one of the following ways:

    • DDL import: Create the table schema using a DDL statement.

    • Import from table: Import the schema from an existing table for which your account has read permissions.

    • Manually add: Create the schema by entering the field name, data type, and description for each field.

    Lifecycle

    Specifies the lifecycle of the manual table. Supported values are 7, 14, 30, and 360 days.

    Important

    The lifecycle can be configured only when the compute engine is MaxCompute.

    Description

    A brief description of the manual table, up to 128 characters.

    Important

    This action creates the manual table in a Prod or Basic project. Proceed with caution.

  4. After confirming that the configuration is correct, select the I understand and want to continue checkbox.

  5. Click OK to create the manual table.

Next steps

After you create the manual table, you can edit and manage it. For more information, see Create a manual table in the analysis platform.