North American Transform Customers,

We successfully completed our scheduled outage this morning but some of our customers are experiencing job execution failures due to changes we made during the outage.

During the scheduled maintenance we took a series of steps to increase the scale of our cloud infrastructure, which is now fully utilizing all of our documented outbound network range for our Google Cloud us-central1 region. If you have a Data Platform network policy defined, please confirm and update your IP address allowed list to include the full set documented here under the “US | Google | us-central1 | Iowa” section:

https://docs.coalesce.io/docs/setup-your-project/setup-requirements/network-requirements

Ensure you have the full list configured, not only the addresses that are new to you. Coalesce may connect from any address in this range, and which one it uses on a given connection is not fixed. Allow-listing a subset can appear to work and then fail later.

We apologize for the disruption. Please reach out to our Support Team with any questions.

Updates

• V2 SQL Syntax Highlighting: The V2 Node editor highlights SQL keywords, types, functions, comments, Coalesce annotations, and Jinja template delimiters so SQL is easier to read while you edit.

• Copilot Graph Search and Explore: Copilot can search your Workspace graph by Node name, fully qualified name, or description, and can run a read-only Explore subagent that investigates with read-only tools and returns a short digest in chat.

• Copilot Opus Model Option: Copilot now has Fast and Smart effort modes, adaptive thinking, and read-only-by-default steering for mutations.

• Snowflake View GROUP BY ALL: Snowflake View Nodes include a GROUP BY ALL configuration toggle. The toggle is mutually exclusive with Select Distinct.

• COA Dry-Run Preview Status: `coa run --dry-run` distinguishes Nodes with no DML to preview (streams, dynamic tables, and views) from real failures, so managed objects no longer appear as red errors when the pipeline is healthy.

• Run Details Step Duration: Run details show step durations in seconds, minutes, or hours instead of raw milliseconds, and sorting by duration still works.

• Snowflake Comments During Plan: During plan, Coalesce can load existing Snowflake table and column comments from the warehouse. This supports externally managed descriptions without changing how you edit descriptions in the UI.

Packages

Snowflake

• Create or Alter package 1.6.2: Adds a delete option to the Create or Alter Persistent Stage Node Type.

• Base Node Types Advanced Deploy 3.0.0: Adds the External Sync Node Type.

Bug Fixes

• Business Key and Change Tracking Git Sync: Editing Business Keys or Change Tracking after the initial commit now updates the generated SQL so Git tracks the change and redeploy carries the new configuration to other Environments.

• Copilot Storage Location Instructions: Copilot honors explicit storage location requests instead of substituting the dominant Workspace pattern, and rejects unknown`ref()` locations with a clear suggestion when possible.

• Node Right-Click Menu Visibility: The graph Node context menu keeps a consistent width and shows all options, including Delete Node, without scrolling when the Node is selected.

• SQL Parse Errors at Plan Time: When active SQL fails to parse, plan and deploy surface the parse error instead of compiling stale Node metadata.

• Account URL Paste Handling: Pasting a full Snowflake account URL into Workspace or Environment Account URL fields strips the`https://` prefix and`.snowflakecomputing.com` suffix as you paste or type, so the saved value is only the account identifier.

• Create Branch with Duplicate Column IDs: Creating a new branch from a commit that contains duplicate column IDs no longer partially checks out the branch.

Updates

• Copilot Preferred Node Type Version: You can set a V1 or V2 Node Type preference in AI org and project settings. The default is V1. When you choose V2, Copilot prompt context updates so it reasons about and generates the correct Node Type.

• External Node and Column Descriptions: Organizations can configure table and column descriptions to be managed outside Transform. The description field can’t be edited with this setting enabled.

• Deploy Plan Details Layout: Deploy plan details open in a larger drawer so you have more room to review changes.

• Deploy Dashboard Job Filter: You can search and multi-select Jobs on environment cards in the Deploy dashboard. Job names are listed alphabetically with their IDs, and deep-linked Jobs stay visible.

• Scheduled Jobs Cron Expression: The Scheduled Jobs table includes a Cron Expression column between Schedule Name and Last Execution. Hover the info icon to see a human-readable schedule description.

Packages

Snowflake

• Streams and Tasks 2.7.2: Adds a Task Time Out option for all task-related Node Types, including Dimension with Task, Fact with Task, Work with Task, Stream and Insert or Merge, Task DAG Create Root, Delta Stream Merge, and Insert or Merge with Task.

• Streams and Tasks 2.7.0 : Adds the Task DAG Custom-SQL Node Type for executing custom SQL within Task DAGs. Includes Task DAG Resume Root case-retention and trimming improvements.

• Data security package 2.0.0: Adds the Masking Enabled Materialized View Node Type.

