Coalesce Customers,

We're following up on our recent maintenance notice to correct the date and to clarify the scope of the work.

Corrected date: The planned maintenance window will take place on Saturday, July 25, from 8:00 AM to 4:00 PM Pacific Time, not July 26 as stated in our previous email. All other details remain unchanged.

During this window, the application will be fully offline and unavailable while we perform infrastructure re-deployment work to improve platform consistency and reliability.

We expect the work to take less than 4 hours, but we are reserving the full maintenance window until 4:00 PM Pacific in case unexpected circumstances arise.

What to expect:

• The platform will be fully unavailable for the duration of the maintenance window

• Users will not be able to access the application during this time

• No scheduled or automated jobs will run during this time

• Service, including job execution, will be restored as soon as the work is complete

We expect the work to take less than 4 hours, but we are reserving the full window until 4:00 PM Pacific in case unexpected circumstances arise.

We recommend planning work accordingly to avoid disruption and subscribing to updates on our Status Page:

• https://status.coalesce.io/

No action is required on your part. We'll share a follow-up notice once maintenance has been completed and the application is back online. If you have any questions or concerns, please reach out to our Support Team. We apologize for the earlier date error and appreciate your patience and understanding.

Mike McCune

VP of Engineering, Coalesce.io

Please see Correction: Planned Maintenance Notice: Scheduled Outage on Saturday, July 25, 2026

Coalesce Customers,

We’re writing to let you know about a planned maintenance window on Saturday, July 26, from 8:00 AM to 4:00 PM Pacific Time.

During this window, the application will be fully offline and unavailable while we perform infrastructure re-deployment work to improve platform consistency and reliability.

We expect the work to take less than 4 hours, but we are reserving the full maintenance window until 4:00 PM Pacific in case unexpected circumstances arise.

What to expect

• The application will be unavailable for the duration of the maintenance window

• Users will not be able to access the platform during this time

• Service will be restored as soon as the work is complete

We recommend planning work accordingly to avoid disruption and subscribing to updates on our Status Page:

• https://status.coalesce.io/

We’ll share a follow-up notice once maintenance has been completed and the application is back online.

If you have any questions or concerns, please reach out to our Support Team. Thank you for your patience and understanding.

Mike McCune

VP of Engineering, Coalesce.io

Google SSO

We've added Google as a Single Sign-On (SSO) provider. You can now log into Coalesce using Google Cloud or Google Workspace credentials Learn how to set up in Google SSO.

Updates

Copilot Create and Update V2 Nodes: When the SQL editor is enabled for your org, Copilot can now create and update V2 Node Types. Copilot writes V2 Nodes in raw SQL and automatically prevents mixing V1 and V2 Node Types.

Copilot Column Datatype and Nullability: Copilot can now change a column's datatype, precision, and nullability.

V2 Node Mapping Grid View: V2 Nodes now include a read-only mapping grid, accessible from the SQL editor. As you write SQL, the grid displays each column's transform, data type, source, nullability, description, and related fields.

Packages

Snowflake

Semantic View 1.0.1: Adds support for AI_SQL_GENERATION and AI_QUESTION_CATEGORIZATION on the Semantic View Node Type.

Dynamic Tables 2.1.8: Fixes Validate Select failures caused by the template rendering error 'ns' is undefined.

Base Node Types Advanced Deploy 2.5.5: Adds incremental loading and soft delete handling for Fact Advanced Deploy and Factless Fact Advanced Deploy Nodes.

Bug Fixes

Multi Source setNode Source Mapping: Fixed a bug where column sources and transforms were lost from all but the first source when using the setNode API on a Multi Source Node with a transformed column.

Force Checkout Data Loss Warning: Force checkout now correctly shows a data-loss warning when your version control repository format is stale, preventing accidental loss of uncommitted Workspace changes.

Azure DevOps Personal Access Token Expiration Error: When an Azure DevOps personal access token expires, you'll now see a clear error message with a direct link to the version control setup documentation.

AI Version Control Commit Message Size Limit: If a diff is too large for the AI commit message generator to process, you'll now see a specific error message instead of a generic 500 error.

Node Type V2 is available again in Coalesce.

Write a standard`SELECT` statement in the editor and Coalesce infers columns, data types, and upstream dependencies. Because V2 use SQL, use it with your AI agent to quickly create and convert Nodes. V2 nodes work alongside V1 nodes in the same workspace.

