SQL Nodes
1. Overview
SQL nodes can perform basic data development through SQL statements. When users need to process data in databases, such as create, update, delete, read, and summarize operations, they can also be implemented through SQL nodes.
2. Node Configuration
-
Data source: Configure data source account
-
SQL statement: Use SQL statements to obtain data from external databases, process data, and insert synchronized data
- SQL statements support using time macro parameters/global parameters/workflow parameters
- Pre/post SQL: Support data preparation/cleanup operations based on the main SQL statement
- SQL statements support using time macro parameters/global parameters/workflow parameters
3. Running Options
-
Running flag
- Prohibit execution: After the workflow runs to this node, it will directly skip execution, commonly used for temporary data problem troubleshooting, partial task running control and other scenarios.
- Normal: Run the node according to the existing scheduling strategy, the default running flag for nodes.
