The application discloses a multi-
source data intelligent integration query method,
system, device, medium and product, relates to the technical field of data
engineering, and comprises the following steps: acquiring a SqlNode query configuration configured through user
visual interaction, and avoiding
data delay and storage redundancy without pre-
synchronizing data to a
centralized database; analyzing the configuration, traversing data table nodes to generate corresponding temporary table nodes; determining temporary table connection conditions based on associated query node configurations, integrating
data source table configuration sets, and uniformly
processing target fields to obtain a target field set, so that the connection conditions can be flexibly adjusted to adapt to business changes and model adjustment costs are reduced; then, a target
SQL statement is spliced and generated; Apache
Calcite query parameters are configured,
SQL is executed, and returned results are processed, multi-source heterogeneous
data integration is realized, data islands are eliminated, and
data query efficiency and reliability are improved.