📄️ Coalesce Syntax
Learn when to use each type of Coalesce Syntax
📄️ Macros
Macros are functions that take in arguments and return a string. These strings can then be used in node templates, transformations and join strings to produce strings consistently throughout your project.
📄️ Coalesce Internal Macros
In addition to custom macros that can be defined by the user, there are several Internal macros in Coalesce you can use or edit.
📄️ Ref Functions
These are used to generate database object names specific to the current environment and to establish relationships in the DAG for orchestrating node execution.
📄️ Selector Queries
Coalesce supports searching and filtering for Nodes through the Graph, Node Grid, and Column Grid view, and Jobs, which can be helpful when searching for specific ones in a large DAG.
📄️ Helper Tokens
Use helper tokens when creating Macros or writing transformations.
📄️ Cron Reference
Cron expressions are a way to schedule tasks automatically. You can run scripts, commands, or software at specific times. Coalesce uses Cron for Scheduled Jobs.
🗃️ Common Transformations
8 items
🗃️ Using Jinja with SQL
2 items