Coalesce cleaning up deprecated metadata fields in Nodes. The change will improve data integrity across Coalesce. This will happen in two stages:

• Release 7.14

• Release 7.15

When doing a commit, you might see changes for Nodes that you haven’t modified. This is expected while deprecated metadata is removed. We suggest making a commit with the changes then continuing on with your workflow. Do not delete, edit, or modify the deprecated fields in any way.

Changes in Release 7.14

Deprecated fields in 7.14  will primarily affect older workspaces that haven't been accessed recently. For actively maintained workspaces, the impact should be minimal. However, if you attempt to commit against previously archived or long-dormant workspaces, you may encounter these changes.

Deprecated Properties Removed

The following properties will be completely removed if present:

Top-level column properties:

• ghostRecordValue

• descendedFrom

• hashColumns

• columnsForHash

Inside hashDetails object:

• hashType

• hubHashes

Properties corrected for Invalid Data

Properties set to empty string (""):

• dataType - if not a string type

• transform - if empty

Properties completely removed if invalid

• appliedColumnTests - if null

• config - if null

• hashDetails - if it's a string (should be an object)

Column Reference Fixes

Column Reference (columnReference)

• stepCounter - if null/undefined, set to the node's ID

• All IDs within column references are converted to strings (previously numbers were allowed - this change has been around for a long time)

Source Column References (sourceColumnReferences)

For each reference in the array:

• All IDs within column references are converted to strings

• stepCounter - if null/undefined, set to empty string ("")

Hashed Columns Fixes

For hashedColumns array:

• All IDs within column references are converted to strings

Upcoming Changes in Release 7.15

Deprecated fields in 7.15 will affect all Source Node Types regardless of age or activity status.

Deprecated Properties Removed:

• dataset

• table

• metadata.join

• metadata.sourceMapping - already absent from most sources

This release includes bug fixes and performance improvements.

This release includes bug fixes and performance improvements.

Updates

• Project Architects and Project Contributors can now delete Workspaces in any projects they are part of.

• Our Join string editing capability now saves correctly when rapidly switching between multi-source nodes.

• Our Hash editor automatically displays all columns with proper scrolling functionality.

Reminder

Keep your CLI up to date to ensure access to the latest features, bug fixes, and security enhancements. Run`npm upgrade -g @coalescesoftware/coa` or download the latest version on NPM.

The previously reported issue affecting users on coa version 7.5.8 and below has been resolved.

• No immediate action is required for users on older versions.

• The fix maintains backward compatibility across versions.

• While older versions are now supported, we recommend updating to the latest version of coa when possible.

Command line users on version 7.5.8 or below should upgrade to coa version 7.10.2 immediately.

Users on`coa` version 7.5.8 and below may encounter deployment and refresh errors. The issue occurs with the presence of`platformKind:snowflake` in the data.yml.

To fix any critical deployment or refresh issues:

• Upgrade to coa version 7.10.2 as soon as possible to prevent further issues.

If you are unable to upgrade your coa version and need to deploy immediately:

• Check your commits for platformKind:snowflake in the data.yml file.

• Manually remove the platformKind:snowflake and commit the changes.

• Deploy as normal

We are working on a change to be delivered within the next 24 hours to allow backwards compatibility for older versions of coa as to not disrupt operations.

New

You can now add a "Re-Sync Columns" button to custom Nodes. This feature allows users to sync columns that are not part of a source Node. Learn more in Custom Node Types.

Updates

We’ve made updates to product feature speed.

Updates

• We’ve made it easier to manage SSO users that have been disabled or deleted.

Bug Fixes

• We resolved an issue in graph execution during deploys where changes to indirectly dependent nodes could result in failed deployments due to incomplete lineage evaluation. The deploy process now accurately accounts for the full dependency lineage of views, ensuring proper ordering of drop and add phases, even when gaps exist in the runtime graph. This fix enhances reliability and reduces the need for redeployments to resolve dependency conflicts.

• We fixed an issue where deploys for advanced deploy node types generated duplicate SQL, causing extra stages to run. SQL is now correctly generated for each stage, improving deployment efficiency and accuracy.

• We fixed an issue where trying to deploy returned an error that Node type does not exist.

This release includes bug fixes and performance improvements.