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.

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.

BigQuery in Private Preview

Big Query support in Coalesce Transform is now available in private preview. Reach out to your account team to enable it.

UI Changes

• Project and Workspace ID in URL — URLs now include the Project and Workspace ID, making it easy to share direct links to specific Workspaces. For example /projects/<project-id>/workspaces/<workspace-id>/build

• Redesigned Copilot Chat History — The Copilot chat history now uses a card-style design with improved hover states. History items show "X messages · Xh ago" instead of full timestamps, and the delete button only appears on hover for a cleaner look.

Copilot

• Message Feedback — You can now provide feedback on specific Copilot messages using like and dislike buttons, helping improve AI response quality.

• Improved Abort Functionality — The Copilot abort button now properly stops the UI spinner when you cancel a request. Previously, the spinner continued even after aborting.

Packages

BigQuery

• Base Node Types 1.0.0 is available — Sign up for our private preview by contacting your account manager.

Bug Fixes

• Preserved Thread Titles — Fixed an issue where Copilot thread titles were overwritten when starting a new chat. Existing thread titles are now preserved correctly.

• Runtime Parameter Warning Consistency — Fixed an issue in the Node Type Editor where after correcting invalid runtime parameters and saving, the error popup wouldn't automatically clear until you left and re-entered the editor. The warning now updates correctly when parameters are fixed.

• Copilot Text Overflow — Fixed an issue where text content in Copilot responses overflowed horizontally beyond the shaded content area. Content now displays within proper boundaries.

• Subgraph Tab Handling — Fixed an issue where deleting a Subgraph while its tab was active resulted in a blank white tab. The interface now handles Subgraph deletion gracefully.

• Code Editor Line Numbers — Fixed a CSS conflict where duplicate line numbers would appear.

Navigating complex data pipelines just got easier. We've introduced several enhancements to the Node graph view that help you visualize, filter, and explore your DAGs more efficiently. Whether you're tracking down dependencies or understanding your pipeline's structure, these tools work together to give you better control over how you view and interact with your data transformations.

Mini Map

The Mini Map gives you a bird's-eye view of your entire graph at once. Instead of panning around to understand your DAG's size and structure, you can now see the complete layout in a compact overlay. Click any area on the Mini Map to jump directly to that section of your graph.

The colored Nodes in the Mini Map match the Node types in your main view, making it easy to identify sources and targets as you navigate.

Filter Your DAG

You can now refine your view by dragging Nodes directly from the Node list into the filter. Drag a Node into the Include area to focus on it, or into Exclude to hide it from view. This makes filtering faster and keeps your graph focused on what matters most.

Explore Lineage From Any Direction

You now have more control over how you expand lineage directly from the context menu:

• Upstream: Shows the data sources that flow into your Node.

• Downstream: Reveals where your data goes next.

• Related: Displays both directions at once for a complete picture.

This gives you more control over how much lineage you explore at a time.

Node Expansion

Click the plus icon on any Node to expand its lineage one step at a time. If a plus icon appears, there's another Node connected. If the icon isn't there, you've reached the end of that path. You can expand both upstream and downstream connections this way.

The filter automatically updates to show Custom when you add Nodes individually.

Spotlight Navigation

Spotlight helps you navigate large DAGs 4 Nodes at a time. If you have 12 Nodes, Spotlight expands them in manageable chunks. Click Spotlight again to move forward in the direction you want, 4 Nodes at a time.

Collapsed Nodes by Default

All Nodes are now collapsed by default to use screen space more efficiently. If you want to see all the columns in a Node, expand it.

Storage Location in Graph View

Storage Locations now appear directly in the graph view, making it easier to identify where each Node originates.

Alphabetically Sorted Nodes

When you right-click on a Node and select Add Node, all available Nodes now appear in alphabetical order. This matches the sorting order in the left-hand Node list, making it consistent across the interface.

View Column Lineage From the Column Grid

You can now view the lineage of any column directly from the Column Grid. Right-click on a column and select View Lineage to trace where it originates, how it transforms, and where it's used downstream.

Columns are collapsed by default but can be expanded to show full mappings. You can edit columns directly and use Propagation to apply changes consistently across connected Nodes.

Get a quick tour by watching this video or visiting our documentation.

These features are currently in Private Preview. Please reach out to your Coalesce account manager to sign up.

