Updates

• Dark Mode: Choose a light, dark or system theme preference in the app. Found in user settings → preferences.

• CLI Browser Login: Sign in to Coalesce from the CLI with a single browser login using coa auth login.

• Scheduler Warehouses: Set a Snowflake warehouse per job schedule.

• BigQuery Billing Project: Run BigQuery OAuth query jobs in a billing project you choose.

• CLI Requirements: The CLI now requires Node 22.13 or later.

Bug Fixes

• Fabric Deploys: Deploys no longer fail when a column's data type changes.

• Databricks Mode Checking: More complex mode formats are now handled.

• Node Type Files: Files are no longer rewritten when only line endings differ.

• Git Worktrees: coa serve and Desktop no longer crash on startup in linked git worktrees.

• Annotation Groups: Same-name annotation groups open and close independently.

Updates

• Fix with Copilot: Build tab errors now offer a Fix with Copilot action.

• Node Type Tags: YAML/SQL tags show when adding nodes; removed from graph cards.

• Docs Column Lineage: Column lineage computes once per page open and skips unrelated downstream columns, so Docs loads faster.

• Job Memory: COA jobs use less memory.

• Duplicate Column Warnings: V2 SQL nodes warn on duplicate columns; SQL nodes report repeated annotations.

• Mapping Grid: Every open mapping grid accepts column viewer drags.

• Users Table: Shows primary user status.

• Git Performance: Large Git files are stored in chunks so browser clones succeed.

• Copilot Model: Transform Gemini moves to 3.5 Flash.

Bug Fixes

• Snowflake Columns: Added nullable columns now apply DEFAULT.

Updates

• Node Type Annotations: Annotations now support nested collapsible groups and can show more than one example.

• Annotation Validation: Near-miss annotation names are suggested, and malformed declarations are skipped instead of causing errors.

• SQL Node Editor: Refreshed colours, and errors now appear as soon as a node is displayed.

• Single Sign-On: Cleaner SSO settings layout, restarting SSO setup uses a fresh Auth0 link, and existing enterprise connections can be enabled for Transform orgs.

• coa Version Warning: coa now warns when it is behind the app version.

• coa describe: Documentation now covers Cloud Operations and SQL/YAML node terminology.

• Nodes Tree: The Nodes tree uses a virtualized tree for better performance.

Bug Fixes

• Deployments: Deployed nodes are recreated when a node type changes object kind, and views are recreated when an upstream column is renamed.

• ID Allocation: Existing jobs, subgraphs, and node types are never overwritten when allocating IDs.

• Validation: Targets that are not workspace nodes are no longer flagged as ref_no_link.

• Databricks: The path is now carried from request credentials.

Updates

• Node ID Location: The node ID now lives in Node Properties instead of the node editor header.

• Hide Lineage Toggles: The Builder node graph has per-node toggles to hide lineage.

• Copilot SQL Nodes: Copilot understands annotation vs. config mode for SQL nodes and refers to SQL and YAML nodes by those names.

• Graph Layout: The graph view is upgraded to yFiles 3.1.

• Subgraph Filters: Subgraph include/exclude filters are kept when you click in the DAG.

• COA Execution Monitor: A new monitor shows COA execution progress.

• CLI Node Versions: The CLI accepts any Node version from 20 up.

• Larger Repos: Desktop handles larger repos with a new storage backend.

• Desktop Certificates: Desktop COA processes trust the OS certificate store.

Bug Fixes

• Node Type Switching: Empty dropdown values are kept when switching node type.

• Run SQL Search: Ctrl+F no longer opens in the hidden editor while the run SQL modal is open.

• View Recreates: Recreating a view at the same address no longer plans a drop.

• Desktop Node Types: Node type IDs resolve from definition.yml, not the folder name.

Updates

• Package Node Type Settings: Package node type settings now stay in sync between disk and the desktop app.

Bug Fixes

• Watch Mode Snapshots: Changes to jobs, macros, and subgraphs are now picked up correctly while watching a project.

• Local Mode First Plan: Environment files are now written in local mode, so a locally created project's first plan can resolve storage mappings.
  Bug Fixes

• Stability Fix: Rolled back a recent third-party library upgrade (Firebase) to restore previous, stable behavior in the app.

Updates

• Coalesce Desktop App is GA! Head over to our setup guide to get it.

• Desktop Linux Preview: The Coalesce desktop application is now packaged for Linux distributions with AppImage and native Debian/Ubuntu (.deb) packages, including auto-updates.

• Virtual Tree in Source Browser: The Add Source modal now uses a high-performance virtual tree, smoothly scrolling through storage mappings with tens of thousands of objects.

• Marketplace Packages Discovery: Added coa packages list to inspect available marketplace packages and their latest public versions from the CLI.

Bug Fixes

• Snowflake Encrypted Keys in Desktop: Fixed an issue where password-encrypted private keys failed to decrypt in the desktop application runtime.

• SQL Parser Error Handling: Prevented repeating crash loops in the Builder when editing complex statements containing unresolved SQL expressions.

Packages

Snowflake

• Base Node Types - SQL 2.1.0: Adds a SQL-first Dimension node type that builds SCD Type 1 or Type 2 dimensions with upsert, changeTracking, or lastModified merge strategies and built-in data quality tests. Also includes 2.0.1, where accepted and rejected values tests accept lists, and 2.0.0, which added a Work node type that declares its annotations in its spec.

• Base Node Types - SQL Advanced 1.0.0: New package. Adds a Work Advanced Deploy node type for SQL Nodes that can alter, recreate, or drop tables, transient tables, and views on redeploy.

