SQL - Data360_DQ+ - Latest

Data360 DQ+ Help

Product type
Software
Portfolio
Verify
Product family
Data360
Product
Data360 DQ+
Version
Latest
Language
English
Product name
Data360 DQ+
Title
Data360 DQ+ Help
Copyright
2024
First publish date
2016
ft:lastEdition
2024-07-09
ft:lastPublication
2024-07-09T15:09:58.774265

The SQL node can be used to apply SQL-based statements to your data set.

  1. 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.

  2. 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.