View the full documentation

V2 Node Types: SQL-First Authoring

You can now build transformations by writing SQL directly in Coalesce. Node Type V2 lets you paste existing queries, author CTE-heavy logic, or drop in AI-generated SQL and get everything Coalesce offers in return: automatic column extraction, full DAG and column-level lineage, template-driven deployment, and governance. Configuration moves into the file itself via inline annotations like @insertStrategy("MERGE") or @isBusinessKey, keeping your transformation and its metadata in one place. V2 nodes work alongside your existing V1 nodes in the same pipeline, so you can migrate at your own pace, one node type at a time.

Learn more about V2 Node Types.

COA CLI: Local-First Pipeline Development

You can now build and run Coalesce pipelines entirely from your terminal. The COA CLI brings local-first development to Coalesce, letting you author .sql transformation nodes in your editor of choice, run them directly against your warehouse, and deploy to your environment without touching the UI. Install it via npm, point it at your warehouse credentials, and you have the full pipeline workflow at your fingertips: coa create generates your DDL, coa run populates your tables, and coa plan and coa deploy push changes to your Coalesce environment. COA works with your existing Git workflow and supports the same V2 SQL nodes, node types, and ref() dependency graph you already know. Whether you prefer coding locally, integrating with CI/CD, or just want faster iteration cycles, the COA CLI is how you bring that workflow to Coalesce.

Get coa version 7.33.
Read the documentation.

Updates

• Copilot Downstream Column Descriptions: Copilot now carries column descriptions into downstream columns it creates.

Packages

BigQuery

BigQuery Base Node Types 1.1.0: Added a Last Modified Comparison option to MERGE logic for Persistent Stage, Dimension, and Fact Nodes; UUID visibility moved into the Node definition for column visibility; package tags for marketplace visibility; documentation updates including a config matrix.

Databricks

Databricks Base Node Types 1.1.0: Zero-key Dimension support, a last-modified toggle on Dimension, Persistent Stage, and Fact, soft delete and hard delete on Dimension, documentation updates, and an updated get_clause() macro.

Snowflake

• Streams and Tasks 2.6.1: Replaces ALLOW_OVERLAPPING_EXECUTION with OVERLAP_POLICY, small UI fixes, and Git documentation updates with impact analysis for task-enabled Node types.

• Iceberg Tables 3.2.1: Error and success notification integrations, execute as user, suspend after failures, task auto-retry, overlapping task runs, expanded task configuration and schedule fields, serverless warehouse size limits for tasks, and related documentation for Iceberg external tables.

• Functional Node Types 4.3.2: Node Type switch support and documentation updates.

• Deferred Merge 2.0.3: Task notification integrations, execute as user, suspend after failures, auto-retry, overlapping runs, richer schedule and configuration fields, serverless task size bounds, and schedule unit expansion.

• Create or Alter package 1.6.1: Same task-focused improvements as Deferred Merge 2.0.3 for supported Node types.

• Cortex 4.0.0: Replaces deprecated !PREDICT with AI_EXTRACT, renames Document AI to AI EXTRACT, and updates configuration to match the new function.

Bug Fixes

• Databricks Token Authentication: Databricks token authentication now shows clearer errors to help with troubleshooting.

• setNode With Duplicate Table Names: setNode now resolves the correct table when two tables share a name but live in different storage locations.

• Presync Errors: Presync deploy errors show clearer messaging to help with troubleshooting.

• Workspace Wizard and Git Permissions: When Git credentials lack permission, the Workspace creation wizard keeps your entries and shows a specific error instead of a generic failure.

• Re-sync Columns and Descriptions: Re-syncing columns now picks up description changes from your data platform so your Node metadata stays current.

• Run Details Sorting: Sorting ascending or descending in run details works when some values are missing instead of mis-ordering rows.

Ignore this

BigQuery in Private Preview

Big Query support in Coalesce Transform is now available in private preview. Reach out to your account team to enable it.

UI Changes

• Project and Workspace ID in URL — URLs now include the Project and Workspace ID, making it easy to share direct links to specific Workspaces. For example /projects/<project-id>/workspaces/<workspace-id>/build

