| Ref functions | Generate fully qualified database object names. | { ref('STG','CUSTOMER') }} = ”myDB”.”mySCHEMA”.”CUSTOMER” | Ref Functions |
| Helper Tokens | Provide column or node context to a bulk operation. | {{SRC_COL}} = "C_CUSTKEY" | Helper Tokens |
| Selector Queries | Search for or include Nodes in your Graph, Subgraphs, and/or Jobs. | +{ location: WORK name: DIM_CUSTOMER }+} = results in DIM_CUSTOMER + all predecessor and successor objects | Search Your Node Data |
| Macros | Create reusable code in your project. | {%- macro even_odd(column) -%} CASE WHEN MOD({{ column }}, 2) = 0 THEN 'EVEN' ELSE 'ODD' END {%- endmacro %} | Macros |
| Jinja | Use Jinja with Macros and helper tokens. | {{hello_goodbye('{{SRC}}')}} | Using Jinja with SQL |