We've made significant improvements to Node type switching in Coalesce. When changing a Node's type (for example, from View to Dimension), Coalesce now performs a complete metadata reinitialization based on the target type definition. This ensures your Node fully adopts the target type's structure while intelligently preserving your work.

You can also now use the bulk edit to switch Nodes Types across multiple Nodes at once. Each Node displays its own preview, showing the specific metadata changes that will occur for that Node.

Starting with this release (7.28), we're rolling out updates in stages over the course of a week to ensure a smooth deployment for all customers. Your app will automatically receive the update as it becomes available. You don't need to take any action. We'll notify you once the release is live in your app. This staged approach helps us monitor each release and address any issues quickly, ensuring the best experience for everyone going forward.

If you have questions, please contact support.

Coalesce Copilot

Coalesce Copilot is an AI assistant that accelerates data pipeline development through natural language interaction. Instead of manually configuring nodes through the UI, simply describe your requirements in plain English or paste existing SQL—Copilot translates your intent into working DAG nodes with proper transformations, columns, and relationships. This intelligent assistant empowers teams to:

• Build and modify nodes through conversational commands.

• Import existing SQL queries into structured Coalesce pipelines.

• Execute multi-step workflows from high-level requirements.

• Receive guidance on best practices and workspace configurations.

By combining the speed of AI-generated scaffolding with the precision of Coalesce's visual interface, Copilot enables both experienced developers and SQL users to build production-ready data transformations faster than ever before.

Enable Coalesce Copilot in your Organization Settings > Preferences.

UI Changes

• Improved Error Messaging for Timed Out Runs — Run timeout errors now say "Run timed out. Restart the run, and if this issue persists contact support." Run details now show whether you executed the run using the Coalesce App or Coa CLI in the new "Executed By" field.

• Readable Add Source Popup After Workspace Creation — The popup that appears after creating a Workspace to guide you on adding sources now has improved text contrast. The message is now easy to read against the blue background.

• Test Failure Indicator in Build Interface — When you run a Node with tests and a test fails with "Continue on Failure" enabled, you'll now see a visual indicator. An orange indicator appears on the Node, and a yellow indicator appears on the failed test child Node. This makes it easier to spot test failures without checking run details.

Mapping Grid

• Prevent Accidental Empty Columns — The Mapping Grid no longer creates empty "nameless" columns when you click or tab through the grid. Previously, clicking in the grid could accidentally generate blank column rows without names or data types. You now need to take an explicit action to create new columns, reducing confusion and metadata clutter.

Bug Fixes

• OAuth Token Storage Issue Resolved — Fixed a scenario where OAuth users with Snowflake connections could be blocked due to a secrets storage issue. The system was unconditionally saving Snowflake tokens in V1 format even when the V2 feature flag was enabled, causing payload size limits to be exceeded in Google Secrets Manager when tokens expired and needed to be reset.

• Full Deploy History Access — Fixed an issue where some users with correct Environment Reader permissions could only view 2-4 recent deploys or runs in the Deploy tab. All users with Environment Reader permissions and above can now see the complete deployment history.

• Node Descriptions Support for Databricks — Fixed an issue where adding a Node description to an existing Databricks Node would cause deployment failures. You can now add or update descriptions on Databricks Nodes without deployment errors.

• Duplicate Column Errors — Fixed a scenario where the deployment process could generate ALTER statements to add columns that already existed, causing production deployments to fail. This issue occurred when certain column metadata changes triggered unnecessary ALTER statements.

Databricks

Incremental Nodes Package

• Version 1.0.0 - The Coalesce Incremental load Node is a versatile Node that allows you to develop and deploy a Stage table/View in Databricks where we can perform incremental load in comparison with a persistent table added on top of it.

Test Utility Package

• Version 1.0.0 - This package is inspired by the Great Expectations package for Python.It will allow you to deploy Great Expectations like tests in your data warehouse.

Lakeflow Declarative Pipelines

• Version 1.0.1 - Parquet file type support added.

Snowflake

Cortex Package

• Version 3.0.1 - Added blank option to all optional dropdown selector configurations, improving usability. Test documentation updated.

• Version 3.0.2 - Fixed Document AI stream name handling and added else blocks to prevent Empty SQL errors. Added default blank for Embedding model in Cortex Search Service.

Dynamic Tables Package

• Version 2.1.4 - Added common column dictionary list macro with logic improvements. Added blank options for Refresh and Initialize configurations.

• Version 2.1.5 - Fix for Missing Handler for Incoming Node type transitions (View/Table → Dynamic Table).

