Skip to main content
Databricks is a unified data lakehouse platform that provides data engineering, data science, machine learning, and analytics capabilities. It exposes a SQL Statement Execution REST API for querying data via SQL over HTTP, Unity Catalog APIs for metadata discovery, and workspace management APIs for compute, jobs, pipelines, identity, and audit operations.
Connect Parable to Databricks using a service principal and the OAuth 2.0 client credentials flow. Parable uses the workspace REST APIs for the metadata and identity data streams. It uses the SQL Statement Execution API for the user-activity data streams (audit_logs, query_history) against Unity Catalog system tables.This integration uses OAuth 2.0 Client Credentials flow for server-to-server authentication.

How It Works

Parable exchanges the Client ID and Client Secret for a short-lived access token and gets a new token when it expires.

Token Request

cURL
Python

Using the Access Token

Info: Parable automatically handles token refresh, so you don’t need to manage token expiration manually.

Metadata & identity

Unity Catalog catalogs, schemas, tables; SCIM users and groups

User activity

Audit events and SQL query history from system.access.audit and system.query.history

Data streams

This Provider Plugin defines 15 data streams.

Source permissions

Databricks shows a Unity Catalog object to its owner and to the principals that hold a grant on it. A job, a pipeline, a cluster and a SQL warehouse open to the principals on their access control list, and the creator is the owner by default. When source permissions apply, Parable follows the owners and the actors. It does not read grants or access control lists yet (Source permissions):Parable matches a member of your Workspace to their Databricks user by the user’s userName, which is the user’s email. Only a user whose active is true reads through that account. An inactive user, or a user whose active value Databricks does not return, reads nothing, and their group memberships count for nothing. A user, a group or a membership that a later sync does not return is marked deleted, so its access ends at that sync. A service principal is never a reader, so a query it ran opens to All data access only.A principal that holds only a grant, such as SELECT or CAN VIEW, reads nothing through it in Parable yet. Workspace admins read every workspace object in Databricks. To let a role in your Workspace read these streams in Parable, give the role All data access, or add a Provider Policy rule that gives the role All rows on each stream.