Skip to main content
Connect Supaboard to a Databricks workspace using a personal access token and cluster HTTP path.

Before you connect

Network access — Databricks workspaces are accessible over HTTPS (port 443). No special firewall rules are typically needed for cloud-hosted workspaces. If your workspace is behind a private network or VPN, ensure Supaboard’s egress IPs can reach it. The current IP list is shown inside the connector form under Whitelist IPs. Cluster requirements — The cluster referenced by your HTTP path must be running when Supaboard connects. Terminated or auto-terminated clusters will cause connection failures. Permissions — The user whose access token you use needs:
  • CAN ATTACH TO permission on the cluster
  • SELECT access on the target catalogs and schemas

Connection fields

FieldDefaultRequiredDescription
Display NameYesLabel shown in the Supaboard UI
TokenYesDatabricks personal access token (PAT)
HostnameYesDatabricks workspace URL (without https://)
Port443YesHTTPS port — do not change
HTTP PathYesCluster or SQL warehouse JDBC/ODBC HTTP path
CatalogdefaultNoUnity Catalog name; leave blank for the default catalog
SchemadefaultNoDefault schema for queries

Finding your connection details

Databricks Workspace

Personal access token (Token):
  1. In your Databricks workspace, click your username in the top-right corner.
  2. Go to Settings → Developer.
  3. Under Access tokens, click Manage.
  4. Click Generate new token, add a comment (e.g. supaboard), set a lifetime, and click Generate.
  5. Copy the token — it is only shown once.
Documentation: Databricks personal access tokens Hostname: Your hostname is the workspace URL without https://. It looks like:
adb-1234567890123456.7.azuredatabricks.net
or for AWS:
dbc-xxxxxxxx-xxxx.cloud.databricks.com
Find it in your browser’s address bar when logged into Databricks. HTTP Path: The HTTP Path identifies a specific cluster or SQL warehouse. For a cluster:
  1. Go to Compute in the sidebar.
  2. Click on your cluster name.
  3. Scroll to Advanced options and click the JDBC/ODBC tab.
  4. Copy the HTTP path value (format: /sql/1.0/endpoints/xxxxxxxxxxxxxxxx or /sql/protocolv1/o/...).
For a SQL warehouse:
  1. Go to SQL Warehouses in the sidebar.
  2. Click on your warehouse.
  3. Go to the Connection details tab.
  4. Copy the HTTP path.
SQL warehouses are recommended over interactive clusters for BI tools — they are purpose-built for query workloads and auto-scale automatically.
Documentation: JDBC/ODBC connection details · SQL warehouses overview

Recommended database user permissions

In Unity Catalog, grant the token owner the following privileges:
-- Grant access to a specific catalog
GRANT USE CATALOG ON CATALOG your_catalog TO `user@example.com`;

-- Grant access to a specific schema
GRANT USE SCHEMA ON SCHEMA your_catalog.your_schema TO `user@example.com`;

-- Grant SELECT on tables
GRANT SELECT ON TABLE your_catalog.your_schema.your_table TO `user@example.com`;

-- Or grant SELECT on all tables in a schema
GRANT SELECT ON SCHEMA your_catalog.your_schema TO `user@example.com`;
For legacy (non-Unity Catalog) workspaces, ensure the user has the data_access group membership or equivalent.

Troubleshooting

ErrorLikely causeFix
403 ForbiddenInvalid or expired access tokenGenerate a new PAT in Settings → Developer → Access tokens
Cluster not foundCluster terminated or HTTP path is wrongStart the cluster; verify the HTTP path in Compute → JDBC/ODBC tab
PERMISSION_DENIEDUser lacks access to catalog or schemaGrant USE CATALOG, USE SCHEMA, and SELECT privileges
Connection timeoutWorkspace behind private networkEnsure Supaboard egress IPs can reach the workspace hostname on port 443
Invalid hostnameHostname includes https://Remove the https:// prefix from the Hostname field
Cluster auto-terminatingCluster shuts down during schema discoveryIncrease the auto-termination timeout or switch to a SQL warehouse
Last modified on March 11, 2026