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 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 multisource nodes.

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

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.

This release includes performance improvements and bug fixes.

• We fixed a bug where deployments fail to proceed past the deploy plan in environments where the initial deploy has failed and no subsequent deployments exist.

• We fixed a bug where the placement of the merge conflict marker (>>>>>>) would invalidate the line of code it was on.

• We fixed a bug where the Results panel would not expand.

• We fixed a bug where if Job names were too long, the Deploy menu would be hidden.

• We fixed a bug where Nodes using joinTemplate didn’t automatically add dependencies.

• We fixed a bug where clicking Validate Select on certain Nodes caused the page to freeze.

• We fixed a bug where missing or corrupted metadata would cause the Mapping Grid to crash.

• We fixed a bug where clicking Discard All in the Git Modal caused a validation error.

• We fixed a bug where package and non-package nodes could lose metadata if a deployment failed without finishing.

Bug Fixes

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

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

This release includes performance updates and bug fixes.

We’ve made updates to product feature speed.

• Git merges are faster for large datasets.

• We fixed an issue where clicking Validate Select would freeze the page.