V2 Node Types: SQL-First Authoring
You can now build transformations by writing SQL directly in Coalesce. Node Type V2 lets you paste existing queries, author CTE-heavy logic, or drop in AI-generated SQL and get everything Coalesce offers in return: automatic column extraction, full DAG and column-level lineage, template-driven deployment, and governance. Configuration moves into the file itself via inline annotations like @insertStrategy("MERGE") or @isBusinessKey, keeping your transformation and its metadata in one place. V2 nodes work alongside your existing V1 nodes in the same pipeline, so you can migrate at your own pace, one node type at a time.
Learn more about V2 Node Types.
COA CLI: Local-First Pipeline Development
You can now build and run Coalesce pipelines entirely from your terminal. The COA CLI brings local-first development to Coalesce, letting you author .sql transformation nodes in your editor of choice, run them directly against your warehouse, and deploy to your environment without touching the UI. Install it via npm, point it at your warehouse credentials, and you have the full pipeline workflow at your fingertips: coa create generates your DDL, coa run populates your tables, and coa plan and coa deploy push changes to your Coalesce environment. COA works with your existing Git workflow and supports the same V2 SQL nodes, node types, and ref() dependency graph you already know. Whether you prefer coding locally, integrating with CI/CD, or just want faster iteration cycles, the COA CLI is how you bring that workflow to Coalesce.
Get coa version 7.33.
Read the documentation.
Updates
Packages
BigQuery
BigQuery Base Node Types 1.1.0: Added a Last Modified Comparison option to MERGE logic for Persistent Stage, Dimension, and Fact Nodes; UUID visibility moved into the Node definition for column visibility; package tags for marketplace visibility; documentation updates including a config matrix.
Databricks
Databricks Base Node Types 1.1.0: Zero-key Dimension support, a last-modified toggle on Dimension, Persistent Stage, and Fact, soft delete and hard delete on Dimension, documentation updates, and an updated get_clause() macro.
Snowflake
Streams and Tasks 2.6.1: Replaces ALLOW_OVERLAPPING_EXECUTION with OVERLAP_POLICY, small UI fixes, and Git documentation updates with impact analysis for task-enabled Node types.
Iceberg Tables 3.2.1: Error and success notification integrations, execute as user, suspend after failures, task auto-retry, overlapping task runs, expanded task configuration and schedule fields, serverless warehouse size limits for tasks, and related documentation for Iceberg external tables.
Functional Node Types 4.3.2: Node Type switch support and documentation updates.
Deferred Merge 2.0.3: Task notification integrations, execute as user, suspend after failures, auto-retry, overlapping runs, richer schedule and configuration fields, serverless task size bounds, and schedule unit expansion.
Create or Alter package 1.6.1: Same task-focused improvements as Deferred Merge 2.0.3 for supported Node types.
Cortex 4.0.0: Replaces deprecated !PREDICT with AI_EXTRACT, renames Document AI to AI EXTRACT, and updates configuration to match the new function.
Bug Fixes
Databricks Token Authentication: Databricks token authentication now shows clearer errors to help with troubleshooting.
setNode With Duplicate Table Names: setNode now resolves the correct table when two tables share a name but live in different storage locations.
Presync Errors: Presync deploy errors show clearer messaging to help with troubleshooting.
Workspace Wizard and Git Permissions: When Git credentials lack permission, the Workspace creation wizard keeps your entries and shows a specific error instead of a generic failure.
Re-sync Columns and Descriptions: Re-syncing columns now picks up description changes from your data platform so your Node metadata stays current.
Run Details Sorting: Sorting ascending or descending in run details works when some values are missing instead of mis-ordering rows.
