SQL Server connector reference

2025-05-14

Important

The Microsoft SQL Server connector is in Public Preview.

This page contains reference material for the SQL Server connector in Databricks Lakeflow Connect.

Automatic data transformations

Databricks automatically transforms the following SQL Server data types to Delta-compatible data types:

SQL Server type	Delta type
`BIT`	`BOOLEAN`
`TINYINT`	`SMALLINT`
`SMALLINT`	`SMALLINT`
`INT`	`INT`
`BIGINT`	`BIGINT`
`DECIMAL(p,s)`	`DECIMAL(p,s)`
`NUMERIC(p,s)`	`DECIMAL(p,s)`
`SMALLMONEY`	`DECIMAL(10,4)`
`MONEY`	`DECIMAL(19,4)`
`FLOAT`	`DOUBLE`
`REAL`	`FLOAT`
`DATE`	`DATE`
`TIME`	`STRING`
`SMALLDATETIME`	`TIMESTAMP`
`DATETIME`	`TIMESTAMP`
`DATETIME2`	`TIMESTAMP`
`DATETIMEOFFSET`	`TIMESTAMP`
`CHAR`	`STRING`
`VARCHAR`	`STRING`
`VARCHAR(MAX)`	`STRING`
`NCHAR`	`STRING`
`NVARCHAR`	`STRING`
`NVARCHAR(MAX)`	`STRING`
`TEXT`	`STRING`