• Version 2.1.6 - Adds Advance Warehouse Selection, Immutability Constraint, and Backfill options across Work/Dimension/Latest Record Version. Updates redeploy/ALTER triggers and simplifies materialization-change steps.

Functional Node Types Package

• Version 4.2.0 - Added new Recursive CTE node type for building recursive queries.

• Version 4.2.2 - Added aggregation transformation support for Recursive CTE. Fixed Empty SQL statement errors.

• Version 4.2.3 - Added Populate on deploy section and Pre-SQL/Post-SQL options for View to Date Dimension Node.

• Version 4.3.0 - New Time Dimension Node for time of day analytics.

Streams and Tasks Package

• Version 2.4.2 - Fixed Empty SQL statement issue. Test documentation updated.

Deferred Merge Package

• Version 2.0.1 - Fixed Empty SQL statement issue.

Data Quality Package

• Version 2.0.1 - Fixed Empty SQL statement issue.

• Version 2.1.0 - Expands DMF node config to include Universal DMFs, Custom DMFs, and Alerting Options; adds static-behavior limitation; updates screenshots and versions table.

Base Node Types Advanced Deploy Package

• Version 2.2.0 - Enhanced delete logic for Fact and Dimension nodes with three distinct methods:

  • Hard Delete (permanent removal)

  • Soft Delete (marks records as isSystemCurrentFlag = 0 while retaining history)

  • No Delete (prevents delete operations to maintain existing data flows).

  • Added Primary Key management configuration for seamless altering and dropping of constraints.

  • Added Merge Exclude List for SCD Type 1, allowing specific columns to be excluded from the update phase of MERGE operations.

• Version 2.2.1 - Fixed Empty SQL statement issue.

• Version 2.3.0 - Added Last Modified comparison to Dimension, Persistent stage, and Fact Nodes.

• Version 2.3.1 - Added Last Modified Comparison CDC options (including Last Modified Column, Treat Null as Current timestamp, and Type 2 Dimension note) across Persistent Stage (table/transient), Dimension (table/transient), and Fact (table/transient).

Base Node Types Package

• Version 1.3.7 - Fixed Empty SQL statement issue.

Iceberg Tables Package

• Version 3.0.3 - Added dictionary functionality for macros in Dynamic Iceberg Dimension and Dynamic Iceberg LRV node types. Fixed Empty SQL errors in Snowpipe Iceberg Table and External Iceberg Table.

External Data Package

• Version 2.0.4 - Added case insensitive toggle to CopyInto, Snowpipe, and External Table node types. Modified run templates for Snowpipe, External Table, and InferSchema to fix Empty SQL errors. Modified External Table to not drop temporary file format in infer process.

• Version 2.0.5 - Adds Snowflake Secrets-based credentials for API node (Bearer/Client ID+Secret) with guidance and images. Adds package tags and updates versions table.

• Version 2.1.1 - Add Git Seet Node. Loads data files directly from Git repositories into Snowflake tables. It connects your version-controlled seed files including CSVs, reference tables, lookup data to your Coalesce pipelines without manual file transfers or separate staging infrastructure.

Interactive Table Package

• Version 1.0.0 - Interactive table deliver low-latency query performance for high-concurrency, interactive workloads.

Incremental Loading

• Version 2.0.1 - Added an else block to the RUN template to handle cases where the materializationType is View.

Private Preview

We have begun a phased rollout expected to be complete by December 31, 2025.

Coalesce Copilot

Coalesce Copilot is an AI assistant that accelerates data pipeline development through natural language interaction. Instead of manually configuring nodes through the UI, simply describe your requirements in plain English or paste existing SQL—Copilot translates your intent into working DAG nodes with proper transformations, columns, and relationships. This intelligent assistant empowers teams to:

• Build and modify nodes through conversational commands.

• Import existing SQL queries into structured Coalesce pipelines.

• Execute multi-step workflows from high-level requirements.

• Receive guidance on best practices and workspace configurations.

By combining the speed of AI-generated scaffolding with the precision of Coalesce's visual interface, Copilot enables both experienced developers and SQL users to build production-ready data transformations faster than ever before.

Updates

UI Changes

• Project ID Visible in Settings — You can now see the Project ID directly in the Project Settings modal. This makes it easier to find and reference without checking URLs or using the API.

Onboarding

• Clearer Onboarding Message — When creating a new Workspace, the confirmation message after step 1 now reads "Workspace creation initialized". This more accurately reflects the setup process.

