Creating a Data Table (DDL Mode)

Prerequisites

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

Procedure

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

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

3. Click OK.