What's New

• The Run Results grid has had a major interface overhaul and now provides a live progress bar, per-stage and per-run metadata, as well as sorting and filtering for many fields. More details here

• Coalesce now adds Snowflake query tags automatically for every job run via Deploy/Refresh, which provide information about the job's context. Query tags for Create/Run jobs are coming soon!

• Users can now be deleted/deactivated via the Org Settings menu by Admin users. More details here

• The Problem Scanner now detects columns that reference tables not in the JOIN string and triggers a problem accordingly

• There are now a series of helper tokens {{TGT}} similar to the existing {{SRC}} ones, except these look at the current node/column name instead of the source. More details here

• You can now select a commit in the Deploy Wizard by clicking anywhere in the row, not just the name

• The SHA of the current git commit is now visible in the git modal

• Changing the node type is now supported for Multi-Source nodes

• Source column cells now have tooltips on hover

• Column Bulk Editor interface improvements so that indentations and hierarchy are easier to notice

• Storage locations listed in a node's Properties section now show the database and schema associated with that location

• Column Grid now shows Storage Location as a column

• The Security Settings page has been renamed Change Password to better reflect its purpose

• New better-looking workspace launch buttons

• Improved the quality of errors provided by the coa CLI application to users

• This release includes minor performance and UI improvements. The app should be running smoother than before.

Bug Fixes

• Updating a workspace now correctly reports a workspace was edited, not an environment

• Fixed a rare bug where invalid JSON in Parameters could sometimes cause an app crash

• Fixed a rare race condition bug that could occur when duplicating nodes

• Fixed a misleading result error on the Deploy page whereby a test would pass, but still be shown as a failure

• Fixed many other smaller problems and improved error logs

• There's now a new Node Selector syntax. This filter is supported in all views. More details are in our Selector article. Note that this represents a breaking change for ad hoc CLI/API jobs that used the previous syntax.

• There is now a common git repo URL that is shared between all users within the same Organization. This represents a potential breaking change, as you'll need to re-enter your git credentials before you can proceed with git-related tasks.

• A new version of Jobs is now available. You can use the Node Selector to include or exclude nodes from a Job. More details in our Jobs article.

• Subgraphs now open in their own tab. See more details in our Subgraphs article.

• Column grid view now supports bulk editing of non-source columns.

• Column bulk editor now supports Column Name updates using Jinja2 templates.

• Grouping by table headers is now available in Node grid view.

• The problem scanner will notify users about broken refs occurring in the join textbox within a node.

• If using the Coalesce coa CLI, you must upgrade to version 1.0.167 or later to use the latest features listed above.

• You can now restart a failed refresh via API - Rerun Failed Refresh/Job or coa CLI CLI Refresh.

• This release includes significant UI improvements. Hopefully, the app should be even better for everyone.

• You can now choose the nodes you want to deploy using the 'Deploy enabled' toggle or through bulk edit. You can read more details here.

• We're always working on performance improvements - and this release improves many aspects of the app, including plan calculation times, git modal load times, join editor performance, and overall graph performance.

• Improved handling of JSON columns.

• Dev Workspaces has landed! You can now develop in parallel without stepping on each other's toes and merge back together when the time is right. Developers, the world is yours! You can read more details about this in our 4.0 guide here.

• A preference that allows you to choose a default storage location for each node type, instead of using the same location for all of them. For the choosy types.

• You can now use the {{this}} variable in transforms, joins, and templates. Renders to a ref_no link of the current node.

• We’ve made some interface improvements to the git integration. Putting our best foot forward.

• Bulk edit is now available in Node Grid view for mass updating of Node Types or Storage Locations! Edit nodes to your heart’s content.

• You can now export your Run results via coa CLI.

• The app now allows users to specify additional attributes for system columns such as nullability, default value, or description.

• You can now view your subgraphs in alphabetical order on the left sidebar.

• Coalesce will now gracefully take you to a 404 error page when we cannot find what you’re looking for.

• Thanks to a few tweaks and polishes, the app should be running smoother than before.

• You can now use profiles to set frequently used configurations in the coa command-line interface.

• Key pair authentication is now available for coa CLI.

• Override Snowflake authentication parameters via API and CLI.

• Viewing a node ID for a node is just a hover away.

• Run node refreshes via CLI selector syntax (limited support).

• Previously, the node type editor had developed a distracting text overflow issue. That has been fixed now.

• Clearing your search from the source cascader no longer throws an error.

• Pagination for Job history now works as expected.

• Improved issues with git versions

• Improved column lineage calculation

• Fixed a bug where column propagation would not create a new column correctly

• Fixed performance issues with the source select dropdown

• We tweaked many other issues as well

• Ability to set read-only variables (Parameters) that can be accessed via node templates. Parameters can be set to control the behavior of nodes during development and deploy time via the GUI interface. CLI and API options are coming soon which will allow the user to set parameters during both refresh and deploy.

• SSO Authentication to Coalesce via Azure Active Directory

• Improved switcher to change the view of Node and Column browser between Graph, Node Grid, and Column Grid

• Improved the "Something went wrong" page when Coalesce encounters a bug. Errors are automatically sent to an on-call engineer for an investigation to improve our product continually.

• Ability to execute multiple jobs at the same time in a given environment

• Deleting columns now presents the user with an option to abort the action. We have observed that very few users use the propagate deletion flow when deleting a column from the grid. To kick off deletion propagation, you must now do this from the Column Lineage interface.

• Various minor improvements to make the app better!

• We are excited to release multi-branch git support to our customers! You can now check out older versions of your data pipelines, branch for new feature development or implement a hotfix, merge in changes, and handle merge conflicts—all from within the app!

• Run status now displayed in Node grid to have a tabular view of what is running in your DAG.

• Introduction of Column-level grid to browse all columns in your DAG. Currently, this feature is read-only...but exciting things are to come!