> For the complete documentation index, see [llms.txt](/llms.txt). This page is also available as markdown at this URL or via `Accept: text/markdown`.

<!-- coalesce-llms-txt-directive -->

Coalesce Transform is the metadata-driven workspace to design, build, and operate governed data pipelines on your cloud data platform. It combines a visual DAG with code, reusable templates, built-in testing and standards, column-level lineage, and instant change propagation so data teams ship reliable data products faster with less maintenance.

## Transform Overview



* **Ship faster with standards**: Use reusable templates and patterns to keep teams aligned while automating repetitive SQL work.
* **Govern as you build**: Enforce naming, contracts, tests, and approvals in the same place you transform—no bolt-ons.
* **See and trust lineage**: Column-level lineage and automatic propagation make impact analysis and updates instant.
* **Work across clouds**: A consistent Coalesce experience across your environments on leading cloud data platforms.
* **Scale without the drag**: Git-native workflows, APIs/CLI, and jobs built for thousands of tables and frequent change.
* **AI where it helps**: Generate SQL, refactor code, auto-document nodes/columns, and summarize changes/commits.

## Get Started

* **Quick Start Guides** - Build your first pipeline in minutes on [Snowflake](https://docs.coalesce.io/docs/guides/snowflake-quickstart?step=1) or [Databricks](https://docs.coalesce.io/docs/guides/databricks-quickstart?step=1).
* **[Build with AI in Transform](docs/coalesce-ai/)** - Turn on assistants for SQL, documentation, and change summaries.
* **[Connect Catalog](https://docs.castordoc.com/)** - Centralize documentation and expose trust signals to the business.

**New to Coalesce?** Start a free Coalesce trial from our [Snowflake Marketplace listing](https://app.snowflake.com/marketplace/listing/GZSTZ1868F5RH/coalesce-coalesce), or **[request a trial](https://coalesce.io/start-free/)** to explore Transform on other cloud platforms.

## **What’s Included**

### **Transformation Workbench**

Design data pipelines in a visual graph and code-based experience.

### **Standards, Templates & Patterns**

Apply metadata-driven templates (naming, conventions, macros) and ready-made node patterns so work is consistent across teams and domains.

### **Testing, Contracts & Approvals**

Define tests and data contracts inside the transformation flow. Surface approvals and policy checks before changes ship, so reliability goes out with every deploy.

### **Change Management & Propagation**

Detect upstream changes, propagate updates across dependent nodes, and run impact analysis at the column level—keeping docs and pipelines in sync by design.

### **Change Management & Impact Analysis**

Explore dynamic column-level lineage directly from your graph to understand dependencies, breakages, and blast radius before you change anything.

### **Environments & Storage Mappings**

Separate logical design from physical deployment. Use storage mappings per environment (`dev/test/prod`) to promote with confidence.

### **Jobs & Orchestration**

Schedule and monitor jobs (deploy, refresh, build) and integrate with external orchestrators as needed.

### **AI Assistants (In Transform)**

Use AI to generate or refactor SQL, draft node/column descriptions, and summarize changes/commit messages to reduce busywork and keep documentation fresh.

### **API & CLI**

Automate runs, query metadata, and wire Coalesce into CI/CD with a REST API and CLI.

### **Marketplace & Packages**

Jump-start projects with pre-built node types and solutions (for example, Dynamic Tables, platform base node types, accelerators).

## **Key Concepts in Transform**

* **Projects & Workspaces** - Organize work, connect Git, and manage access.
* **Graphs & Nodes** - Model data products with node types (Source, Stage, Dimension, Fact, View, Custom).
* **Policies & Templates** - Enforce standards with reusable patterns and metadata-driven rules.
* **Storage Mappings** - Bind logical nodes to physical schemas per environment.
* **Deploy, Refresh & Jobs** - Operate pipelines with predictable, auditable runs.

:::tip

Looking for documentation and discovery? Connect to **[Coalesce Catalog](https://docs.castordoc.com/)** to centralize docs and surface trust signals where analysts work.

:::