This article is your one-stop launching point for assistance with Coalesce's reference syntax and using it throughout your data pipeline to reference objects in column transformations, bulk edit columns, define selector queries, etc.
| Ref Functions | Helper Tokens | Selector Queries |
| Generate fully qualified database object names | Provide column or node context to a bulk operation | Search for or include Nodes in your Graph, Subgraphs, and/or Jobs |
|
{{ ref('STG','CUSTOMER') }} = ”myDB”.”mySCHEMA”.”CUSTOMER” |
{{SRC_COL}} = "C_CUSTKEY" |
+{ location: WORK = results in DIM_CUSTOMER + all predecessor and successor objects |
| See Ref Functions documentation | See Mapping Grid documentation | See Selector documentation |