Using the SQL Node in DQ+

When you use a SQL Node, you can combine the functionality of what would be multiple DQ+ Nodes (such as Select and Group By) into a single node using the actual SQL language.

First, you need to name a schema. Because this node is in DQ+, you need to set the schema so SQL knows where to access its data. The schema name can be anything you want; in this example, it's named "schema_name".

When you open up the editor for the SQL Query, you'll need to make sure to reference the schema name when selecting fields. Note how we also need to select from the Schema Name itself because that schema contains the fields from the node that's being used as input.

SELECT schema_name.Action1ID, count(schema_name.actionCount) as countA
FROM schema_name
GROUP BY Action1ID