Databricks

Ensure Unity Catalog is active for the target workspace. Follow Databricks’ official documentation if it is not already enabled.

Pelanor can query any existing warehouse, but a small serverless warehouse with auto-stop is recommended for cost efficiency.

1. Open Account Console → Service principals.
2. Click Add Service principal, assign a clear name, then Generate Secret.
3. Save the Client ID and Secret—you will enter these in Pelanor.

1. In Account Console → Workspaces, add the Service Principal to the workspace with User permission.
2. Inside the workspace, open the warehouse → Permissions → grant Can Use.
3. Confirm the principal has the Databricks SQL access entitlement.

Run the following SQL (replace the placeholder with the Service Principal ID):

-- Compute schema
GRANT USE SCHEMA ON SCHEMA system.compute TO '<service_principal_id>';
GRANT SELECT ON TABLE system.compute.clusters TO '<service_principal_id>';

-- Billing schema
GRANT USE SCHEMA ON SCHEMA system.billing TO '<service_principal_id>';
GRANT SELECT ON TABLE system.billing.list_prices TO '<service_principal_id>';
GRANT SELECT ON TABLE system.billing.usage TO '<service_principal_id>';

-- Lakeflow schema
GRANT USE SCHEMA ON SCHEMA system.lakeflow TO '<service_principal_id>';
GRANT SELECT ON TABLE system.lakeflow.job_run_timeline TO '<service_principal_id>';
GRANT SELECT ON TABLE system.lakeflow.job_task_run_timeline TO '<service_principal_id>';
GRANT SELECT ON TABLE system.lakeflow.jobs TO '<service_principal_id>';