Databricks

Databricks Access Setup

Step 1: Create a Service Principal or Access Token

Create a dedicated service principal in your Databricks workspace that Pavo will use to access your data.

Option	Best For	Security Level
Service Principal (Recommended)	Production environments	High – can be scoped to specific resources
Personal Access Token (PAT)	Quick setup / testing	Medium – tied to a user account

To create a Service Principal: Recommended

Go to your Databricks Account Console → User Management → Service Principals
Click Add Service Principal
Name it: pavo-integration (or your preferred name)
Generate an OAuth secret
Upload the client Id and secret.

To create a PAT (alternative):

Go to User Settings → Developer → Access Tokens
Click Generate New Token
Name it: pavo-integration
Set expiration: 90 days (recommended) or as per your security policy

Step 2: Grant Databricks Permissions

The service principal/token needs the following permissions:

Workspace Access

Permission	Purpose
USE CATALOG on relevant catalogs	Access catalog metadata
USE SCHEMA on relevant schemas	Access schema metadata
SELECT on relevant tables/views	Read table data and metadata
USAGE on SQL Warehouse	Execute queries

SQL commands to grant access:

-- Grant catalog access
GRANT USE CATALOG ON CATALOG <catalog_name> TO `pavo-integration`;

-- Grant schema access
GRANT USE SCHEMA ON SCHEMA <catalog_name>.<schema_name> TO `pavo-integration`;

-- Grant read access to all tables in a schema
GRANT SELECT ON SCHEMA <catalog_name>.<schema_name> TO `pavo-integration`;

-- Grant access to query history
GRANT USE CATALOG ON CATALOG system TO `pavo-integration`;
GRANT USE SCHEMA ON SCHEMA system.access TO `pavo-integration`;
GRANT SELECT ON system.access.audit TO `pavo-integration`;

Step 3: Create Analysis Schema

This step is only required if you want Pavo to run analysis queries that create temporary tables.

Create a dedicated schema for Pavo’s temporary analysis tables:

CREATE SCHEMA IF NOT EXISTS <catalog_name>.pavo_analysis;

Grant write permissions:

GRANT ALL PRIVILEGES ON SCHEMA <catalog_name>.pavo_analysis TO `pavo-integration`;

Step 4: Add the Connector in Pavo

Navigate to Settings → Data sources and click Add source.

Select Databricks from the connector list.

Enter the connection details:

Field	Example	Required
Workspace URL	`https://your-workspace.cloud.databricks.com`	Yes
HTTP Path	`/sql/1.0/warehouses/abc123def456`	Yes
Access Token / OAuth Secret	`dapi1234567890...`	Yes
Catalog(s) to access	`main, analytics`	Yes
Schema(s) to access	`sales, marketing, finance`	Yes
Analysis schema (if created)	`main.pavo_analysis`	Optional

To find your HTTP Path: go to SQL → SQL Warehouses, click your warehouse → Connection details tab, and copy the HTTP Path. Click Connect. Pavo will verify connectivity and begin syncing.

Get started

System Knowledge

Agent Studio

Engagement models

Pricing

Connectors

Deployment

Security

Databricks Access Setup

Step 1: Create a Service Principal or Access Token

Step 2: Grant Databricks Permissions

Workspace Access

Step 3: Create Analysis Schema

Step 4: Add the Connector in Pavo

​Databricks Access Setup

​Step 1: Create a Service Principal or Access Token

​Step 2: Grant Databricks Permissions

​Workspace Access

​Step 3: Create Analysis Schema

​Step 4: Add the Connector in Pavo

Databricks Access Setup

Step 1: Create a Service Principal or Access Token

Step 2: Grant Databricks Permissions

Workspace Access

Step 3: Create Analysis Schema

Step 4: Add the Connector in Pavo