📄️ Coalesce Syntax
Comprehensive Coalesce syntax reference covering ref functions, helper tokens, selector queries, macros, and Jinja integration. Essential guide for learning Coalesce's powerful data transformation language and building efficient data pipelines.
📄️ Macros
Build reusable Coalesce macros with Jinja syntax for consistent data transformation code across projects. Learn macro definition, usage in node templates, build settings, and execution order for scalable data pipeline development and team collaboration.
📄️ Coalesce Internal Macros
Learn Coalesce internal macros including get_source_transform(), stage(), hash(), ref(), and test_stage() functions. Customize built-in macro functionality for advanced data transformation workflows, node SQL execution stages, and column attribute filtering in your Coalesce data pipelines.
📄️ Ref Functions
Learn Coalesce ref functions including ref(), ref_link(), ref_no_link(), and this for dynamic database object naming and DAG relationship management. Essential for environment-agnostic data pipeline development and node dependency orchestration.
📄️ Selector Queries
Learn Coalesce selector queries for filtering and searching nodes across graphs, subgraphs, and jobs. Discover advanced search syntax with attributes like name, nodeID, location, nodeType, and operators for efficient data pipeline node management and DAG navigation.
📄️ Helper Tokens
Leverage Coalesce helper tokens including SRC, SRC_COL, SRC_NODE, TGT, TGT_COL, and TGT_NODE for dynamic column and node referencing in macros and transformations. Simplify data transformation code with automatic source and target resolution.
📄️ Cron Reference
Complete Coalesce cron expression guide for scheduling automated data pipeline jobs. Learn cron syntax with seconds, minutes, hours, day/month/week fields, special characters, and troubleshooting tips for reliable data transformation scheduling in Coalesce environments.
🗃️ Common Transformations
8 items
🗃️ Using Jinja with SQL
2 items