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
- Navigate to “SQL Warehouses” in the main menu.
- Click on the “Serverless Starter Warehouse”.
- Switch to the “Connection details” tab.
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:
- Click on the user icon in the top-right corner.
- Select “Settings”.
- Under the User section, go to Developer > Access tokens > Manage.
- Create a new access token.
Configure the Data Source in BSC Designer
- Log in to your administrator account.
- Navigate to Settings > Integrations and click “Add” in the Datasource section.
- Enter a name for the new data source.
- Select “Databricks” as the Database type.
- Paste the host from the previous step into the Server field.
- Paste the catalog into the Catalog field.
- Paste the generated token into the Password field.
- Keep “token” unchanged in the Login field.
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.
BSC Designer is strategy execution software with the Balanced Scorecard at its core. It helps organizations turn strategic plans into a connected strategy architecture by aligning objectives, KPIs, initiatives, risks, and strategy maps in one place. Our strategy implementation system explains how to put strategy into practice, and the strategy execution workshop template helps teams apply it in internal strategy sessions.