External Data Sources¶
After you configure an external database or service in Integrations > External Data Sources, you can select the connection in supported data source query entry points, query business records, metrics, or documents, and use the results for analysis and chart display.
Choose an Access Method¶
| Access Method | Suitable Scenarios | Configuration Location |
|---|---|---|
| QueryHub | Use built-in query capabilities to read external data, manually write native queries or DQL Like expressions | Configure the connection in the console, test it, and confirm that it takes effect |
| DataFlux Func | Reuse existing Func connectors, or use scripts to process data, call third-party APIs, and organize custom chart results | Select an integrated Func in the console; connectors and scripts are managed by Func |
The two methods share the External Data Sources entry, but connection configuration, data source ID, and execution method each follow their own rules. Existing Func data sources are not automatically migrated when QueryHub is added.
Users who already use the dedicated TiDB Cloud Lake integration should continue to refer to Connect to and Query TiDB Cloud Lake.
Configure¶
- QueryHub: Start with Overview and Configuration, then fill in the connection information according to the corresponding type in Data Source Configuration and Query Examples.
- DataFlux Func: Add a connection according to Connect and Configure; if script processing is required, see Custom Query Functions.
Query and Display¶
After configuration, select the corresponding connection in Data Source Query in Metrics Analysis or charts. The Workspace, instance, and data scope accessed by the query should be consistent with your current permissions.
- For QueryHub entry points and steps, see Query in Metrics Analysis and Query in Dashboard Charts. First click Add Data Source, select a connection and query method, then enter the query and view the results.
- Func custom functions need to organize results according to chart requirements. See the data formats for Line Chart, Pie Chart, Table Chart, and Topology Chart.
- For chart entry points, see Chart Query.
Manage Data Sources¶
In the list under Integrations > External Data Sources, you can view the type, name, ID, associated information, and status according to permissions, and edit or delete connections.
After you modify the address, authentication information, or query scope, revalidate the connection and query. Before deletion, confirm the reference relationships of existing charts and scripts; after a connection is deleted, related queries may no longer be executable.