The SQL node can be used to apply SQL-based statements to your data set.
-
Specify a Schema Name for each node that enters the SQL node by clicking the Edit icon in the Input Mapping table. This allows you to treat incoming nodes like tables, to which you can apply SQL statements.
- On the Outputs tab, specify which fields you want to work with. You can work with existing input fields, or add new fields. Click Add Field, then add Input Fields or create a New Field.
SQL Script Editing
Once you have created Schemas, Input Fields, and New Fields, you will have an outline of the components you can work with within your SQL script.
To create a new script, click the Edit SQL button. Type your SQL queries into the SQL Editor dialog.
You will need to use the schema names that you defined in step one to refer to different input sources as if they were tables. For example:
SELECT * FROM schema_A
Tip: Type CTRL+SPACE for a full list of SQL keywords and functions. Typing CTRL+SPACE after you have already typed letters can also function as autocomplete.
Note: Avoid putting a semicolon (;) at the end of statements, it is not required.