• Base Node Types Advanced Deploy 2.5.7: Resolves a minor issue in the Dimension Advanced Deploy Node Type discovered during validation of related bug fixes.

Bug Fixes

• Git Input Fields During Loading: Git modal input fields are disabled while commit, push, or force checkout actions are in progress, preventing edits during loading.

• Databricks Intermittent HTTP 400 Errors: Fixed intermittent HTTP 400 responses when creating or running Nodes against Databricks with token authentication (Cloud or Browser).

• Missing Database or Schema During Plan: Planning no longer blocks when a Node's database or schema no longer exists during managed-access checks. Missing or invalid locations surface as deploy warnings.

• Deploy Dashboard Cross-Environment Jobs: Jobs no longer incorrectly show under other environment cards when you expand multiple platform environments on the Deploy dashboard.

• Results Pane Sort Order: Fixed inconsistent ordering in the Workspace results pane where the latest result could appear at the bottom instead of the top.

• V2 SQL Comment and UNPIVOT Parsing: The V2 SQL parser now respects line and block comments and parses UNPIVOT. Commented-out SQL no longer compiles into DDL or DML.

• Node Run Double-Click: Fixed an issue where rapidly double-clicking Run in the Node menu could throw a "Nodes are already running" error.

• Node Type Editor Monaco Error: Fixed a "undefined" is not valid JSON error in the Monaco editor when editing Node Type templates.

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.

• Metadata Differences in Plan: When you generate a plan, the Deploy wizard includes a Changes tab on each altered Node. The tab shows property-level before and after values for DDL, metadata, source mapping, and other changes.

• COA CLI and API Environment Management: coa environments update is available in the COA CLI and the API. It supports creating, updating, and deleting deployment environments.

• Environment List Project Filter COA CLI and API adds a project filter for environments. coa environments list --project or ?project=.

Packages

Snowflake

Base Node Types 1.6.2: Removes the Treat NULL as Current Timestamp toggle from Persistent Stage, Dimension, and Fact Nodes, and includes Persistent Stage bug fixes.

Base Node Types - SQL 1.0.0 : Initial release with INSERT and MERGE support for SQL-first V2 Node authoring in Coalesce.

Base Node Types Advanced Deploy 2.5.4: Same Treat NULL as Current Timestamp toggle removal as Base Node Types 1.6.2, plus a validation stage when Last Modified is enabled that stops execution if NULL values exist in the selected timestamp column, and includes Persistent Stage Advanced Deploy bug fixes.

Cortex 4.1.0: Adds task enhancements to the AI EXTRACT Node Type: notifications, execute-as user, suspend after failures, auto-retry, overlapping execution, and expanded schedule units, and adds Node Type Switch support to CSS and AI EXTRACT Node Types.

Iceberg Tables 3.3.0: Adds the External Iceberg REST Table Node Type and fixes Iceberg Dynamic Tables validate-select behavior.

Fabric

Fabric - Base Node Types 1.0.0: Initial release with core Fabric Node Types and basic pipeline functionality.

Bug Fixes

• Duplicate Column IDs on Git Pull: Coalesce blocks checkout when a commit introduces duplicate or empty column IDs in a Node.

• COA Init Refresh Token Guidance: coa init now points you to the Deploy tab for refresh tokens instead of the Build tab.

• Column Name Editor Console Errors: Editing column names in the Node grid no longer routes non-SQL fields through the SQL web worker, which removes spurious JSON.parse errors in the browser console.

• COA Validate False Missing-Column References: Fixed an issue where coa validate reported missing column references on V2 SQL Nodes that select from V1 YAML sources when the column UUID counters were valid.

• V2 SQL Deploy with Package Node Types: When you plan or deploy V2 SQL Nodes that use a Node Type from an installed Package, Coalesce now generates tables with the correct columns. Previously, deploy could produce empty table definitions that your warehouse rejected.

Updates

• Job Scheduler Parameters: Define parameters directly in the Job Scheduler when creating or editing scheduled Jobs.

• COA Init Command:coa init is an interactive setup flow for project configuration, Snowflake credentials, storage location mappings, and default V2 Node scaffolding. Runs coa doctor at the end.

• COA Environment Management from the CLI: Create and delete environments with coa environments create and coa environments delete.

• Git checkout progress: Branch checkout in version control now shows a progress modal.

Bug Fixes

• Parameter errors during plan: Planning catches invalid parameter references before deploy or refresh.

• Join tab performance: Join tab editing on Nodes with large source mappings is faster and more responsive.

• Column lineage view focus: Column lineage keeps zoom and pan position when switching tabs.

Packages

Snowflake

• Semantic View 1.0.0: Initial release of Semantic View and Semantic Query Node types for Snowflake semantic layer workflows.

