🗃️ The Build Interface
4 items
📄️ Organizing Your DAG
Learn best practices for organizing and managing complex Directed Acyclic Graphs (DAGs) in Coalesce. Master the use of graphs, subgraphs, and filters to improve data pipeline visibility, maintainability, and scalability. Create efficient, well-structured data transformation workflows that enhance team collaboration and project management.
📄️ Understanding Node Run Order in Coalesce
Learn how node execution order works in Coalesce by understanding dependencies, adjusting node relationships, and using tools like custom node types, macros, and marketplace packages to control data pipeline flow and ensure reliable transformations.
🗃️ Custom Node Types
8 items
📄️ Multi Source Nodes
Master Coalesce's Multi Source nodes for combining multiple data sources using SQL UNION operations. Learn how to implement INSERT, UNION, and UNION ALL strategies to consolidate data from multiple tables into a single target. Discover load order management, multi-source configuration, and step-by-step examples for creating efficient data consolidation pipelines with proper source mapping and transformation handling.
📄️ How To Refresh Node Data
Learn how to refresh and synchronize data sources and nodes in Coalesce to keep your data pipelines current. Discover how to refresh SQL pipeline sources, re-sync columns when schema changes occur, and fetch updated data records. Essential guide for maintaining data freshness and handling schema evolution in your data transformation workflows with proper source synchronization techniques.
📄️ Bulk Editing
Master Coalesce's bulk column editing capabilities for efficient data pipeline development. Learn how to simultaneously modify multiple columns using the Column Grid view and Node Editor, including bulk transformations, data type changes, source mappings, and helper token usage. Streamline your data modeling workflow with powerful bulk editing features for SQL transforms, Jinja templating, and column attribute management.
📄️ Parsers
Leverage Coalesce's powerful JSON and XML parsing capabilities for semi-structured data transformation. Learn how to automatically generate columns and joins from variant data types, configure parser sample sizes, implement data type mappings, and use bulk derive mappings operations. Transform complex nested data structures into relational formats efficiently.
📄️ Pre-SQL and Post-SQL
Discover how to leverage Pre‑SQL and Post‑SQL boxes in Coalesce to enhance your workflows. This guide explains how to create process logs, back up and audit supplier data, and run multiple SQL statements seamlessly—all while using able references like `ref_no_link` to ensure proper environment mapping without unnecessary dependencies.
📄️ Node Aliases
Learn how to implement custom node aliases in Coalesce for cleaner, more readable SQL transformations. Discover how to assign shorter aliases to source tables, update transform fields efficiently using bulk edit operations, and apply SQL functions with proper alias references. Simplify complex multi-table joins and improve SQL readability in your data transformation pipelines.
📄️ Create and Manage Nodes Using the API
Learn how to create and manage Coalesce Nodes programmatically using the REST API. This technical guide covers API endpoints for creating Workspace Nodes, updating Node configurations, and managing Node Types including Stage, View, Dimension, and Fact Nodes. Includes practical curl examples, authentication requirements, and step-by-step instructions for automating your data transformation workflows in Coalesce.
🗃️ Data Quality Testing
2 items
📄️ Column Lineage and Propagation
Explore Coalesce's comprehensive column lineage and propagation capabilities for complete data transformation traceability. Learn how to visualize column-level dependencies across your entire data pipeline, track data flow transformations, and efficiently propagate column changes throughout connected nodes. Master impact analysis and change management with powerful lineage visualization and automated propagation features.
📄️ Advanced Node Functionality
Learn advanced Coalesce node functionality including warehouse override capabilities for optimized compute resource management. Discover how to configure different warehouses for specific nodes within your data transformation DAGs, enabling performance optimization with larger compute resources and cost tracking through department-specific warehouses. This guide covers implementation using custom node templates and UDF configurations.
📄️ Column Transforms
Complete guide to column transformations in Coalesce for advanced data manipulation and processing. Learn how to implement SQL transformations, leverage macros for reusable logic, handle source column behavior, and follow best practices for data type matching. Covers platform-specific formatting for Snowflake and Databricks, transformation field usage, and alias management.
📄️ Reordering Columns in Coalesce
Some description
🗃️ Learn How to Build Your Pipeline
10 items