Skip to main content

Manage Apache Doris with NineData Database DevOps in One Stop

NineData Database DevOps offers powerful features such as data asset management, data querying, SQL execution, data editing, data import and export, SQL approval workflow, SQL standard pre-inspection, approval process, and sensitive data protection, helping users quickly complete data management tasks for Apache Doris.

Prerequisites​

You have registered an account on the NineData platform. If not registered, please visit the NineData Registration Page.

Step One: Add Doris Data Source​

  1. Log in to the NineData Console, click on in the left navigation bar, and then click on on the page.

    image-20250106143410509

  2. In the data source type pop-up window, select > Doris.

    image-20250106143540121

  3. On the data source configuration page, complete the configuration according to the following image.

    image-20250106152030551

  4. Click on next to to test whether the data source can be accessed normally. If prompted with , you can click on to complete the addition of the data source.

Step Two: Use SQL Console​

  1. Log in to the NineData Console, click on in the left navigation bar. Click on the text box under , and available data sources will pop up. Click on the target data source and then click on to jump to the SQL Console.

    image-20250106162807152

  2. After opening the SQL Console, you can perform data management operations on the data source. As shown in the following image:

    image-20250106163209620

Step Three: Export Doris Data​

NineData supports exporting data from Doris to SQL, CSV, and EXCEL files. You can export directly from the result set after querying in the SQL Console, or you can manually create a Data Export task to export data. This section takes exporting from the result set as an example to introduce the operation method.

  1. In the result set of the SQL Console, click on upload>.

    image-20250106170532245

  2. The system automatically generates the export method and the corresponding SQL statement based on the current result set. After configuring other parameters on the page, click on .

    image-20250106171158340

  3. After the task process is completed, you can successfully export Doris data.

Other Features​