This release includes BigQuery OAuth, Copilot enhancements, Job Scheduler and Deploy updates, and bug fixes across the platform.

Updates

• Auto-Preview Control: You can now control whether Coalesce automatically fetches and displays data in the Data Viewer after a successful Node run. Set the default in Project Settings under the Preview Control tab, or override it for individual Nodes during your session. When disabled, Coalesce skips the preview query to reduce compute costs. Use Load Preview when you want to manually load data. Single-node runs respect your setting; multi-node runs never auto-fetch regardless of settings.

  • 

• Custom Instructions for Copilot: Organization administrators and project administrators can set custom instructions in Project Settings so Copilot generates code matching your team's naming and structural conventions.

• Copilot Node Config and Validation: Copilot now injects top Node configurations into AI context and validates generated configurations for better alignment with your Node definitions.

• OAuth Display of Authenticated User: BigQuery OAuth now displays who is authenticated after connection setup. The authenticated user's email appears next to the Authenticated badge in the onboarding wizard and Workspace and Environment Settings.

• Job Scheduler Test Failures on Deploy: The Deploy screen now shows whether refreshes contain any failed table tests.

• Update Credentials for Saved Jobs: You can now update credentials for the environment and the change will apply to every job.

Packages

Snowflake

• Semantic View Node 1.0.0: Initial release with Semantic View and Semantic Query node types for a business-friendly semantic layer on Snowflake

• Functional Node Types 4.3.1: Simplified Pivot mode addition,`get_clause()` macro changes to support keyword columns, and package tags updated.

• Incremental Loading 2.1.1: Node Type switching support.

• Create or Alter 1.6.0: Node Type Switch support and `get_clause()` macro support for keyword columns.

• Streams and Tasks 2.4.3: Node Type Switch support and package tags.

• Dynamic Tables 2.1.7: Node Type Switch support and package tags.

• Iceberg Tables 3.1.0: Node Type switch support and package tags.

• Base Node Types Advanced Deploy 2.5.0: `get_clause()` macro supports column names with keywords in the join tab for Dim, Pstage, and Fact, and handles single and block comments.

• Base Node Types 1.5.0: `get_clause()` macro supports column names with keywords in the join tab for Dim, Pstage, and Fact, and handles single and block comments.

Bug Fixes

• Nodes with Forward Slash in Name: Fixed an issue where nodes named with a`/` character were not visible in the browser, subgraphs, or jobs.

• Self-Service Password Reset Window: Fixed an issue where people provisioned with "set user password" unchecked were blocked from self-service password reset if they missed the 24-hour window.

• Stage Node Multisource Toggle: Fixed an issue where turning Multisource OFF on a Stage Node did not reset the Insert Strategy from UNION back to Insert. It now resets correctly.

• Refresh Triggered Twice: Fixed an issue where pressing the refresh button in the Workspace once could cause the query to run twice in Snowflake.

• Databricks Authentication: Fixed an issue where Databricks authentication could fail after a while when using Token and U2M.

• Git Merge Cancellation: Fixed an issue where merging specific branches in the Git modal failed with a "Merge from remotes/origin cancelled" error.

This release includes bug fixes and performance improvements.

This release includes performance improvements and stability fixes across the platform.

If you have questions or ongoing issues, you can check status.coalesce.io for updates or reach out to our support team.

This release includes performance improvements and stability fixes across the platform.

If you have questions or ongoing issues, you can check status.coalesce.io for updates or reach out to our support team.

Updates

• Copilot File Upload: Copilot now accepts file uploads and drag and drop. This makes it easier to convert existing SQL.

• Copilot Organization Instructions: Organization administrators can now set instructions for Copilot such as naming conventions and architectural patterns. Configure Copilot in the Organization Settings**.**

