Microsoft SQL Server connector

Important

LakeFlow Connect is in gated Public Preview. To participate in the preview, contact your Databricks account team.

The Microsoft SQL Server (SQL Server) connector supports the following:

  • Azure SQL Database
  • Amazon RDS for SQL Server

Frequently asked questions

This section answers frequently asked questions about the SQL Server connector.

How does Databricks connect to SQL Server?

Databricks connects to SQL Server using transport layer security (TLS). Credentials are stored securely inside Unity Catalog and can only be retrieved if the user running the ingestion flow has appropriate permissions. You should create a separate user in SQL Server for ingesting data, and if there are databases or tables you do not want to be available, you can use built-in SQL Server permissions to ensure that the ingestion user does not have access to those entities.

Is this a one-way connection?

Yes. Reverse ETL is not supported.

If the pipeline fails, does ingestion resume without data loss?

Yes. Databricks keeps track of what we’ve extracted from the source and what we’ve applied in the destination. If anything happens, Databricks can resume at that point.