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.

We fixed a bug where the Node API endpoint would sometimes return a 500 error when using the ?detailsquery parameter.

• We fixed a bug where viewing column lineage would intermittently fail.

• Retrying a job from its point of failure now allows the job to run successfully.

Deployments should be clear, organized, and easy to follow. We’ve redesigned the Coalesce deployment experience to make it cleaner, more intuitive, and more informative. The new workflow improves everything from commit selection to error handling.

Key Improvements

• Streamlined Interface: A cleaner deploy view with more space to review commits and deployment details before execution.

• Tabbed Review Experience: Instead of collapsible menus, deployment changes are organized into clear tabs for Nodes, Subgraphs, Jobs, Mappings, Node Types, Macros, and Packages.

• Detailed SQL Visibility: Quickly see what’s changing with at-a-glance summaries, then drill into step-by-step SQL changes for each affected element.

• Improved Validation & Error Handling:

• Parameter validation, for example, JSON format checks, surfaces issues before deployment begins.

• Deployment-time issues, like missing or invalid Storage Locations, now have clearer error messages with actionable guidance to resolve them.

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.

Packages

• Snowflake Deferred Merge Package v2.0.0 - Now correctly adds and removes deploy phases at the appropriate stages.

• Snowflake Iceberg Tables package v2.0.0 – Fixes issues with removing deploy phases at the right stages.

Bug Fixes

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

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

• The Add Sources modal no longer cuts off buttons at the bottom.

• 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. Now that commit selection is cleared, users can choose a new commit from the branch.

We've launched a new Workspace Onboarding Wizard to create a more intuitive and efficient setup experience in Coalesce. This step-by-step process guides you through configuring everything needed to start developing, including authentication, version control, and storage mappings. Our goal is to minimize configuration time so you can begin building data pipelines faster.

Key Improvements

The new Workspace Onboarding Wizard streamlines the creation and duplication of Workspaces with the following enhancements:

• Reuse Configurations on Duplication: When you duplicate a Workspace, you can now choose to reuse its existing Storage Locations and Storage Mappings, allowing you to skip this configuration step.

• Automate Setup When Branching: When creating a new branch, the wizard automatically imports Storage Mappings from the source branch's commit history, ensuring a seamless transition.

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.