Updates

• Large Git Files: Large files stored in Git are now saved in chunks, making them more reliable to store and retrieve.

• SSO Settings Docs: The SSO settings page now links to the new setup guide.

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.

Bug Fixes

• Counter ID Allocation: Allocating a new counter ID no longer overwrites an existing job, subgraph, or node type.

• Node Type Changes: Deployed nodes are now recreated when their node type changes object kind, so deployments reflect the new type.

• Renamed Upstream Columns: Views are now recreated when a referenced upstream column is renamed, keeping them in sync.

Bug Fixes

• Reference Validation: References to targets that are not workspace nodes are no longer incorrectly flagged.

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.

Bug Fixes

• SSO Migration Banner: The legacy SSO migration banner on the Single Sign-On settings page is now hidden until organization-level SSO onboarding is enabled for the organization.

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.