Articles in this section

Set up a connection to Databricks

Databricks is a unified data analytics platform that enables organizations to process, analyze, and visualize big data.

Set up a connection

After you start the connection, configure it in the Create connection panel and complete all of the required * authentication settings: 

Setting

Instructions

Name your connection * 

Enter a clear and distinguishable name.

Throughout integrator.io imports and exports, you will have the option to choose this new connection. A unique identifier will prove helpful later when selecting it from a list of the connections in your account.

API type * 

Choose your Databricks account API type:

  • Account: Manage account-level assets such as workspaces, users, groups, and service principals for centralized administration across multiple workspaces.

  • Workspace: Interact with objects inside a specific workspace, including notebooks, clusters, jobs, and DBFS to build, deploy, and manage data workflows within a workspace.

Account ID * 

Enter your Databricks account ID. 

How to retrieve the account ID 

API version (if API type is Account)

Select your Databricks account API type (2.02.1, or 2.2).

Domain * (if API type is Workspace)

Enter your Databricks account domain. For example, if your Databricks account URL is http://adb-35275.0.azuredatabricks.net/, then adb-35275.0.azuredatabricks.net is the valid domain name.

OAuth 2.0 client * 

Select the OAuth 2.0 client that stores the client ID and client secret provided to you by Databricks.

How to retrieve the client ID and client secret

To add an OAuth 2.0 client and configure your credentials, click the plus (+) button. Click the edit (pencil.svg) button to modify a selected OAuth 2.0 client. For more information, see Create an OAuth 2.0 iClient resource

Scopes  

Scopes are OAuth 2.0 permissions that Databricks defines to limit access to your account.

How to configure scopes

Note

This connector documentation describes only the settings shown for the Simple view. For the corresponding HTTP settings, see basic and OAuth universal connector documentation.

How to retrieve the account ID

  1. Sign in to your Databricks account.

  2. Navigate to Profile avatar > My Account

  3. Copy the Account ID.

How to retrieve the client ID and client secret

  1. Sign in to your Databricks account.

  2. Navigate to SettingsApp connections.

  3. Click Add connection.

  4. Enter an Application name.

  5. Enter the Celigo integrator.io Redirect URL.

  6. Check the required AccessScopes.

  7. Check Generate a client secret.

  8. Click Add.

  9. Copy the Client ID.

  10. Copy the Client secret.

How to configure scopes

  1. Click Scope.

  2. To access all of the scopes in the API, click the » button.

    – or – 

    Check the scopes you want to add and click the > button.

  3. Click Save.