Skip to main content

Manage Apache Doris with NineData Database DevOps

NineData Database DevOps provides data asset management, data queries, SQL execution, data editing, data import and export, SQL approval workflows, SQL standards prechecks, and sensitive data protection for Apache Doris.

Lightweight Deployment Options​

If you are an enterprise developer or a small team, you can deploy NineData Community Edition locally for internal Apache Doris development and testing. The Community Edition supports Docker-based single-command installation and is permanently free. For deployment instructions, see NineData Community Edition.

Before you begin​

  • You have registered a NineData account. If you do not have one, go to the NineData registration page.
  • You have the connection information and account credentials for the Apache Doris instance.

Step 1: Add a Doris data source​

  1. Sign in to the NineData Console.

  2. Click Datasource > Datasource, and then click Create Datasource.

    image-20250312153427168

  3. In the data source type dialog, select Database > Doris.

    image-20250312153456194

  4. On the data source configuration page, enter the Doris connection information.

    image-20250312153626554

  5. Click Create Datasource next to Connection Test to test the connection. If NineData returns Connection Successfully, click Create Datasource to add the data source.

Step 2: Use SQL Console​

  1. Sign in to the NineData Console.

  2. Click DevOps > SQL Console. Click the text box under SQL Console, select the target Doris data source, and then click Query to open SQL Console.

    image-20250312153724905

  3. In SQL Console, run Doris queries and manage data objects as needed.

    image-20250312153906939

Step 3: 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. This section uses result-set export as an example.

  1. In the SQL Console result set, click upload> Create export task.

    image-20250312153938710

  2. NineData generates the export method and the corresponding SQL statement based on the current result set. Configure the remaining parameters, and then click OK.

    image-20250312153956085

  3. Wait until the export task is complete.

Result​

The Doris data source is available in NineData SQL Console, and the selected result set is exported through a Data Export task.

Next steps​

  • Configure SQL development policies and approval processes before allowing production Doris changes.
  • Add sensitive data rules if Doris contains restricted columns.

Other Features​