This release includes several performance improvements and bug fixes, with some highlights:

• Improved deploy page performance, especially for users with a large number of runs.

• Fixed a deployment issue caused by missing location in column lookup.

• Resolved deployment ordering issue that could cause failures or require multiple attempts.

• Addressed a bug with unsupported data type changes, ensuring consistent deployment success.

• Corrected permissions issue allowing Environment Admin Role to create Job Schedules.

• Fixed a 500 error when using the copy tool to transfer objects between workspaces.

• Resolved incorrect column lineage display when using lateral flatten, improving data traceability.

• Addressed deployment failures related to large plan file sizes.

• Fixed a rare issue causing column lineage to crash.

• We’ve released CLI version 7.7.7

• CLI Version 7.6.9 has been released.

• Fixed: We fixed an issue where the CLI plan was too large to write to a file.

• This release includes performance improvements and bug fixes.

• CLI version 7.6.8 is available.

• This release includes performance improvements and bug fixes.

• CLI version 7.6.7 is available.

Bug Fixes

• Fixed: Accounts with a email address as the username in Snowflake were receiving connection errors.

• Fixed: Unsupported data type changes failed on the first deploy, but succeed on the second attempt with no code changes.

• Fixed: Nodes weren’t deploying in order under certain circumstances.

• Fixed: CLI versions greater than 7.4.3 would return a RangeError: Invalid string length when running plan.

Version 7.6.5

Updates

• A new locations.yml is part of commits. It contains the default storage location and a list of storage locations.

• You can now retry a Job from failure in the Coalesce app. When you retry a Job, the run details will have a link to the previous run.

• We’ve improved the error logging for the CLI.

• You can now extend and modify Packages.

Bug Fixes

• We fixed a bug where the API did not return the correct run URLs.

• We fixed a bug where if there were too many Hash columns, scrolling wasn’t enabled.

• We fixed a bug where users who were connected to a large number of workspaces weren’t able to login using OAuth.

• We fixed a bug where insert statements were being ran, despite a Snowflake network error.

Documentation

We’re launching a new documentation site! You can check it out at https://preview-docs.coalesce.io/docs/.

What can you expect?

• The week of September 29, 2024, Coalesce will implement the new site at https://docs.coalesce.io/docs. The documentation site URL is not changing.

• Some page URLs have changed and redirects have been created.

• We fixed a bug where large jobs were failing due to repeated processing of the same information.

• We’ve released CLI version 7.5.8
  
  

Scheduler

We’ve released our built in Scheduler. This enhancement introduces in-app scheduling capabilities for Coalesce jobs, eliminating the requirement for external scheduling tools for basic job orchestration.

• Read about setting up the Scheduler.

RBAC

We're excited to announce the release of Role-Based Access Control (RBAC). With RBAC, you can assign roles to users based on their responsibilities, ensuring they only have access to the data they need. This minimizes the risk of unauthorized access, streamlining user permissions while enhancing overall security.

• Read our RBAC Migration Guide.

• Learn about using RBAC with Coalesce.

Updates

• Git Parse - We’ve improved handling parsing errors in Git.

Bug Fixes

• We fixed an error where the failed `queryID` was a mismatch between Snowflake and Coalesce.

🛑Action Required🛑

Git Repo Format Upgrade must be completed by September 5, 2024.

On September 5, 2024, Coalesce will enable the Git Repo Format Upgrade for all existing customers.

As part of the upgrade, you’ll need to upgrade your CLI and enable the Git Repo Format Upgrade. Review our announcement to learn more.

We’ve released Version 7.4.3

New

Edit Nodes API

We’ve released three new endpoints that allow you to manage Nodes in your Workspaces.

• List Nodes - Returns a list of all the Nodes in a Workspace.

• Get Node - Returns information about a single Node.

• Set Node - Edit existing Nodes in a Workspace.

Refresh Jobs

You can now run existing Jobs in the Coalesce App. 

Updates

• We’ve updated our Git integration to better handle sync and validation errors.

• We’ve improved the speed of the Build page for large data pipelines.

Bug Fixes

• We fixed a bug where you couldn’t clear multiple sources using the Bulk Editor.

• We fixed an issue where users received an error about uncommitted changes when updating from the remote repository, despite not making any changes.

• We fixed a bug where not all tables were available when adding a source.

• We fixed an issue where Docs were slow to open.

• We fixed a bug where Node descriptions that were null wouldn't deploy.

Find Us Online

• Coalesce

• LinkedIn

• YouTube