Updates

We’ve focused this release on UI clarity, smoother onboarding, and CLI updates.

UI Changes

• Clearer Join Error When a Source Is Missing — If you attempt to join to a source Node that doesn’t exist in Coalesce, the error message now explains exactly what’s missing and where to fix it.

Connections and Authentication

• Private Key Formatting Guidance — The Snowflake User Credentials screen now clarifies the expected private key format, reducing auth setup errors.

Onboarding

• Skip Steps 2 and 3 — You can now skip steps 2 and 3 of the Onboarding Wizard when you already have those items configured, speeding up project setup.

CLI Updates

• Readable Errors and Warnings — The Coalesce CLI now formats deployment errors and warnings for easier scanning during runs.

Bug Fixes

• Mixed JSON Key Types Could Drop Derived Columns — Resolved an issue where derived mappings omitted columns when JSON keys mixed data types.

• Environment Deletion via API — Fixed an error that prevented deleting Environments using the API.

• CLI Hang on Exit — Addressed a rare case where the CLI could hang after completing work.

• Required Metadata Discard Error — Fixed an error thrown when discarding required metadata updates.

Packages

Streams and Tasks Package

Introduced a newInsert Or Merge With Task Node type for the Streams and Tasks package.

• Enables developing a stream on top of a table, view, or external table.

• Adds an option to create a target table and insert or merge data from a source, with a task orchestrating the operation.

Other Updates For Streams and Tasks

• Added comprehensive metadata update checks in create templates.

• Fixed comment block parsing.

• Updated node definition default scheduler option to prevent predecessor validation issues.

Functional Node Types

Added comprehensivemetadata update checks to the create templates flow to prevent mismatches during template generation.

Dynamic Tables

• Timestamp field uses a transform when configured.

• Record versioning now supports integer columns.

• When multiple timestamp columns exist, only the first selected column is considered.

Bug Fixes

• Fixed an issue where certain read-only editor fields could incorrectly be editable

• Fixed an error preventing environments with large node counts from being deleted via API

• Fixed an issue where nodes with null values caused blocking errors

Update to Supported Node.js Versions for the Coalesce CLI

Starting with the 7.24 release, we are updating the supported Node.js versions for the coa CLI to ensure you are working in a stable and secure environment.

What's Changing?

The coa CLI will now enforce the use of the following Node.js versions:

• 20

• 22

• 24

Support for Node.js version 18 will be removed.

Why We're Making This Change

We're removing support for version 18 because it reaches its end-of-life in April 2025. Support for version 24, a Long-Term Support (LTS) version, has been added to ensure continued stability and security.

Action Required

If you are running Node.js version 18, you must upgrade to a supported version to continue using the coa CLI. After updating to release 7.24, running the CLI with Node.js version 18 will cause the CLI to exit with the following error message:

Invalid node version 18 not supported

Updates

• Column lineage - We’ve improved the process by adding in app guidance and improving the visual indicators making it easier to see the propagation before commiting.

• Snowflake Authentication - The Problem Scanner now alerts you when Snowflake authentication is missing.

Bug Fixes

• Testing a Databricks SQL Warehouse connection will no longer fail with a "Missing token" error when a valid token has been entered.

• Service accounts with Environment Admin permissions for Snowflake environments will no longer receive an "Invalid Connection Information" error on API calls.

• Deploying a Storage Mapping change will no longer result in a "No schema found" error if the old schema or database was deleted directly from the data warehouse before deployment.

• Deleting a source from a column now works consistently when using a trackpad or a mouse.

• Sorting and filtering by Node Status or Stage Status on the deployment runs page will no longer revert or disappear on runs with a large number of objects.

• Deleting a Source Node and creating a new table Node with the same name and location in a single deployment will no longer replace the existing table and cause data loss.

• The Get Nodes API endpoint no longer returns 500 errors when encountering malformed SQL in Nodes.

• Fixed an issue where switching branches during Workspace duplication would incorrectly retain the commit from the previously selected branch, causing Workspaces to load without Nodes or Jobs. The commit selection is now cleared when switching branches, allowing users to select a new commit from the current branch.

New API Endpoints: User Management & Git Accounts

We're excited to announce the addition of User Management API and Git Account API endpoints.

User Management

Automate user provisioning workflows, implement bulk role assignments, and manage permissions across organizations, projects, and environments programmatically.

Review the User Management API documentation.

Git Accounts

Programmatically configure Git connections, manage account credentials, and maintain Git repository associations as part of your CI/CD pipelines.

Review the Git Accounts API documentation.

Updates

We’ve continued to improve the user experience by:

• Adding alphabetical sorting for Storage Locations and Environments.

• Sorting the Nodes Panel alphabetically while also considering the Storage Location name. For example, if both Nodes are named analytics_source, the one with the Storage Location of SRC would come before the one with TGT.

Bug Fixes

• When zoomed in, the Add Member button in the Project settings no longer disappears.

We fixed a bug where the Join tab contents would return after being completely deleted when clicking outside the Node.

We fixed an issue where expired Snowflake OAuth authentication would cause an infinite loading state on the Workspace Connection screen.

Updates

We added alphabetical sorting to:

• Documentation

• Node type selector

• Add new Node

This means locating items faster and reducing scan time for large lists.

Bug Fixes

• Environment Reader roles have read access to the following API endpoints:

  • LIST Environments

  • GET Environments

  • Get Nodes

  • LIST Nodes

  • GET Job Status

  • GET Runs

  • LIST Runs

• Ref functions now validate inputs during plan rendering. Empty strings or undefined values now throw clear errors identifying problematic Nodes when using the Coalesce App.

• We fixed an error that caused users to receive the error message: “Error installing package: failed to validate request body” when installing Nodes.

• The Problem Scanner now returns the alert "Configure key pair in User Credentials tab” for missing Snowflake Key Pair credentials.

• Fixed issue where data type changes to columns in Coalesce would not deploy when the target table contained unexpected columns in the data warehouse. Changes now deploy correctly.

Bug Fixes

• Fixed an issue that caused jobs to fail during Snowflake connection validation if the connection did not close properly. This prevents job failures due to connection cleanup errors during validation.
• Fixed an issue where checkboxes would not appear on downstream nodes when using the "Propagate addition" feature for newly added columns in the column lineage view. This ensures the column lineage propagation feature works consistently for both existing and newly added columns.