• BigQuery Run Error Visibility: BigQuery run errors are now clearly surfaced in the UI. Rows with errors are highlighted with an icon, and a badge at the top displays detailed error information on hover. The modal distinguishes between empty but accessible schemas and inaccessible schemas that return errors, and tables with no rows show a clear placeholder. Specific handling is included for permission denied, invalid or missing storage mappings or schemas, and general errors, making troubleshooting significantly easier and more self-serve.

• Run Page Render Failure Visibility: Failures that occur during the rendering stage of a refresh are now surfaced directly on the Run page, similar to other run failures. Errors collected by the renderer are no longer limited to logs or the Deploy Wizard.

• Workspace Settings Dropdown Icons: Added icons for Copy Objects, Duplicate Settings, and Delete Workspace to make actions easier to recognize at a glance.

• Readable Workspace Creation Dates: Workspace creation dates now use a new format, for example, “August 9, 2024” instead of “8/9/24,” reducing regional ambiguity.

• Run Details Full Step Visibility: Run Details now display queued, running, successful, failed, and skipped stages. For both deploys and refreshes, all Node steps are visible, even before they start, making it easier to track overall progress.

• Redesigned Copilot Composer: The Copilot composer features a refreshed layout with a dedicated input area, separate actions bar, context usage indicator, relocated Allow edits toggle, square buttons with rounded corners, and an auto-resizing textarea for a more natural typing experience.

• Builder Deep Links with Node ID: Builder URLs now include the Node ID at /projects/<project-id>/workspaces/<workspace-id>/build/nodes/<node-id>, enabling reliable deep linking directly to specific Nodes from documentation, tickets, or shared links.

Packages

BigQuery

• Base Node Types - Advanced Deploy 1.0.0: Initial release.

Databricks

• External Data Package 1.0.1: Added support for loading Excel file format.

• Lakeflow Declarative Pipelines (LDP) Node Type 1.1.0: Added support for AVRO, ORC, TEXT, and XML file formats. Advanced file format options are now available across all supported file formats.

Snowflake

• External Data Package 2.1.2: Added support for API key authentication, including a toggle to forcibly add credentials in the request header.

• Incremental Loading 2.1.0: Added data quality support and Test Passed/Failed records node type.

• Base Node Types Advanced Deploy 2.4.0: Added node type switch support, package tags, and node config matrix with business summary in readme. Fixed truncate description in readme.

• Materialized View 2.0.1: Added node type switch support and package tags. Added node type switch details in readme.

• Create or Alter 1.5.0: Added Last Modified Comparison toggle.

• Data Quality 2.2.0: Added node type switch support in Advanced Deploy Templates and package tags. Fixed truncate description in readme.

Bug Fixes

• Authentication Type Dropdown Behavior: Fixed an issue where the Authentication Type dropdown caret in Workspace or Environment Settings under User Credentials did not reliably open. Alignment issues in the tab were also corrected.

• Refresh Results Missing Nodes: SQL Nodes that do not execute SQL, such as views now appear in refresh results, ensuring the results list accurately reflects all participating nodes.

• Storage Mapping on Partial Deployment Failures: When deployments fail partway through, successfully deployed nodes now correctly write their location and mapping to environment metadata. This prevents environments from entering a blocked state and reduces manual intervention.

• Encrypted SSH Key Reliability: Improved the SSH private key experience with clearer input states, real-time validation, encrypted key detection, and required passphrase enforcement. Encrypted keys now work reliably across sessions.

• listRuns API Failure Reasons: The listRuns API now returns runFailureReason, including when detail: true is set, enabling external dashboards and monitoring tools to surface failure reasons without additional per-run API calls.

• Logging Redaction Performance: Optimized the redactSensitiveData logging layer to prevent long delays when processing large error payloads, resulting in more responsive query runs and error handling.

This release includes bug fixes and performance improvements.

This release includes bug fixes and performance improvements.

This release includes bug fixes and performance improvements.

We fixed an issue where the Deploy Page would continuously spin if the user didn’t the correct RBAC permissions.