Skip to main content

What is Transform?

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​

New to Coalesce? Start via your cloud marketplace/partner connect or request a trial to explore Transform hands-on.

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 (e.g., 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 to centralize docs and surface trust signals where analysts work.