We are notifying all Coalesce customers using the command-line tools that an immediate upgrade to the Coalesce CLI version 7.17.1 or higher is required. Snowflake’s recent 2025_02 release includes changes that may cause service interruptions for users running older versions of the Coalesce CLI.
To prevent any disruption, please check your CLI version by running:
coa --version
If your version is lower than 7.17.1, upgrade your CLI by running:
npm upgrade -g @coalescesoftware/coa
For more information on the Snowflake bundle changes, please visit the Snowflake Release Notes.
Thank you for your immediate attention to this matter.
You can now create Nodes using the Create Workspace Node endpoint. Create Workspace Nodes supports creating all Node types. Combined with the Set Node endpoint, create and update Nodes programmatically.
Updates
We’ve made multiple API updates including:
Added pagination to List Environments. In addition to existing fields, we have added:
total - Number of results
startingFrom - The id the request starts from.
limit - The request page size. 100 is the default.
next - The value where the next page of results starts after.
Added type to List Run Results. Type indicates if it is a sql or sqlTest run.
When using ref functions, an error message will return if there is a cyclical dependency.
We’ve made some user interface improvements including:
Added tooltips for all statuses in the Activity Feed.
The Fetch button in the Git Modal has moved to be in-line with commit and branches.
Improved Column Lineage so it's easier to see the Node lineage.
Packages
New - View-Qualify Advanced Deploy Node
We’ve released a new package Node, View-Qualify Advanced Deploy UDN. This is a versatile Node that allows you to create and deploy views in Snowflake using the QUALIFY filter. It gives you a streamlined way to filter records within a View using window functions such as, RANK or ROW_NUMBER. It supports common use cases like deduplicating data, selecting top and bottom records, and applying customer filters.
Bug Fixes
Clicking on a Node in the Docs no longer results in an error screen.
Maintaining clear and consistent documentation across pipelines is always a challenge. Coalesce makes it effortless by automatically generating natural language descriptions from your lineage and transformation metadata to create:
Node & Column Descriptions: Auto-generated, easy-to-understand explanations of column transformations, logic, and business context — no more manual notes or guesswork. AI-Generated Git Commit Messages: Helpful, context-aware commit messages to keep your Git history clean, descriptive, and useful.
Benefits
How It Helps:
Reduce Documentation Overhead: Free up time for development while Coalesce handles the docs.
Maintain Consistency: Ensure standardized documentation across all data projects, teams, and environments.
Improve Stakeholder Clarity: Make it easier for business users and analysts to understand transformation logic.
Accelerate Onboarding: Help new team members ramp up faster with auto-generated, clean documentation.
How to Opt-In
AI Features not enabled by default in Coalesce. Organization admins can opt-in to the AI Documentation Assistant by going to Org Settings > Preferences and toggling AI Features.
The coa CLI will now display plan warning messages even if the plan was successfully created. This will help you identify any issues that come up before deployment.
The /api/v1/environments/{environmentID}/nodes and /api/v1/workspaces/{workspaceID}/nodes endpoints now have pagination. You can use the following query parameters to organize your responses:
Limit - The maximum number of Nodes to return.
startingfrom - The cursor point for paging the query results.
