Updated on 2025-09-30 GMT+08:00

Overview

Table 1 DLI best practices

Scenario

Best Practice

Description

Security best practices

DLI Security Best Practices

Enhance security configurations of DLI, including permission management, data backup, and data restoration.

Data migration to DLI

Migrate Hive Data to DLI

Migrate MRS Hive data to DLI using CDM's data synchronization function. Other MRS Hadoop component data can also be bidirectionally synchronized with DLI through CDM.

Migrate Kafka Data to DLI

Migrate MRS Kafka data to DLI using CDM's data synchronization function.

Migrate Elasticsearch Data to DLI

Migrate CSS cluster data (of Elasticsearch type) to DLI using CDM's data synchronization function.

Migrate RDS Data to DLI

Migrate RDS data to DLI using CDM's data synchronization function.

Migrate GaussDB(DWS) Data to DLI

Migrate GaussDB(DWS) data to DLI using CDM's data synchronization function.

Lakehouse

Develop DLI Jobs Using LakeFormation Metadata

Develop DLI jobs using LakeFormation metadata.

Data format conversion

Converting Data Format from CSV to Parquet

Convert CSV data to Parquet format using DLI.

Configuring DLI network connectivity

Configure Network Connectivity Between DLI and Data Sources on a Private Network

Configure network connectivity between DLI and data sources on private networks using enhanced datasource connections.

Configure Network Connectivity Between DLI and Data Sources on the Internet

Establish a network connection between DLI and the Internet by setting up SNAT rules and configuring routing information.

Integrating BI tools for data analysis

Configuring DBeaver to Connect to DLI for Data Query and Analysis

Connect DBeaver to DLI and submit SQL queries.

Configuring DBT to Connect to DLI for Data Scheduling and Analysis

Use DBT to submit DLI jobs.

Configuring Grafana to Connect to DLI for Data Query and Analysis

Connect Grafana to DLI.

Configuring Yonghong BI to Connect to DLI for Data Query and Analysis

Connect Yonghong BI to DLI.

Configuring Superset to Connect to DLI for Data Query and Analysis

Connect Superset to DLI.

Configuring Power BI to Connect to DLI for Data Query and Analysis

Connect Power BI to DLI to access and analyze data in DLI.

Configuring FineBI to Connect to DLI for Data Query and Analysis

Connect FineBI to DLI.

Configuring Tableau to Connect to DLI Using Kyuubi for Data Query and Analysis

Connect Tableau to DLI using Kyuubi.

Configuring Beeline to Connect to DLI Using Kyuubi for Data Query and Analysis

Connect Beeline to DLI using Kyuubi.

Data analysis

Analyzing Driving Behavior Data in IoV Scenarios Using DLI

Use DLI to analyze driving behavior data in Internet of Vehicles (IoV) scenarios.

Analyzing E-Commerce BI Reports Using DLI

Use DLI to analyze e-commerce BI reports, based on real user, product, and review data (anonymized) from an online mall.

Analyzing Billing Consumption Data Using DLI

Use DLI to analyze billing data and optimize costs, based on actual consumption data samples from DLI.

Analyzing Real-time E-Commerce Business Data Using DLI

Use DLI Flink to analyze real-time e-commerce business data.