• Streams and Tasks 2.8.1: Restores the Task DAG Custom-SQL node type. Also includes 2.8.0, which updated stage labels and added primary key support.

• Dynamic Tables 2.1.9: Fixes deploys that add column comments or make several changes to a dynamic table at once.

BigQuery

• BigQuery Base Node Types - SQL 1.0.0: New package. A SQL-first Work node type for BigQuery with inline annotations and automatic metadata extraction.

Databricks

• Databricks Base Node Types - SQL 1.0.0: New package. A SQL-first Work node type for Databricks with inline annotations and automatic metadata extraction.

Updates

• Node Type Terminology: Node types are now labeled YAML and SQL across the app and coa CLI to match documentation.

• Enterprise SSO Configuration: Org admins can now configure Auth0-hosted enterprise single sign-on connections directly from Settings.

• Snowflake OAuth for Local Workspaces: The local coa CLI and Desktop application now supports browser-based Snowflake OAuth sign-in.

• Local Workspace Names: Locally served workspaces now display their directory name in the canvas header and show the active profile in the footer.

• Jobs Tree Virtualization: The Jobs sidebar tree now uses a high-performance virtual tree with inline renaming.

Bug Fixes

• Graph Re-layout Loop: Resolved an issue where large workspaces entered an endless re-layout loop in the browser graph, and restored the layout loading indicator.

• Multi-line Annotations: Line breaks in node type annotation descriptions are now preserved in the Annotations tab.

• Warehouse Quoting: Auto-generated column transforms now use the target warehouse's native identifier quoting style, such as BigQuery backticks and Fabric brackets.

Updates

• Node Test Results: Node tests now record failing-row counts for Snowflake, Databricks, and BigQuery, surfaced in run results and the CLI.

• Snowflake OAuth in CLI: coa now supports browser-based OAuth authentication for Snowflake profiles via coa auth warehouse login.

• Node Recreation Logging: Plan logs now provide clear diagnostic reasons when a node must be dropped and recreated.

• Scheduled Job Warnings: Deleting a job that powers an active scheduled run now displays a warning to prevent broken schedules.

• Local Credentials: Workspace profile management now includes local user credentials directly in the web UI.

• Windows Installer Signing: Windows CLI and desktop installers are now digitally signed via Azure Trusted Signing.

Bug Fixes

• Snowflake OAuth Redirect: Resolved an issue where Snowflake OAuth authentication failed to redirect properly during sign-in.

• Join Tab Autocomplete: Fixed column autocomplete suggestions failing to populate on the join configuration tab.

• Hash Column Popover: Corrected column source mapping in the hash column display popover.

• Run Details Sanitization: Fixed environment ID parameter sanitization when loading run details.

Updates

• Source Node Mapping Column Sort and Filter: On Source Nodes, you can sort Mapping tab columns alphabetically or by data type, and filter by column name. This makes wide Source tables easier to navigate.

• Column-Level Node Type Config Items: V2 Node Types can add toggles, dropdowns, text boxes, and tables as per-column options, not only node-wide settings. Each column keeps its own value in SQL annotations and Node metadata.

• Circular Dependency Problem Scanner: The problem scanner warns when your graph has a circular dependency, so you can catch cycles before plan or run surfaces a cycle-detected error.

• BigQuery Local COA CLI: The local `coa` CLI supports BigQuery Service Account profiles for doctor, init, validate, create, and run paths that were previously Snowflake-only.

• Node Type Name on Node API: Node API responses include `nodeTypeName` so callers get a friendly Node Type display name for custom and package types without changing the existing `nodeType` field.

• View Plan for Deploy Runs: Anyone authorized to view a deploy run can open View Plan for that run's executed plan. Plan access is no longer limited to the user who created the plan.

Packages

Snowflake

• Create or Alter package 1.6.3: Removes the Treat NULL as Current Timestamp toggle from Create or Alter Dimension, Fact, and Persistent Nodes. When Last Modified is enabled, a validation stage stops execution if NULL values exist in the selected timestamp column.

• Cortex 4.2.0: Renames AI_EXTRACT to Cortex File Processor, adds `AI_PARSE_DOCUMENT` and `AI_TRANSCRIBE` support on Cortex File Processor, and migrates legacy `SNOWFLAKE.CORTEX` functions to AISQL `AI_*` functions on the LLM Node.

Bug Fixes

• Column-Valued Annotation Serialization: Column selectors in V2 annotations such as `@orderbycolumn` and `@lastModifiedColumn` write the column name instead of `[object Object]`, so committed SQL and redeploy comparisons stay correct.

• Hidden Config Options When Parent Toggle Is Off: When a parent config toggle is off, dependent config options are hidden and their annotations are stripped from the SQL Editor so you only see settings that apply.

• Add a Column With Sorted Grid: After you sort the column grid, Add a Column focuses the newly created column instead of the last sorted row.

• Subgraph Double-Click in Scrollable List: Double-clicking a subgraph in a scrollable Subgraphs list opens the subgraph you selected, including when the Node column panel is open.

• Corrupt Metadata Errors in Column Editor: When corrupt column metadata blocks a transform save, the Column Editor shows an error instead of failing silently with no feedback.

• Run Preview Hotkey During In-Flight Runs: Pressing Ctrl+Enter or Cmd+Enter while a Node run is already in progress no longer throws an unhandled "Nodes are already running" error.

• Bulk Source Column Remap With Missing Columns: Bulk remap source columns returns a clear error when the source step has no columns, instead of crashing.