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.
| Detail | exelens on Databricks |
|---|---|
| Preferred sign-in | OAuth machine-to-machine service principal (a personal access token is the fallback) |
| What exelens can read | USE CATALOG, USE SCHEMA and SELECT on each imported view in Unity Catalog |
| Compute | One small serverless SQL warehouse, with CAN USE granted to the principal |
| Network | A workspace IP access list that allows the exelens egress IPs |
| What you provide | Workspace host, HTTP path, catalog, client ID and secret |
| Where the data lives | In Databricks. Rows are loaded temporarily only while a question is answered |
How it works on Databricks
- Create the service principal. In the account console add
exelens-reader, copy its client ID and generate an OAuth secret. - Grant the minimum. The setup script grants
USE CATALOG,USE SCHEMAandSELECTon each view, andCAN USEon one small serverless SQL warehouse. - Allow the network. Add the exelens egress addresses to the workspace IP access list.
- 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.