Skip to main content

SQL Server connector reference

Preview

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