Connecting to Databricks
  • 18 May 2022
  • 2 Minutes to read
  • Contributors
  • Dark
    Light
  • PDF

Connecting to Databricks

  • Dark
    Light
  • PDF

This topic describes how to import data into a Databricks cluster, and how to use Live Connect.

Sisense enables easy and quick access to databases, tables and views contained within Databricks.

To connect to your Databricks cluster, you need to provide a connection string that identifies the Databricks cluster you are connecting to, and that database’s credentials. To create a connection string, see Databricks JDBC drivers.

You can then import your data into a Sisense ElastiCube or connect your data to a Sisense Live model.

Importing Into a Sisense ElastiCube

To import Databricks data:

  1. In the Data page, open an ElastiCube or click  to create a new ElastiCube.
  2. In the Model Editor, click ; the Add Data dialog box is displayed.
  3. In the Add Data dialog box, select Databricks.

    The Connector page appears.


  4. In Connection String, enter your connection string to your Databricks cluster. To retrieve the connection string, see Retrieve the JDBC Connection String.
    1. In the User Name field, enter "token" as the user name.
    2. In the Password field, enter your Databricks personal access token as the password. See Generate a Personal Access Token.
    3. Click Next . All tables and views associated with Databricks are displayed.
  5. From the Tables list, select the relevant table or view you want to work with. You can click next to the relevant table or view to see a preview of the data inside it. When you select the table or view, a new option is displayed at the bottom of the list, Add Import Query.
  6. (Optional) Click + to customize the data you want to import with SQL. See Importing Data with Custom Queriesfor more information.
  7. After you have selected all the relevant tables, click Done. The tables are added to your schema.


Connecting Data to a Sisense Live Model To import Databricks data:
  1. In the Data page, open a live model or click 8-5livebutton1.png to create a new live model.
  2. In the Model Editor, click8-5databutton4.png; the Add Data dialog box is displayed.
  3. In the Add Data dialog box, select Databricks.


    The Connector page appears.


  4. In Connection String, enter your connection string to your Databricks cluster. To retrieve the connection string, see Retrieve the JDBC Connection String.
    1. In the User Name field, enter "token" as the user name.
    2. In the Password field, enter your Databricks personal access token as the password. See Generate a Personal Access Token.
    3. Click Next . All tables and views associated with Databricks are displayed.
  5. Click Next. All tables and views associated with Databricks are displayed.
  6. From the Tables list, select the relevant table or view you want to work with. You can click next to the relevant table or view to see a preview of the data inside it. When you select the table or view, a new option is displayed at the bottom of the list, Add Import Query.
  7. Click Done. The tables are added to your schema.

Was this article helpful?