For Databricks

AI analytics for Databricks

Last updated

Short answer

exelens connects to Databricks SQL with an OAuth service principal that has SELECT on the views you import and permission to use one small SQL warehouse. It answers questions in plain language with an AI model on your own key, and your data stays in Databricks.

How exelens connects to Databricks
Detailexelens on Databricks
Preferred sign-inOAuth machine-to-machine service principal (a personal access token is the fallback)
What exelens can readUSE CATALOG, USE SCHEMA and SELECT on each imported view in Unity Catalog
ComputeOne small serverless SQL warehouse, with CAN USE granted to the principal
NetworkA workspace IP access list that allows the exelens egress IPs
What you provideWorkspace host, HTTP path, catalog, client ID and secret
Where the data livesIn Databricks. Rows are loaded temporarily only while a question is answered

How it works on Databricks

  1. Create the service principal. In the account console add exelens-reader, copy its client ID and generate an OAuth secret.
  2. Grant the minimum. The setup script grants USE CATALOG, USE SCHEMA and SELECT on each view, and CAN USE on one small serverless SQL warehouse.
  3. Allow the network. Add the exelens egress addresses to the workspace IP access list.
  4. Paste the details. Host (no https://), HTTP path, catalog and the credentials, then Test connection.

Governance stays with Unity Catalog

exelens only sees what Unity Catalog lets the principal see. Revoke a grant and exelens can no longer read that view. For how this compares with Genie, read exelens vs Databricks Genie.

Book a demo to connect your workspace with us.

Frequently asked questions

Why a service principal and not a personal token?
A token belongs to a person and expires. A service principal is meant for applications and can be limited to the exact views you grant.
Does exelens need access to my tables?
No. Grant SELECT on views only. exelens never imports tables.
Can I keep using Databricks Genie?
Yes. They are independent. exelens uses your own AI key rather than Databricks-managed models.

See exelens on your Databricks

A short walkthrough with the founder: connect read-only, ask a real question, pin the answer.