• Redesigned Copilot Chat History — The Copilot chat history now uses a card-style design with improved hover states. History items show "X messages · Xh ago" instead of full timestamps, and the delete button only appears on hover for a cleaner look.

Copilot

• Message Feedback — You can now provide feedback on specific Copilot messages using like and dislike buttons, helping improve AI response quality.

• Improved Abort Functionality — The Copilot abort button now properly stops the UI spinner when you cancel a request. Previously, the spinner continued even after aborting.

Packages

BigQuery

• Base Node Types 1.0.0 is available — Sign up for our private preview by contacting your account manager.

Bug Fixes

• Preserved Thread Titles — Fixed an issue where Copilot thread titles were overwritten when starting a new chat. Existing thread titles are now preserved correctly.

• Runtime Parameter Warning Consistency — Fixed an issue in the Node Type Editor where after correcting invalid runtime parameters and saving, the error popup wouldn't automatically clear until you left and re-entered the editor. The warning now updates correctly when parameters are fixed.

• Copilot Text Overflow — Fixed an issue where text content in Copilot responses overflowed horizontally beyond the shaded content area. Content now displays within proper boundaries.

• Subgraph Tab Handling — Fixed an issue where deleting a Subgraph while its tab was active resulted in a blank white tab. The interface now handles Subgraph deletion gracefully.

• Code Editor Line Numbers — Fixed a CSS conflict where duplicate line numbers would appear.

Navigating complex data pipelines just got easier. We've introduced several enhancements to the Node graph view that help you visualize, filter, and explore your DAGs more efficiently. Whether you're tracking down dependencies or understanding your pipeline's structure, these tools work together to give you better control over how you view and interact with your data transformations.

Mini Map

The Mini Map gives you a bird's-eye view of your entire graph at once. Instead of panning around to understand your DAG's size and structure, you can now see the complete layout in a compact overlay.

The colored Nodes in the Mini Map match the Node types in your main view, making it easy to identify sources and targets as you navigate.

Filter Your DAG

You can now refine your view by dragging Nodes directly from the Node list into the filter. Drag a Node into the Include area to focus on it, or into Exclude to hide it from view. This makes filtering faster and keeps your graph focused on what matters most.

Explore Lineage From Any Direction

You now have more control over how you expand lineage directly from the context menu:

• Upstream: Shows the data sources that flow into your Node.

• Downstream: Reveals where your data goes next.

• Related: Displays both directions at once for a complete picture.

This gives you more control over how much lineage you explore at a time.

Node Expansion

Click the plus icon on any Node to expand its lineage one step at a time. If a plus icon appears, there's another Node connected. If the icon isn't there, you've reached the end of that path. You can expand both upstream and downstream connections this way.

The filter automatically updates to show Custom when you add Nodes individually.

Spotlight Navigation

Spotlight helps you navigate large DAGs 4 Nodes at a time. If you have 12 Nodes, Spotlight expands them in manageable chunks. Click Spotlight again to move forward in the direction you want, 4 Nodes at a time.

Collapsed Nodes by Default

All Nodes are now collapsed by default to use screen space more efficiently. If you want to see all the columns in a Node, expand it.

Storage Location in Graph View

Storage Locations now appear directly in the graph view, making it easier to identify where each Node originates.

Alphabetically Sorted Nodes

When you right-click on a Node and select Add Node, all available Nodes now appear in alphabetical order. This matches the sorting order in the left-hand Node list, making it consistent across the interface.

View Column Lineage From the Column Grid

You can now view the lineage of any column directly from the Column Grid. Right-click on a column and select View Lineage to trace where it originates, how it transforms, and where it's used downstream.

Columns are collapsed by default but can be expanded to show full mappings. You can edit columns directly and use Propagation to apply changes consistently across connected Nodes.

Get a quick tour by watching this video or visiting our documentation.

These features are currently in Private Preview. Please reach out to your Coalesce account manager to sign up.

We've made significant improvements to Node type switching in Coalesce. When changing a Node's type (for example, from View to Dimension), Coalesce now performs a complete metadata reinitialization based on the target type definition. This ensures your Node fully adopts the target type's structure while intelligently preserving your work.

You can also now use the bulk edit to switch Nodes Types across multiple Nodes at once. Each Node displays its own preview, showing the specific metadata changes that will occur for that Node.