Updated on 2024-07-18 GMT+08:00

Importing Data to a DLI Table

Importing Data Using OBS

On the DLI management console, you can import data stored in OBS into DLI tables.

To import OBS data to a DLI table, either choose Data Management > Databases and Tables in the navigation pane on the left, locate a desired database, and click Tables in the Operation column, or choose SQL Editor in the navigation pane on the left.

For details, see Importing Data to the Table.

Importing Data Using CDM

Use the Cloud Data Migration (CDM) service to import data from OBS to DLI. You need to create a CDM queue first.

Pay attention to the following configurations:

  • The VPC to which the DLI account belongs is the same as the VPC of the CDM queue.
  • You need to create two links, including a DLI link and an OBS link.
  • The format of the file to be transmitted can be CSV or JSON.

Importing Data Using DIS

Use the Data Ingestion Service (DIS) service to import data to DLI. You need to create a DIS stream.

For details, see Creating a DIS Stream in Data Ingestion Service User Guide.

When configuring the DIS stream, set the Dump Destination to DLI and select the database and table in DLI.