The Get Nodes API endpoint no longer returns 500 errors when encountering malformed SQL in Nodes.
Fixed an issue where switching branches during Workspace duplication would incorrectly retain the commit from the previously selected branch, causing Workspaces to load without Nodes or Jobs. The commit selection is now cleared when switching branches, allowing users to select a new commit from the current branch.
Version 7.21.5
The Add Sources modal no longer cuts off buttons at the bottom.
The Get Nodes API endpoint no longer returns 500 errors when encountering malformed SQL in Nodes.
Fixed an issue where switching branches during Workspace duplication would incorrectly retain the commit from the previously selected branch, causing Workspaces to load without Nodes or Jobs. Now that commit selection is cleared, users can choose a new commit from the branch.
Streamline Your Setup with the New Workspace Onboarding Wizard
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.
Key Improvements
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.
Preview Release 7.22.0
New API Endpoints: User Management & Git Accounts
We're excited to announce the addition of User Management API and Git Account API endpoints.
User Management
Automate user provisioning workflows, implement bulk role assignments, and manage permissions across organizations, projects, and environments programmatically.
Review the User Management API documentation.
Git Accounts
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.
Updates
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.
Bug Fixes
When zoomed in, the Add Member button in the Project settings no longer disappears.
Version 7.21.4
New
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
Updates
We added alphabetical sorting to:
Documentation
Node type selector
Add new Node
This means locating items faster and reducing scan time for large lists.
Bug Fixes
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.
Packages
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.
Preview Release 7.21.3
We fixed a bug where the Join tab contents would return after being completely deleted when clicking outside the Node.
Preview Release 7.21.2
We fixed an issue where expired Snowflake OAuth authentication would cause an infinite loading state on the Workspace Connection screen.
Preview Release 7.21.0
Updates
We added alphabetical sorting to:
Documentation
Node type selector
Add new Node
This means locating items faster and reducing scan time for large lists.
Bug Fixes
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 that caused users to receive the error message: “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.
Databricks Support Now Available
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.