Create SQL Query Node

You create a SQL Query node to write a SQL query.

Follow these steps to create a Create SQL Query node:

  1. If it is not already open, open the Components window using View > Components. Select Workflow Editor.

  2. Create zero or more data provider nodes, such as Data Source nodes or transform nodes.

  3. Create zero or more model provider nodes, such as model build nodes or Model nodes.

  4. In the Workflow Editor, expand Data, and click Create SQL Query.

  5. Click; move the mouse to the workflow; click again. The SQL Query node is added to the workflow.

  6. Right-click the data provider and or model provider nodes. For each node, select Connect from the context menu.

  7. Draw a line to the SQL Query node; click again. Be sure to connect all required nodes.

  8. Open SQL Query Node Editor by double-clicking the SQL Query node or right-clicking the SQL Query node and selecting Edit from the context node.

  9. Write the SQL query and validate it or preview it. Click OK when you are done.