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

SQL Server connector supports SCD type 2

The Microsoft SQL Server connector in Lakeflow Connect now supports SCD type 2.

Update Open docs ↗release note ↗
What it does

The Microsoft SQL Server connector in Lakeflow Connect now supports SCD type 2. This setting, known as history tracking or slowly changing dimensions (SCD), determines how to handle changes in your data over time. With history tracking off (SCD type 1), outdated records are overwritten as they're updated and deleted in the source.

Why it matters

Reduces operational overhead and unlocks new capabilities for data teams on Databricks.

Key capabilities
table: sourceurl: sourceschema:
table: sourceurl: sourceschema: destinationcatalog: destinationschema…
table: sourceschema: sourcetable:
table: sourceschema: sourcetable: destinationcatalog: destinationschema…
table: sourcecatalog: sourceschema:
table: sourcecatalog: sourceschema: sourcetable: destinationcatalog…
report: sourceurl: destinationcatalog:
report: sourceurl: destinationcatalog: destinationschema:
Architecture
Databricks Platform → Platform
In short

The Microsoft SQL Server connector in Lakeflow Connect now supports SCD type 2. This setting, known as history tracking or slowly changing dimensions (SCD), determines how to handle changes in your data over time.

Read the full documentation ↗
Key takeaway
The Microsoft SQL Server connector in Lakeflow Connect now supports SCD type 2.
2025-09-01-sql-server-connector-supports-scd-type-2 Generated by the Databricks Updates Agent · browse all updates