Skip to main content

Documentation index: llms.txt. This page is also available as markdown: append .md to this URL or send Accept: text/markdown.

SQL Node Type

A SQL Node Type is a Node Type whose Nodes are authored as SQL. Its Nodes are .sql files, and behavior is configured through SQL annotations in each Node file instead of config item panels. Earlier releases called this Node Type V2, and the app still labels it Node V2 in Build Settings > Node Types; the mapping-grid alternative is a YAML Node Type.

SQL Node Types still use Create Templates for Deploy and Run Templates for Refresh. They support patterns such as ref(), CTEs, and column-level metadata for lineage inside Transform.

Create SQL Node Types from Build Settings > Node Types > Create Node Type > Node V2. Duplicate existing SQL Node Types when you want a variation without starting from scratch.

See Getting Started with SQL Nodes for a full walkthrough.

For the mapping-grid model, formerly Node Type V1, see Node Type.