Deployments

• Readable Node Names in Plan Errors — Deployment plan validation errors now show the human-readable Node name instead of just the Node ID. This makes it much faster to find and fix the Node causing the error.

Jobs & Notifications

• Job Notifications Show Test Failures — Job Scheduler notification emails now distinguish between a successful run and a successful run with failed tests. This gives you a clearer status on data quality without having to check the UI.

API

• Set Workspace Node API Database and Schema — The Set Workspace Node API no longer allows database and schema to be set. These fields are derived from your Storage Mappings, and this change prevents them from being accidentally overwritten.

Bug Fixes

• Retry from Failure Uses Environment Parameters — Fixed an issue where using the Retry from Failure button on a job in the UI would not apply the Environment's configured parameters. Retries from the UI now correctly use the same Environment Parameters as a normal job run.

• Expanded Column Selectors Visibility on Smaller Screens — Fixed an issue where expanding column selector options would only take up a small part of the screen, making difficult to see columns. Expanded column selectors now take up the entire area making sure all options are visible.

Packages

External Data Package

• Version 2.0.3 - Added support for conditional STORAGE_INTEGRATION in the Copy Into Node type, offering flexible staging logic.

Base Node Types

• Version 1.3.6 - Resolved an issue with toggles in the Base Node Types UI config that caused inconsistent behavior.

Iceberg Tables

• Version 3.0.1 - Iceberg's Copy Into Node now supports conditional logic for STORAGE_INTEGRATION.

• Version 3.0.2 - All optional dropdown selectors now include a blank option, reducing forced selections and improving usability.

Data Security Package

• Version 1.0.1 - Improved runtime processing reliability of masking view templates to enhance sensitive data protection.

Dear Coalesce Customers,

We're writing to inform you of an important backend migration that will be completed on or after December 1, 2025 to improve the performance and reliability of the Coalesce platform. We are migrating our database infrastructure from Google Firestore to PostgreSQL, which will enhance our platform's scalability and query performance.

What This Means for You

As part of this migration, some automatic updates will be applied to your workspace configurations to ensure compatibility with our new backend infrastructure. On or after December 1, 2025, when you next load your workspaces, you may notice changes to your YAML files in Git that require your attention.

Additionally, this upgrade will require you to upgrade the version of your Coalesce CLI (coa) to version 7.25 or later to continue to performing operations with our product.

CLI Upgrade Requirements

Due to changes in how we store and retrieve data in our product, we had to make breaking changes to our CLI that require all users to upgrade to version 7.25 or later to allow you to continue operating the CLI. Versions 7.24 and earlier will improperly attempt to read and write to API endpoints that will no longer be supported or used.

How to Upgrade Your CLI:

1. Check your current version:
   coa --version

2. Upgrade to version 7.25 or later:
   npm install -g @coalescesoftware/cli@latest

3. Verify the upgrade:
   coa --version

For detailed instructions, see our documentation.

Please upgrade your CLI by December 1, 2025.

Changes Made to Your Workspaces

The following updates will be automatically applied on or after December 1, 2025 to ensure your workspaces function correctly with our new system:

1. Source Node Cleanup

• Empty sources have been removed - Sources without any configuration or data connections have been deleted from your workspace.

• Null database/schema values corrected - Sources with missing database or schema information have been updated with appropriate default values.

2. Node and Column ID Updates

• Subgraph node IDs standardized - Node identifiers within subgraphs have been updated to maintain consistency.

• Hash column IDs normalized - Column identifiers used in hash operations have been refreshed to ensure proper functionality.

3. Node Configuration Standardization

• SQL node materialization types - SQL nodes without a specified materialization type have been assigned appropriate defaults (typically 'table' or 'view').

• Column name length limits enforced - Columns with names exceeding 256 characters have been truncated or renamed following standard naming conventions.

• Deploy enabled defaults - Nodes with undefined deploy_enabled properties have been set to true by default.

• Column nullable properties - All columns now have explicit nullable values set (true/false) rather than undefined states.

4. Job Cleanup

• Invalid jobs removed - Jobs without proper ID or jobCounter properties have been deleted from your workspace configuration.

What You’ll Need To Do After December 1

Immediate Actions Required:

1. Validate Your Workspaces

   • Load each of your Workspaces in Coalesce.

   • Commit any changes triggered by this update to Git via the Git Modal.

   • Verify that all Nodes are functioning as expected.

   • Test critical data pipelines to ensure proper operation.

