Subscribe to updatesWe’ve introduced caching to make deployment plans faster. The new Caching Deployment Plan feature reduces plan generation time by skipping SQL re-renders for Nodes that haven’t changed.
The feature can be enabled in two ways:
CLI flag: coa plan --enableCache
UI toggle: Available in the "Parameters" step of the deployment wizard.
Learn more about using deployment caching in our documentation.
Coalesce has introduced updates to improve metadata integrity across Nodes. Starting in the 7.24 release, null values in Node metadata are automatically removed.
When you commit changes, you may notice updates to Nodes that you haven’t directly modified. This is expected, since null fields are being removed. You should commit these changes and continue with your workflow.
Git Modal: You may see diffs in the git modal where null values are removed.
No additional action is required. Commit the changes when they appear to keep your project in sync.
Understanding how transforms connect back to their source columns is now clearer and more intuitive. This update reduces confusion in the mapping grid by showing source details alongside transforms, giving you a complete and accurate view of column lineage.
Clear Source Visibility: When a transformation is applied, the corresponding column source details are displayed in a read-only, grayed-out format.
Hover for Full Details: Hovering over the source reveals:
The original table or alias used
All columns included in the transform
Automatic resolution of unqualified column names to their source tables
Hash Column Transparency: Hash columns now expand to show the list of underlying source columns.
Better Alias Handling: Joins using aliases now display clearer lineage, improving traceability.
Deployments should be clear, organized, and easy to follow. We’ve redesigned the Coalesce deployment experience to make it cleaner, more intuitive, and more informative. The new workflow improves everything from commit selection to error handling.
Streamlined Interface: A cleaner deploy view with more space to review commits and deployment details before execution.
Tabbed Review Experience: Instead of collapsible menus, deployment changes are organized into clear tabs for Nodes, Subgraphs, Jobs, Mappings, Node Types, Macros, and Packages.
Detailed SQL Visibility: Quickly see what’s changing with at-a-glance summaries, then drill into step-by-step SQL changes for each affected element.
Improved Validation & Error Handling:
Parameter validation, for example, JSON format checks, surfaces issues before deployment begins.
Deployment-time issues, like missing or invalid Storage Locations, now have clearer error messages with actionable guidance to resolve them.
We're excited to announce the addition of User Management API and Git Account API endpoints.
Automate user provisioning workflows, implement bulk role assignments, and manage permissions across organizations, projects, and environments programmatically.
Review the User Management API documentation.
Programmatically configure Git connections, manage account credentials, and maintain Git repository associations as part of your CI/CD pipelines.
Review the Git Accounts API documentation.
We’ve continued to improve the user experience by:
Adding alphabetical sorting for Storage Locations and Environments.
Sorting the Nodes Panel alphabetically while also considering the Storage Location name. For example, if both Nodes are named analytics_source, the one with the Storage Location of SRC would come before the one with TGT.
Snowflake Deferred Merge Package v2.0.0 - Now correctly adds and removes deploy phases at the appropriate stages.
Snowflake Iceberg Tables package v2.0.0 – Fixes issues with removing deploy phases at the right stages.
When zoomed in, the Add Member button in the Project settings no longer disappears.
We've launched a new Workspace Onboarding Wizard to create a more intuitive and efficient setup experience in Coalesce. This step-by-step process guides you through configuring everything needed to start developing, including authentication, version control, and storage mappings. Our goal is to minimize configuration time so you can begin building data pipelines faster.
The new Workspace Onboarding Wizard streamlines the creation and duplication of Workspaces with the following enhancements:
Reuse Configurations on Duplication: When you duplicate a Workspace, you can now choose to reuse its existing Storage Locations and Storage Mappings, allowing you to skip this configuration step.
Automate Setup When Branching: When creating a new branch, the wizard automatically imports Storage Mappings from the source branch's commit history, ensuring a seamless transition.
We’ve enhanced the API so you can now create and manage your Projects using the /projects endpoint.
Benefits:
Ensure consistency: Apply naming conventions and configuration standards across all Projects.
Automate onboarding: Spin up new Projects for teams quickly.
Integrate with CI/CD: Seamlessly include project creation as part of deployment pipelines and infrastructure-as-code.
Get Started
We added alphabetical sorting to:
Documentation
Node type selector
Add new Node
This means locating items faster and reducing scan time for large lists.
Environment Reader roles have read access to the following API endpoints:
LIST Environments
GET Environments
Get Nodes
LIST Nodes
GET Job Status
GET Runs
LIST Runs
Ref functions now validate inputs during plan rendering. Empty strings or undefined values now throw clear errors identifying problematic Nodes when using the Coalesce App.
We fixed an error where users would get “Error installing package: failed to validate request body” when installing Nodes.
The Problem Scanner now returns the alert "Configure key pair in User Credentials tab” for missing Snowflake Key Pair credentials.
Fixed issue where data type changes to columns in Coalesce would not deploy when the target table contained unexpected columns in the data warehouse. Changes now deploy correctly.
External Data Package
Removed deploy phase, enhanced external table handling, and added Copy Unload metadata table creation.
Materialized View
Added deploy phase for Create/Cluster stages and removed it from Alter steps.
Incremental Loading
Refined deploy phase usage by adding it where needed and removing it from inappropriate stages.
Support for Databricks is now enabled by default across all accounts. Users can connect to Databricks workspaces from Coalesce to build and manage projects. Please reach out to your account team for more information on configuring connections, best practices, and licensing.
Databricks Packages are now live in Coalesce Marketplace. Build faster on your Databricks platform with ready-made packages designed specifically for your data lakehouse needs.
Databricks optimized Node types - Purpose-built Node types that leverage Databricks capabilities.
Pre-built templates - Jump start your Databricks projects with tested code patterns.
Lakehouse-ready components - Access packages designed for modern data architecture on Databricks.
Look for the Supported Platforms symbol to get started.
These features are currently in Private Preview. Please reach out to your Coalesce account manager to request access.
The Onboarding Wizard is back and better aligned with your needs. This step-by-step setup guides you through authentication and storage configuration so you can spend less time on setup and more time building pipelines.
Your Feedback in Action
Storage & Mapping Optional on Duplication: When you duplicate a Workspace, you can now reuse existing Storage Locations and Storage Mappings. This allows you to skip lengthy configuration.
Existing Commits: If you’re branching off an existing Workspace with mappings already in your repo, the Onboarding Wizard will automatically pull in those Storage Locations and Storage Mappings for you.
Why You’ll Love It
These tweaks remove unnecessary clicks when duplicating a Workspace, giving you a seamless transition every time.
We’ve refined the Deploy Wizard to give you clearer visibility into errors and warnings during the Review Plan step. Now, issues are organized into separate Errors and Warnings tabs so you can quickly zero in on what needs fixing before you deploy.
We resolved an issue where permissions for new Projects and Environments weren't applied to API tokens until the token owner logged in.