Skip to main content

The Node Editor

The Node Editor can be opened by double-clicking on any node from the sidebar, from within the graph or subgraphs.

The Node Editor
  1. The Mapping Grid and Join Tab is where you'll be able to transform, edit, and parse your data. 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. Some of the things you can do include:
    1. General transformations
    2. Bulk Data Editing
    3. Testing
    4. JSON and XML transformations
  2. Config
    1. Node Properties - Review and edit your nodes Storage Location, Type, and other information.
    2. Options - The options available will depend on the node type. To see potential options, review [Node Config Options] .
  3. Column Editor - Select a column to add transforms. You can select multiple columns to bulk edit the data.
  4. Testing- Test your node to assess the data quality.
  5. Results and Data Pane - 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. They are in the Results and Data Pane.

Validate SQL

Validate SQL constructs a simple 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.

Add Columns

Inherit from Nodes

  • Select a node from the Node Graph or sidebar. Right-click on a node, then select Add Nodes, then the type of node you would like to create.
  • You can select multiple nodes in the Node Graph or sidebar. Right-click on a node, then select Join Nodes, then the type of node you would like to create.
Mapping grid with multiple nodes selected

Manually Add Columns

  1. Drag in one or many nodes from sidebar Node Mapping View.
  2. Drag in individual columns from sidebar column preview pane.
Drag and drop columns

Renaming a Node

When you rename a node in Coalesce, it results in the creation of a new table in Snowflake. Since renaming tables directly in Snowflake isn't possible with Coalesce, the old table will need to be deleted.