Editing a Node

Overview

The node editor can be opened by double-clicking on any node from the tree sidebar or from within the graph or subgraphs. Inside the node editor, there are three main parts:

Middle Pane: Made up of the Mapping Grid and the Join Tab. These two areas combined define not only the current node structure but what source will be used to populate the current node and the mapping of that data to each column.
Right Pane: Made up of the Config, the Column Editor, and Testing tabs. Each of these tabs provides a different way of modifying the behavior and additional metadata of the node.
Bottom Pane: Made up of the Results Pane and Data tab. This section provides the user with feedback as to exactly what SQL was queried and the ability to preview the data results within the application.

Node Actions

A node has several different execution modes that can be executed on a single node:

Validate SQL

Validate SQL constructs a simply SELECT statement combining transformations and source mapping metadata with the JOIN string defined in the join tab. The SELECT statement is wrapped with EXPLAIN USING TEXT. EXPLAIN compiles the SQL statement, but does not execute it. This removes any complexity of the underlying template and only validates the user inputted transformations and joins.

Create

Create renders and executes all SQL stages of the create template defined in the Node Type definition.

Validate Create

Validate Create renders and validates all SQL stages of the create template defined in the Node Type definition. However, unlike Create each SQL stage is wrapped with EXPLAIN USING TEXT. EXPLAIN compiles the SQL statement, but does not execute it.

Run

Run renders and executes all SQL stages of the run template defined in the Node Type definition.

Validate Run

Validate Run renders and validates all SQL stages of the run template defined in the Node Type definition. However, unlike Run each SQL stage is wrapped with EXPLAIN USING TEXT. EXPLAIN compiles the SQL statement, but does not execute it.