Exporting Data from DLI to OBS

Updated on 2022-12-07 GMT+08:00

View PDF

You can export data from a DLI table to OBS. During the export, a folder is created in OBS or the content in the existing folder is overwritten.

The exported file can be in JSON format, and the text format can only be UTF-8.
Only the data in the DLI table (the table type is Managed) can be exported to the OBS bucket, and the export path must be specified to the folder level.
Data can be exported across accounts. That is, after account B authorizes account A, account A can export data to the OBS path of account B if account A has the permission to read the metadata and permission information about the OBS bucket of account B and read and write the path.

In the displayed Export Data dialog box, specify parameters by referring to Table 1.

**Table 1** Parameter description
Parameter	Description
Databases	Database where the current table is located.
Table Name	Name of the current table.
Data Format	Format of the file storing data to be exported. Formats other than JSON will be supported in later versions.
Queue	Select a queue.
Compression Format	Compression format of the data to be exported. The following compression formats are supported: none bzip2 deflate gzip
Storage Path	Enter or select an OBS path. The export path must be a folder that does not exist in the OBS bucket. Specifically, you need to create a folder in the target OBS directory. The folder name cannot contain the special characters of *\/:? "<>\|**, and cannot start or end with a dot (.).
Export Mode	Storage mode of the data to be exported. New OBS directory: If the specified export directory exists, an error is reported and the export operation cannot be performed. Existing OBS directory (Overwritten): If you create a file in the specified directory, the existing file will be overwritten.
Table Header: No/Yes	Whether the data to be exported contains the table header.

Click OK.
(Optional) You can view the job status (indicated by Status), statements (indicated by Statement), and other information about exporting jobs on the SQL Jobs page.
1. Select EXPORT from the Job Type drop-down list box and specify the time range for exporting data. The jobs meeting the requirements are displayed in the job list.
2. Click to view details about an exporting job.