SQL Input

1. Function Description

The SQL Input operator helps data analysts who are accustomed to using SQL statements to output datasets through SQL, shortening the configuration process.

2. Operation Steps

Drag the SQL Input operator into the canvas, select the node, then click the Edit button. You can introduce functions according to relevant examples, fill in field names, and click the OK button.

Tips: When selecting fields to add to the SQL editor, supports selecting multiple fields at once ("shift" supports continuous multi-selection, "cmd" supports jump multi-selection). In the Field Bar, after clicking the first input field, press the shift key and select another one, which will fill multiple fields into the query box and automatically complete field separators. Same applies to cmd.

SQL statements support referencing time macro parameters, global parameters, and workflow parameters