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

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

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

We fixed an issue that was causing UI slowdowns in the Coalesce App.