2. Update Any Hardcoded References

   • If you have any external scripts or references that use the old node IDs or column IDs, these may need to be updated.

   • Review any custom integrations that might reference the modified elements.

Best Practices Moving Forward:

• Column Naming: Ensure column names are under 256 characters.

• Node Configuration: Always specify materialization types for SQL nodes.

• Job Management: Ensure all jobs have proper ID and counter properties.

• Schema Definition: Always specify database and schema values for sources.

Examples of Changes

Here are some examples of the types of changes you might see:

Column Name Length Fix:

# Before (invalid - too long) - name: "this_is_an_extremely_long_column_name_that_exceeds_the_maximum_allowed_length_of_256_characters_and_needs_to_be_truncated_or_renamed_to_comply_with_system_requirements_and_best_practices" 
# After (corrected) - name: "long_column_name_truncated"

Deploy Enabled Standardization:

# Before (undefined) node:   name: my_node   # deploy_enabled property missing
# After (defined)   node:   name: my_node   deploy_enabled: true

Nullable Property Addition:

# Before (missing nullable) columns:   - name: customer_id     dataType: NUMBER
# After (nullable defined) columns:   - name: customer_id     dataType: NUMBER     nullable: false 

Support and Documentation

Getting Help

If you encounter any issues or have questions about these changes:

1. Check the Problem Scanner - Use the built-in Problem Scanner in the Coalesce interface to identify any workspace issues.

2. Contact Support - Reach out to your Customer Success Manager or submit a support ticket.

Support Contact Information:

• Email: support@coalesce.io

Questions or Concerns?

We understand that any change to your development environment can be concerning. Our Engineering and Support teams have thoroughly tested this migration process, and we're confident that these changes will improve your experience with Coalesce.

If you have any questions, concerns, or encounter any issues, please don't hesitate to reach out to us. We're here to ensure a smooth transition.

Additional Resources:

• Coalesce Documentation

• Git Integration Guide

• Coalesce Support

This release focuses on improving deployment reliability, user interface validation, and API consistency.

UI Enhancements

• Bulk Edit Validation Improvements – Added validation and error messaging when bulk editing columns in the column grid to prevent invalid input or missing selections. This ensures users receive clear guidance on required fields and attribute selections.

• Parser Sample Size Limit and Error Messaging – Updated JSON and XML parser settings to limit the sample size and provide more helpful error messages when exceeding recommended limits.

• Run Log Drawer Fix – Adjusted the layout so long Node lists no longer overlap the footer when filters or banners are active in the Run Log view.

API Updates

• Dynamic Table Node Creation – Fixed an issue where creating an empty dynamic table Node via the Create Workspace Node API failed due to incorrect validation. Dynamic table Node types can now be created, updated, and managed through all supported APIs.

• Duplicate Node Validation – Added validation to prevent creating Nodes with duplicate names or storage locations when using the Set Node API.

• Get Workspace Node Enhancements – The Get Workspace Node API now correctly returns database and schema values for mapped Nodes in workspaces, ensuring consistency with the UI.

Deployment and Execution

• Presync Column Query Truncation Fix – Resolved an issue that caused column metadata loss during large schema queries. The fix improves data integrity by correctly handling response size limits.

• Deployment Failure Due to Missing Subgraph IDs – Fixed an issue that caused deployment errors when subgraph or folder IDs were missing in request validation.

• Improved Plan Storage – Refactored Plan handling to no longer await storage completion during API operations, improving plan execution efficiency.

Problem Scanner

• Column Dependency Refresh Fix – The Problem Scanner now updates column dependency errors in real time after changes, without requiring a browser refresh. This improves accuracy and workflow speed when resolving column-level issues.

Packages

Dynamic Tables Package

• Version 2.1.3 - Removed all Iceberg-related code from the Dynamic Tables Package. Dynamic Iceberg table creation is now handled through the new Iceberg Package. This update also includes a minor fix that removes redundant sort order logic.

Iceberg Tables Package

• Version 3.0.0 — Introduced three new Dynamic Iceberg Table Node types to support Iceberg table workflows.

  • Dynamic Iceberg Table Work

  • Dynamic Iceberg Table Dimension

  • Dynamic Iceberg Table Latest Record Version

Streams and Tasks Package

• Version 2.4.1 — Added the Task DAG Create Root node type with new triggered task functionality. Fixed an issue where SIM and DSM node types did not correctly detect source information.