To DLI¶
If the destination link of a job is the Link to DLI, configure the destination job parameters based on Table 1.
Parameter | Description | Example Value |
|---|---|---|
Resource Queue | Resource queue to which the destination table belongs The default queue of DLI cannot be used for migration jobs. You need to create a SQL queue in DLI. | cdm |
Database Name | Name of the database to which data will be written | dli |
Table Name | Name of the table to which data will be written | car_detail |
Clear Data Before Import | Whether to clear data in the destination table before data import If this parameter is set to Yes, data in the destination table will be cleared before the task is started. | No |
Data Clearing Mode | This parameter is available when Clear Data Before Import is set to Yes. TRUNCATE: deletes standard data. INSERT_OVERWRITE: overwrites existing data with inserted data. | TRUNCATE |
Partition | This parameter is available when Clear Data Before Import is set to Yes. When you enter partitions, data in these partitions will be cleared. | year=2020,location=sun |