| Ref functions | Generate fully qualified database object names. | Snowflake: "myDB"."mySCHEMA"."CUSTOMER". Databricks or BigQuery: `myDB`.`mySCHEMA`.`CUSTOMER` | Ref Functions |
| Helper Tokens | Provide column or node context to a bulk operation. | Snowflake: "C_CUSTKEY". Databricks or BigQuery: `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 |