Updates

• 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.

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.

Bug Fixes

• Snowflake OAuth via PrivateLink: Snowflake OAuth connections configured with USE_PRIVATELINK_FOR_AUTHORIZATION_ENDPOINT now authenticate successfully without issuer mismatch errors.

• Snowflake OAuth: Fixed an issue where Snowflake OAuth reconnection failed with an issuer mismatch for accounts with uppercase identifiers.

Updates

• SQL (V2) Nodes on BigQuery: BigQuery workspaces now support SQL (V2) Nodes and version selection.

• SQL (V2) Annotations: Built-in annotations (@id, @nodeType, @materializationType) are validated in the editor.

• Desktop Parameters: Local workspaces support runtime parameters in workspace.yml.

• Desktop Drag & Drop: Column creation and drag-and-drop column support in local dev mode.

• Branch Validation: Workspace creation surfaces branch validation errors in an inline drawer.

• Deploy Polling: Schedule polling pauses when tabs are hidden to reduce background requests.

• Plan Recreate Logging: Execution plans log changed properties when dropping and recreating nodes.

• Release Pipeline: Streamlined staging build and deployment workflows.

Bug Fixes

• Node Duplication: Duplicated nodes remap column dropdown and tabular config references correctly.

• SQL (V2) Node Fallback: Missing node types on SQL (V2) nodes show an inline banner instead of crashing.

• Snowflake OAuth: Resolved iss mismatch errors during OAuth authorization callbacks.

• Subdomain Feature Flags: Backend flag evaluations include customer subdomains so targeting rules match browser evaluations.

• Auth0 Login Routing: Auth0 requests explicitly route to username/password auth to avoid unexpected IdP redirects.

• Cross-Org User Creation: Clarified errors when inviting users across orgs with differing Auth0 configurations.

Updates

• SQL (V2) Node Annotations: SQL (V2) Node Types now declare supported annotations directly in their spec, with an Annotations tab in the editor for easy discovery and copyable snippets.

• Desktop App: A preview version of the Coalesce Desktop application is now available, which supports automatic background updates and customizable update preferences.

• Local Project Association & Project ID: Workspaces now track Project ID in data.yml, and coa init associates projects with cloud workspaces by default. A one-time Git diff adding this value is expected and safe to commit.

• Column Metadata: Column descriptions, default values, and nullability constraints now hydrate directly into column definitions.

• Job Schedules: Paused schedule indicators are now displayed directly within job details.

• New Login Experience: New login experience is being rolled out in phases starting with this release.

Bug Fixes

• Deploy Dashboard Polling: Schedule polling on the Deploy dashboard pauses when the browser tab is hidden and refreshes at a lower frequency to prevent unnecessary server load.

• V2 SQL Nodes SELECT DISTINCT Mapping: Correctly records SELECT DISTINCT clauses on node source mappings during SQL parsing.

• Subgraph Selection Freezes: Selecting nodes on large subgraph canvases executes in a single dispatch pass, removing multi-second UI freezes.

• Monaco Editor Command Palette: Restored Command Palette (F1 / context menu) and line navigation across all Monaco SQL editors.

• Subgraph Performance: Resolved performance bottlenecks and rendering lag across large subgraphs.

• Editor Command Menu: Restored the context command menu in the SQL editor.

• Graph Error Handling: Fixed an issue where unhandled error objects caused crashes in graph and grid views.

• Login Redirects: Resolved navigation issues when accessing the login page directly.

• Plan Summary: Fixed mislabeled summary metrics during plan generation.

Bug Fixes

• Auth0 Login Redirection: Navigating directly to the /login route in Auth0-enabled organizations now cleanly redirects to Auth0 hosted sign-in while preserving invitation and deep-link parameters.

• Problem Scanner False Positives: Resolved false-positive circular dependency warnings in the Problem Scanner and Builder UI for valid query patterns (such as delta loads referencing target tables).

Bug Fixes

• Copilot Long Responses: Copilot on Opus now uses its full 128K output limit, so large Node creation no longer gets cut off mid-response.

• Copilot Tool Cards: Tool cards resolve when a response ends instead of spinning forever, and truncated responses are called out in chat.

• Copilot Conversation Recovery: A failed tool call no longer breaks the rest of the conversation, and a failed Node creation cleans up after itself instead of leaving an empty Node behind.

• Databricks OAuth on Azure: OAuth M2M connections to commercial Azure Databricks workspaces authenticate correctly. (Shipped in 7.39.3.)