Databricks Setup Instructions

Prerequisites

• A Databricks workspace with a SQL warehouse (Classic or Serverless)
• Admin or workspace access to generate a personal access token
• The workspace URL and SQL warehouse HTTP path

Step 1: Find Your Workspace URL

Your workspace URL is in your browser address bar when logged into Databricks:

https://dbc-xxxxxxxx-xxxx.cloud.databricks.com

Step 2: Find the SQL Warehouse HTTP Path

1. Go to SQL Warehouses in the Databricks sidebar
2. Click on your SQL warehouse
3. Go to the Connection Details tab
4. Copy the HTTP Path value (looks like /sql/1.0/warehouses/xxxxxxxxxxxxxxxx)

Step 3: Generate a Personal Access Token

1. Click your username in the top-right corner
2. Go to User Settings > Developer > Access Tokens
3. Click Generate New Token
4. Set a description (e.g. “Vendo Integration”) and expiration
5. Copy the token — it starts with dapi

Step 4: Configure in Vendo

1. Go to Sources > Add Source > Databricks
2. Enter your credentials:

3. Click Test Connection
4. Once verified, click Save

Permissions

The token owner needs at minimum:

• USE CATALOG on the target catalog
• USE SCHEMA on the target schema
• SELECT on the target tables

For destination (write) access:

• INSERT and MODIFY on target tables

Troubleshooting

Connection Failed

• Verify the workspace URL includes https://
• Check that the SQL warehouse is running (not stopped)
• Ensure the HTTP path is from the correct SQL warehouse

Access Denied

• Verify the token hasn’t expired
• Check Unity Catalog permissions: SHOW GRANTS ON SCHEMA <schema>
• Ensure the SQL warehouse allows queries from the token owner

SQL Warehouse Stopped

• Databricks SQL warehouses can auto-stop after inactivity
• The warehouse will auto-start when Vendo sends a query (may add latency to the first query)