Start free trial

Databricks KPI

Overview

Databricks is a unified data analytics and AI platform built on a lakehouse architecture that combines the reliability of a data warehouse with the scalability of a data lake. Organizations use Databricks SQL warehouses to store, process, and query large volumes of structured data.

The Databricks integration with Profit.co lets you connect a Databricks workspace and run SQL queries directly from a key result's check-in flow. This allows KPI values to be retrieved automatically from Databricks, keeping key result progress in Profit.co updated without manual data entry.

What This Integration Supports

With the Databricks integration, you can:

  • Connect Profit.co to a Databricks workspace using a Workspace URL, Client ID, and Client Secret
  • Run SQL queries against a selected Databricks warehouse to retrieve KPI values
  • Automate check-ins for key results using Increase KPI, Decrease KPI, or Control KPI types
  • Automatically populate the Current Value of a key result from your Databricks query results
  • Control the visibility of each Databricks connection

Prerequisites

  • An active Databricks workspace with a valid Workspace URL
  • A Databricks Client ID and Client Secret with access to the required SQL warehouse
  • Access to the Databricks SQL warehouse you intend to query
  • Super User access in Profit.co

Note: Only Super Users can configure this integration in Profit.co.

Configure Databricks in Profit.co

The following steps walk through connecting Databricks to Profit.co and using it to automate check-ins for a key result.

  1. Step 1

    Navigate to the Databricks connector in Profit.co to begin the setup.

    1. Navigate to Settings from the left navigation panel.
    1. Click Integrations and select the Business Level tab (Settings → Integrations → Business Level).
    1. Locate Databricks and click the Manage button.
    Step 1 screenshot 1
    1. Click the Connect to Databricks button.
    Step 1 screenshot 2

  2. Step 2

    Enter your connection details to establish the connection.

    1. In the pop-up, enter your Connection Name.
    1. Enter the Workspace URL, Client ID, and Client Secret. (For detailed instructions on configuring the Client ID and Client Secret, refer to the Service Principal Setup Guide.)
    1. Set the Visibility for the connection.
    1. Click Connect.
    Step 2 screenshot 1
    Step 2 screenshot 2

  3. Step 3

    Create a key result where you want to track a Databricks-based KPI.

    1. Create a Key Result in Profit.co for the metric you want to integrate with Databricks.
    1. Choose the required KPI type for the key result.
    1. Click Automate Check-in.
    1. Choose Databricks from the Connection drop-down.
    Step 3 screenshot

  4. Step 4

    Configure the query that retrieves the KPI value from Databricks.

    1. On the Connect to Databricks window, choose the Connection Name and Warehouse.
    1. Enter your Query and click Run Query to fetch the Current Value.
    1. Click Add.
    Step 4 screenshot 1
    Step 4 screenshot 2

  5. Step 5

    1. After the key result is created, complete the first check-in to confirm the connection.
    Step 5 screenshot 1
    Step 5 screenshot 2
    1. Click Check-in and complete the check-in to update the status value.
    1. You will be redirected to the review page. Click Check in to apply the progress to your key result.
    Step 5 screenshot 3
    Step 5 screenshot 4

    Note: Checking in redirects you to a review page, where you can confirm the value and update it to record progress toward your key result.

Summary

By connecting Databricks to Profit.co, you can automate KPI tracking directly within your key results. After authenticating with Databricks, you can run SQL queries against your warehouses to retrieve live metric values and use them to automate check-ins, keeping key result progress accurate and up to date without manual intervention.