Skip to main content

Custom Node Types

Coalesce comes with built-in Node types and Packages for data transformations, you can also create your own custom Nodes using YAML, Jinja 2, and SQL.

To make your own Node Type, go to Build Settings>Node Types and select New Node Type to start from scratch or Duplicate on any Node Type to extend existing functionality.

Learn About the Components of a Node

Before building a Node, review our guides on each part of a Node and how they work together.

A Node consists of these components:

  1. Node Definition - Written in YAML, specifies UI elements and configurations like node color, materialization options, and business keys.
  2. Create Template - Defines the table's structure (DDL).
  3. Run Template - Defines how the table will be populated with data (DML).
  4. Hydrated Metadata - An object that contains all the structured information needed to define a Node in Coalesce.
  5. Macros - A block of code you can define once to use multiple times. They can be used in the Create or Run template.
Shows the dimension's column definitions with properties like ID fields, data types, and nullable flags on the left, while displaying node-level configuration options including materialization settings on the right under the Node Definition tab.

What's Next