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.

📄️ What Is a Surrogate Key?

Some description