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

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

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.