Data Sources
Warehouses
Databricks

Databricks

Connect Compass to your Databricks workspace to analyze data through natural language queries in Slack.

Setup Instructions

  • Sign in to your Databricks workspace
  • Navigate to User Settings → Developer → Access tokens
  • Generate a new personal access token
  • Note your workspace URL (e.g., https://<workspace>.cloud.databricks.com)
  • Identify the catalog(s) and schema(s) you want Compass to access

Required Databricks Permissions

  • USE CATALOG on catalog – Access catalog objects
  • USE SCHEMA on schema – Access schema objects
  • SELECT on tables – Query table data for analysis
  • CAN USE on the SQL warehouse or cluster referenced by your HTTP path (configure in the warehouse/cluster permissions)

Optional but recommended for discovery:

  • BROWSE on catalog/schema – List objects in the Compass UI

Example grants:

GRANT USE CATALOG ON CATALOG <catalog> TO `<user_or_group>`;
GRANT USE SCHEMA ON SCHEMA <catalog>.<schema> TO `<user_or_group>`;
GRANT SELECT ON ALL TABLES IN SCHEMA <catalog>.<schema> TO `<user_or_group>`;
GRANT BROWSE ON CATALOG <catalog> TO `<user_or_group>`;
GRANT BROWSE ON SCHEMA <catalog>.<schema> TO `<user_or_group>`;

Network Information

Connection Method: HTTPS over port 443

IP Addresses: 52.25.53.27, 44.242.128.111, 52.35.195.86

Connects to your Databricks workspace URL

Connecting to Compass

  1. Go to dagstercompass.com/login (opens in a new tab) or type !admin in your Compass Slack channel
  2. Click Add Connection → Databricks
  3. Enter your connection details:
    • Workspace URL
    • Personal Access Token
    • HTTP Path (from cluster/SQL warehouse settings)
    • Catalog name (optional)
    • Schema name (optional)
  4. Click Test Connection to verify
  5. Click Save to complete setup

Need Help?

AWS RedshiftPostgreSQL