Node

A Node in Coalesce is the visual representation of database objects such as tables and views that form the building blocks of your data pipeline. Nodes are classified by Node Type.

Each Node is comprised of Node Properties and Options that you can configure according to your requirements, as well as elements where you define Node contents. For example, the Mapping View defines column and transformation specifications, and the Join Editor specifies relationships between sourcing Nodes.

Nodes are classified into Node Types. Each Node Type has a specification or definition, a create template, and a run template. Those templates drive the options available to Nodes of that type and how SQL is generated. They also control how each Node behaves during deployment, tied to the create template and DDL, and during refresh, tied to the run template and DML.

Node types control the creation and data manipulation of all database objects within your data pipeline. Node types are defined by Jinja/SQL templates and a YAML Node definition with numerous customization options in the Node Type Editor.