Creating a Data Table (DDL Mode)

Updated on 2022-02-22 GMT+08:00

View PDF

You can create permanent and temporary data tables in DDL mode. After creating a data table, you can use it for job and script development.

The following types of data tables can be created:

A corresponding cloud service has been enabled and a database has been created in the cloud service. For example, before creating a DLI table, DLI has been enabled and a database has been created in DLI.
A data connection that matches the data table type has been created in Data Development. For details, see Creating a Data Connection.

Perform the following steps:
1. In the navigation tree of the Data Development console, choose Data Development > Develop Script/Data Development > Develop Job.
2. In the menu on the left, click , right-click tables, and choose Create Data Table from the shortcut menu.

Click DDL-based Table Creation, configure parameters described in Table 1, and enter SQL statements in the editor in the lower part.

**Table 1** Data table parameters
Parameter	Description
Data Connection Type	Type of data connection to which the data table belongs. DLI DWS HIVE
Data Connection	Data connection to which the data table belongs.
Database	Database to which the data table belongs.