Databricks clusters must use Databricks Runtime 13.1 or above and shared or single-user access mode.
SQL warehouses must be Pro or Serverless.
To set up connectivity for data federation, the account admin must have a Workspace admin role.
The Workspace admin must complete these setup tasks.
ClientID/ClientSecret authentication is only supported using Azure Databricks-managed Service Principals. Microsoft Entra ID-managed principals are not supported.
Note
In Data Cloud, go to Data Cloud Setup.
Under Configuration, select Connectors.
Click New.
Under Source, select Databricks and click Next.
Enter a connection name and connection API name.
Select one of the three authentication methods.
Select Username & Password. Contact your Databricks administrator to obtain the Databricks username and password.
Select Client ID & Client Secret. Contact your Databricks administrator to obtain the client ID and secret.
Select Identity Provider Based and complete the setup in the next step.
In the Connection URL field, enter the server hostname of the SQL warehouse along with the port number. For example, adb-8903155206260665.5.azuredatabricks.net:443.
In the Http path field, enter the HTTP path value of the SQL warehouse in Databricks.
To review your configuration, click Test Connection.