The invention discloses a
data transmission method and device based on
SQL query and a storage medium, and relates to the technical field of
data processing.The method comprises the steps that configuration parameters input by a user in a visual configuration page are received; a configuration file in a
YAML format is generated based on the configuration parameters, the configuration file comprises
data source connection parameters, structured
query language (
SQL) query statements, a target transmission mode, target transmission mode configuration corresponding to the target transmission mode and a triggering mode, and the target transmission mode comprises mail transmission, RESTful transmission or
Webhook transmission; establishing a connection with a
target database according to the
data source connection parameter, executing the
SQL query statement, and obtaining query data from the
target database; according to the target transmission mode and the target transmission mode configuration, the query data is sent to the target receiving end through the target transmission mode, the technical problem that in existing
data transmission, different transmission targets need to be independently configured, so that operation steps are tedious is solved, and the configuration efficiency of
data transmission is improved.