Databricks
Databricks
Setup Guide
Follow these steps to connect Databricks to your CData Connect account:
-
Open the Connections page of the CData Connect dashboard.
-
Click + Add Connection in the upper-right corner.
-
Type Databricks into the search field, then click the data source name.
-
On the Basic Settings tab of the new connection, enter a connection name or keep the default name.
-
Select the Authentication method, then proceed to the relevant section and follow those instructions.
Authentication Methods
PersonalAccessToken
-
Enter your Databricks access token into the Token field. To obtain the token, navigate to the User Settings page of your Databricks instance and open the Access Tokens tab.
-
Enter the Databricks Catalog if you are using Databricks Unity Catalog. Otherwise, leave the default value.
-
Enter the HTTP Path component of the URL endpoint.
-
Enter the Server URL or IP address of the Databricks instance .
-
(Optional) Enter the name of the Database to connect to.
-
In Databricks, add the CData Connect static IP addresses to your connection whitelist.
-
At the top of the CData Connect Add Databricks Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
Basic
-
Enter the User name for Databricks.
-
Enter your Databricks access token into the Token field. To obtain the token, navigate to the User Settings page of your Databricks instance and open the Access Tokens tab.
-
Enter the Databricks Catalog if you are using Databricks Unity Catalog. Otherwise, leave the default value.
-
Enter the HTTP Path component of the URL endpoint.
-
Enter the Server URL or IP address of the Databricks instance .
-
(Optional) Enter the name of the Database to connect to.
AzureServicePrincipal
-
Enter the Azure Tenant Id of your Azure application.
-
Enter the Azure Client Id for your Azure application.
-
Enter the Azure Client Secret corresponding to the above Azure Client Id.
-
Enter the Azure Subscription Id of your Microsoft Azure Databricks Service Workspace.
-
Enter the Azure Resource Group name of your Microsoft Azure Databricks Service Workspace.
-
Enter the Azure Workspace of your Microsoft Azure Databricks Service Workspace.
-
Enter the Catalog if you are using Databricks Unity Catalog. Otherwise, leave the default value.
-
Enter the HTTP Path component of the URL endpoint.
-
Enter the Server URL or IP address of the Databricks instance .
-
(Optional) Enter the name of the Database to connect to.
-
In Databricks, add the CData Connect static IP addresses to your connection whitelist.
-
At the top of the CData Connect Add Databricks Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
AzureAD
-
Enter the Catalog if you are using Databricks Unity Catalog. Otherwise, leave the default value.
-
Enter the HTTP Path component of the URL endpoint.
-
Enter the Server URL or IP address of the Databricks instance .
-
(Optional) Enter the name of the Database to connect to.
-
Click Sign in to connect securely through OAuth. This action opens the Databricks sign-in page in a new tab.
-
In Databricks, add the CData Connect static IP addresses to your connection whitelist.
-
At the top of the CData Connect Add Databricks Connection page, click Save & Test.
-
If the connection test succeeds, a message indicates that your connection has been created.
-
If the connection test fails, ensure that you entered your login information correctly with no stray spaces or other characters. Then, try again.
-
More Information
For more information about interactions between CData Connect and Databricks, see this information page.