Create a SQL Server connection

Create a SQL Server connection in Catalog Explorer to store authentication credentials for Lakeflow Connect ingestion. Any user with the USE CONNECTION privilege on the connection can then create SQL Server ingestion pipelines without needing direct access to the credentials.

Alternatively, admin users can create a connection and a pipeline at the same time in the data ingestion UI. See Create an ingestion pipeline.

For privilege requirements, see Connect to managed ingestion sources.

Prerequisites

Complete the source setup. Use the authentication details you obtain to create the connection.

Create a connection

1. In the Databricks workspace, click Catalog.
2. Click Connect, then click Connections.
3. Click the Create connection button.
4. Enter a unique Connection name.
5. For Connection type, select SQL Server.
6. For Host, specify the SQL Server domain name.
7. For User and Password, enter your SQL Server login credentials.
8. Click Create connection.

Next steps

Create an ingestion pipeline.