Data Query

Definition

This module provides users with convenient, self-service Data Query capabilities. It supports visual SQL writing and execution based on connected data sources, and includes permission control and query result export capabilities.

Module Features

• 💻 Provides a visual SQL editing and query interface, supporting syntax highlighting, quick completion, and other features;
• 🌳 Integrates a data source catalog tree on the left side (table structure view), following a Navicat-style interaction. Clicking a table name or field name can quickly fill it into the input box;
• 📂 Supports querying mainstream relational databases such as MySQL, Oracle, SQL Server, and Dameng;
• 🛢️ Also supports querying big data data sources, including Hive, Phoenix, and Doris;
• 📤 Query results can be exported as Excel/CSV files for offline analysis;

Notes

We recommend that administrators configure query permissions based on job roles to avoid accidental queries or leakage of sensitive data. High-frequency query tasks can be considered for encapsulation as standard query APIs or Data Services.

Scope

For users with data permissions, this module supports quickly writing SQL in the platform to query data from various data sources. It is widely used in data analysis, troubleshooting, data verification, and other scenarios, and is applicable to R&D, governance, management, and other roles.

1. Data Query Page

Click Data Assets under Data Query to open the Data Query page. The page uses a left-right layout: the left side displays data sources, and the right side is used to enter SQL statements for Data Query.

Data Query Page.png

2. Query

Enter the SQL statement on the right side of the page, select the data source on the left side, and click Query to query data.

Query.png

3. Query Results

When the query result is returned successfully, a dialog appears on the page to display the query result.

Query Results.png

4. Export

Click Export, then click OK. The exported file will be downloaded automatically and can be viewed in the browser's download list.

Export.png

5. Clear

When you need to clear the SQL statement that has been written, click Clear to clear the SQL statement.

Clear.png