Microsoft SQL Server connector
Preview
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.