Documentation index: llms.txt. This page is also available as markdown: append .md to this URL or send Accept: text/markdown.
Coalesce Fundamentals
These guides introduce fundamental concepts you need to understand in order to use Coalesce effectively.
Directed Acyclic Graph (DAG)
Master directed acyclic graphs (DAGs) in Coalesce for building efficient data transformation pipelines. Understand DAG principles, node relationships, execution order, and best practices for creating scalable data processing workflows with proper dependency management.
Nodes and Node Types
Comprehensive guide to Coalesce nodes and node types including Source, Stage, Persistent Stage, Fact, Dimension, and View nodes. Master the building blocks of data transformation pipelines with detailed explanations of node specifications, templates, and custom node creation.
Graphs and Subgraphs
Organize and visualize your Coalesce data transformation pipeline using graphs and subgraphs. Learn DAG organization techniques, subgraph creation for logical separation, and best practices for managing complex data pipeline architectures.
Projects
Organize your data transformation work with Coalesce projects as the foundational structure for collaborative development. Learn project creation, Git repository integration, workspace management, and enterprise-scale data pipeline organization strategies.
Workspaces
Master Coalesce workspaces as sandbox environments for data transformation development, testing, and validation. Learn workspace creation, management, Git integration, storage configuration, and collaborative development workflows for enterprise data projects.
Storage Locations and Storage Mappings
Understand Coalesce storage locations and storage mappings for effective data organization and physical database management. Learn logical vs physical storage concepts, environment-specific mapping strategies, and best practices for enterprise data warehouse architecture.
Environments
Configure Coalesce environments for deploying data transformation pipelines across development, QA, and production systems. Master environment setup, deployment strategies, storage configuration, and enterprise-grade data pipeline management workflows.
Understanding Deploy, Refresh, and Jobs in Coalesce
Master Coalesce deploy and refresh concepts for effective data pipeline management. Understand DDL vs DML operations, job creation, scheduling strategies, and best practices for enterprise data transformation deployment and execution workflows.
When To Use Copy Objects, Duplicate, or Create New Project
Learn when to use Copy Objects, Duplicate Workspace, or Create New Project in Coalesce for optimal data transformation project management. Compare migration options, understand object transfer capabilities, and choose the right approach for your development workflow.
Identity and Surrogate Keys in Coalesce
Learn how Coalesce implements surrogate keys using identity columns in Snowflake, Databricks, and BigQuery. Understand identity column behavior, surrogate key generation for Dimension and Fact Nodes, and alternative strategies including sequences and hash-based keys. Essential guide for implementing system-generated identifiers and maintaining referential integrity in data warehouse architectures.
Understanding View Nodes in Coalesce
Learn how View Nodes work in Coalesce, including when they're created during deployment, how they behave during refresh jobs, configuration options like Distinct and Override Create SQL, and the differences between View Nodes and Stage Nodes materialized as views.