Create a manual table
This topic explains how to create a manual table using the Dataphin analytics platform.
Procedure
On the Dataphin home page, select Analytics > Manual Table from the top menu bar.
In the manual table list on the right, click the
icon to open the Create Manual Table dialog box.In the Create Manual Table dialog box, configure the following parameters.
Parameter
Description
Table Name
The name of the input table. Only numbers, letters, and underscores (_) are allowed, with a maximum of 128 characters.
Directory Location
Select the directory where the node is stored. If no directory is created, you can follow the operation guide below to enter a name and select the directory location to create one.
Select the directory where the Notebook is stored.
If no directory is created, you can Create Folder, as follows:
Click the
icon above the Notebook list on the left side of the page to open the Create Folder dialog box.In the Create Folder dialog box, enter the folder Name and Select Directory location as needed.
Click Confirm.
Target Project
The target project where the created manual table is located. You can select Basic and Prod projects with table creation permissions under the current Tenant.
Field Structure
Three methods are supported to create the field structure of a manual table:
DDL Import: Create the field structure of a manual table through DDL statements.
Import from Table: Import from a table with read permissions in the current account.
Manual Addition: Create the field structure by entering field names, data types, and descriptions.
Lifecycle
Configure the lifecycle of the manual table, supporting 7, 14, 30, or 360 days.
ImportantThe lifecycle configuration is only supported by the MaxCompute compute engine.
Description
Enter a brief description of the manual table, within 128 characters.
ImportantThe created manual table will belong to either the Prod project or Basic project. Please proceed with caution.
After ensuring the configuration is correct, select I Am Aware Of This Situation And Confirm .
To complete the creation of the manual table, click Confirm .
What to do next
Once the manual table is created, you can proceed to edit and manage it. For more information, see the referenced document.