• Incremental Loading 2.1.1 : Adds Node Type Switch support in advanced deploy templates.

Databricks

• Databricks Base Node Types 1.1.1: Adds unmatched record strategy options to Persistent Stage and Fact Nodes.

• Lakeflow Declarative Pipelines 1.1.0: Adds file format and advanced file format options, with support for AVRO, ORC, TEXT, and XML.

Updates

• Job Scheduler cron timezones: Scheduled Jobs accept a timezone so runs align with the clock you intend.

• New UI navigation polish: We refined sidebar and Build workspace visuals and labels, including Workspace Settings and Build Settings tooltips, a higher-contrast graph background, updated secondary grey theme transparency, and a black logo mark in the build workspace.

• Git validation for SQL Nodes: Validation during Git operations catches SQL Node and Node Type mismatches and duplicate Node IDs before they cause downstream errors.

• CLI sources: CLI source handling improvements support local-first workflows.

• Projects list search: You can search the Projects list to reach a Project faster in large organizations.
  

Packages

Snowflake

• Base Node Types 1.6.1: Adds a delete option for Persistent Stage and includes bug fixes in base Nodes.

• Base Node Types Advanced Deploy 2.5.3: Persistent Stage delete option, Metadata Stage handling for Jinja in text inputs across advanced deploy Node types, and other bug fixes.

• Functional Node Types 4.3.3: Adds a ddlColumncasing macro and updates Pivot and UNPIVOT Node types to quote pivot columns consistently.

Bug Fixes

• View deployment ordering: Views that depend on one another are dropped and re-created in the correct order, ensuring upstream views always exist before downstream views are updated,

• Git checkout after browser refresh: If you refresh the browser while the app is syncing files with Git checkout, the Git UI can still write files.

• Snowflake MODEL() parsing: Snowflake ML MODEL() invocation parses correctly in SQL Nodes.

• Job-spec selector case sensitivity: Job-spec selector name matching is now case-sensitive.

• coa doctor Snowflake key pair path: coa doctor now accepts snowflakeKeyPairKey .

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.

Updates

• Pause and Resume for Scheduled Jobs: You can pause and resume scheduled jobs from the action menu instead of deleting them. When a Job is paused the next run shows Paused.

• Create Job Schedules Without an Immediate Run: When you create or edit a schedule, you can turn off the automatic run on save so the first execution waits for the next scheduled run.

• Faster Clones for Large Git Repositories: We’ve enhanced the Git cloning process during Workspace creation, significantly improving speed for large repositories.

• Add Sources Modal and Data Preview: The Add Sources flow now updates the Data Preview layout to match the Build tab, with tighter header spacing, rounded borders, improved background color, and consistent padding across the Builder.

• Copilot Data Quality Tests on Columns: When asked, Copilot can create data quality tests on single columns (for example, not null or unique checks) using the same test types you configure on Nodes.

• Copilot Context for Large Graphs: Copilot can now handle large graphs improving Copilots context window.

• SQL Node Support on Databricks: You can create, edit, validate, and deploy SQL Nodes in Databricks projects.

Packages

BigQuery

• BigQuery Base Node Types - Advanced Deploy 1.1.0: UUID visibility is driven from Node definition. Deploy metadata handles SET NOT NULL on BigQuery. Cluster keys compare by internal ID on redeploy so matches stay stable. Join metadata resolves correctly when macros use {% %} Jinja blocks.

Snowflake

• Base Node Types 1.6.0 : Adds the SQL Stage Node type.

• External Data Package 2.1.3: Copy Into, Snowpipe, and Inferschema parse input correctly when ESCAPE_UNENCLOSED_FIELD = NONE.

• Streams and Tasks 2.6.0: Supports task notification integrations, execute as user, suspend after failures, auto-retry, overlapping task runs, richer schedule and config fields, task comments, and serverless warehouse size limits for tasks.

Bug Fixes

• Consistent Graph Layout After Reload: Reloading the graph from the menu keeps the same layout as the initial load, with source Nodes aligned on the left as expected.

• System Columns After Node Type Switch: When you switch Node types through re-initialization, the mapping grid drops the old type’s system columns and only shows columns for the new type.

• SQL Node Columns Grid : Selected expressions, including aggregates, appear in the Columns grid even when you omit an AS alias. The grid fills in default column names where the database would.

• SQL Editor When Switching Nodes: Fixed intermittent Model is disposed errors from Monaco when switching between Nodes in the SQL editor.

• Presync Plan Scrolling: The presync deploy plan panel scrolls when the diff list is long, so rows at the bottom stay visible.

• Copilot and Object Descriptions: Copilot can read table, view, and column descriptions from the environment, including descriptions that come from attachments or that propagate between Nodes.