← All updates Databricks Update One-Pager Navy version
databricks Platform · Updated Jul 23, 2025

Selectively replace data with INSERT REPLACE ON (Public Preview)

INSERT REPLACE ON is now in Public Preview for Databricks Runtime 17.1.

Public Preview Open docs ↗release note ↗
What it does

INSERT REPLACE ON is now in Public Preview for Databricks Runtime 17.1. This SQL command replaces part of the table with the result of a query. Rows are replaced when they match the user defined condition.

Why it matters

Parameters common table expression Common table expressions (CTE) are one or more named queries which can be reused multiple times within the main query block to avoid repeated computations or to improve readability of complex, nested queries.

Key capabilities
Without a partitionspec the table
Without a partitionspec the table is truncated before inserting the first row.
Otherwise, all partitions matching the
Otherwise, all partitions matching the partitionspec are truncated before inserting the first row.
If this command omits a
If this command omits a column, Databricks SQL assigns the corresponding default value instead.
If the target table schema
If the target table schema does not define any default value for the inserted column, Databricks SQL assigns NULL if the column…
Architecture
Databricks Platform → Platform
In short

INSERT REPLACE ON is now in Public Preview for Databricks Runtime 17.1. This SQL command replaces part of the table with the result of a query.

Read the full documentation ↗
Key takeaway
INSERT REPLACE ON is now in Public Preview for Databricks Runtime 17.1.
2025-07-23-selectively-replace-data-with-insert-replace-on-public-preview Generated by the Databricks Updates Agent · browse all updates