Databricks

​

1. Databricks Access Setup

​

Step 1: Create a Service Principal or Access Token

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

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

​

Step 2: Grant Databricks Permissions

​

Workspace 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

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

CREATE SCHEMA IF NOT EXISTS <catalog_name>.pavo_analysis;

2. Grant write permissions:

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

​

Step 4: Share Connection Details

1. Go to SQL → SQL Warehouses
2. Click on your warehouse → Connection details tab
3. Copy the HTTP Path

​

Questions

1. What all entities (catalogs, schemas, tables/views/objects) you are using?
2. What all entities (catalogs, schemas, tables/views/objects) are required for the POCs.