Connect KPIs to Databricks

Learn how to power KPIs in BSC Designer with data from Databricks, enabling real-time updates and monitoring of performance indicators using data stored in your data lakes.

What is Databricks?

Databricks is a cloud-based analytics and data engineering platform. It enables teams to store, clean, process, and analyze large volumes of structured and unstructured data, as well as collaboratively develop and deploy machine learning models.

Set Up a Connection to a Databricks Warehouse

Follow these steps to connect to your Databricks warehouse and access its data.

Preparing connection details

  1. Navigate to “SQL Warehouses” in the main menu.
  2. Click on the “Serverless Starter Warehouse”.
  3. Switch to the “Connection details” tab.

JDBC settings of the Databricks data source

 

From the JDBC URL:

  • Copy the host (e.g., dbc-41255397-fa00.cloud.databricks.com).
  • Copy the catalog (e.g., default;transportMode=http;ssl=1;AuthMech=3;httpPath=/sql/1.0/warehouses/32649d1d95fcfd77).

Create an Access Token

To create an access token:

  1. Click on the user icon in the top-right corner.
  2. Select “Settings”.
  3. Under the User section, go to Developer > Access tokens > Manage.
  4. Create a new access token.

Configure the Data Source in BSC Designer

  1. Log in to your administrator account.
  2. Navigate to Settings > Integrations and click “Add” in the Datasource section.
  3. Enter a name for the new data source.
  4. Select “Databricks” as the Database type.
  5. Paste the host from the previous step into the Server field.
  6. Paste the catalog into the Catalog field.
  7. Paste the generated token into the Password field.
  8. Keep “token” unchanged in the Login field.

Connection settings for Databricks in BSC Designer

Querying Data for a KPI

You can now create queries to access data from your Databricks tables.

  • Use the supported parameters to customize your query based on the selected indicator and data in the internal calendar.
Cite as: BSC Designer, "Connect KPIs to Databricks," BSC Designer, October 5, 2025, https://bscdesigner.com/connect-kpis-to-databricks.htm.