In Coalesce, the visual representation of a database object (e.g.: table/view) that serves as a building block of your larger data pipeline is called a Node, and each Node is classified into a Node Type.
Each Node is comprised of Node Properties and Options that can be configured according to your requirements, as well as elements where the contents of the Node are defined. For example, the Mapping Grid where column and transformation specifications are defined and the Join Editor where relationships between sourcing Nodes are specified.
Nodes are classified into Node Types. Each Node Type has a specification (aka: definition), a create template, and a run template which will drive the options available to Nodes of this type as well as how the SQL is generated for and how each Node of that type behaves during deployment (DDL; tied to the create template) and refresh (DML; tied to the run template).
Coalesce provides several Node Types out-of-the-box:
- Persistent Stage
However, as a user, you are able to create your own custom Node Types, called User Defined Nodes (UDNs), to extend Coalesce's functionality for larger user cases. For example: Dynamic Table, Dimension with 0 Record, External Table, etc. See the User-defined Nodes (UDNs) section of the Coalesce documentation for more information, including further information on node specifications (definition), create templates, and run templates.
The Coalesce team has a number of custom / User Defined Nodes (UDNs) that they have built for various use cases. The team is currently undertaking a certification review of each of these UDNs and working towards publishing a public repository of available Coalesce-developed UDNs and their certification status. In the interim, if you have a special use case for which you'd like to understand if there is an existing UDN for it, we encourage you to open a Support Request so you can discuss your requirements further with a member of our team and, if relevant, receive the custom Node Types required for your use case.