Skip to main content

Connect Databricks

Holori can import your Databricks billing and usage data directly from a Unity Catalog-enabled workspace. This page explains step by step how to set up the connection.

Before you start, make sure you have admin access to a Databricks workspace with Unity Catalog enabled. You'll need it to create a service principal and a SQL warehouse for Holori.

Step 1: Collect your workspace credentials​

  1. Log in to the Databricks console.
  2. In the top right corner, click your avatar and copy your Account ID.
  3. Click Workspaces and select a Unity Catalog-enabled workspace.
  4. Copy the Workspace URL, for example adb-123456789.1.azuredatabricks.net.

In Holori, enter:

  • Workspace URL: paste the URL you copied, without the https:// prefix. Required.
  • Account name: an optional friendly label to help you identify this connection later.

Step 2: Create a service principal​

  1. In your workspace, go to Settings, then Identity and access, then Service principals.
  2. Click Add service principal, then Add new. Name it holori-billing-sp and click Add.
  3. Open the service principal, go to the Secrets tab, and click Generate secret.
  4. Set the lifetime to 730 days and click Generate.
  5. Copy the Client ID and Secret.

In Holori, enter:

  • Client ID: required.
  • Client secret: required.
caution

The secret is only shown once. Copy it into Holori before leaving this page, you won't be able to retrieve it again.

Step 3: Create a SQL warehouse​

  1. In the left menu, go to SQL, then SQL Warehouses.
  2. Click Create SQL warehouse. Name it holori-billing-warehouse, set the size to 2X-Small, and the type to Serverless.
  3. Under Permissions, add the holori-billing-sp service principal with Can Use permission.
  4. Copy the Warehouse ID from the warehouse details page.

In Holori, paste your SQL Warehouse ID.

info

This warehouse incurs a small cost, about $84 per month, while the connector is running.

Step 4: Connect your account​

Click Save and verify at the bottom of the page on Holori App.

Holori validates your credentials and starts importing your data, this takes a few moments.

Once validated, you'll see a confirmation: "Databricks account connected. Data import has started."

If the connection fails, check that the workspace URL, client ID, client secret, and warehouse ID were copied correctly, and that the holori-billing-sp service principal has Can Use permission on the warehouse.