Skip to Content
SourcesDatabricksOverview

Databricks

Source (Direct Connection) — Vendo reads directly from your Databricks workspace using SQL Warehouse endpoints. No data is copied.

What Vendo Accesses

Vendo connects to your Databricks SQL Warehouse and queries Unity Catalog tables directly for use in attribution, segments, and data models.

Supported Data

DataDescription
Unity Catalog TablesAny table registered in Unity Catalog
Delta TablesFull Delta Lake support including time travel
ViewsSQL views and materialized views
External TablesTables backed by external storage (S3, ADLS, GCS)

Connection Behavior

BehaviorDescription
Direct QueryNo data import — Vendo queries your tables in place
SQL WarehouseConnects via Databricks SQL Warehouse HTTP endpoint
Token AuthUses personal access token or service principal
Schema DiscoveryAuto-discovers catalogs, schemas, and tables

Platform Details

SettingValue
Auth MethodPersonal access token or service principal
Connection TypeDirect connection (no sync)
ProtocolDatabricks SQL Warehouse REST API
ComputeQueries run on your SQL Warehouse

Setup

  1. Navigate to App Connections > Add App Connection
  2. Select Databricks from the data warehouse category
  3. Enter your Databricks workspace URL (e.g., https://your-workspace.cloud.databricks.com)
  4. Enter your SQL Warehouse HTTP path
  5. Provide a personal access token or service principal credentials
  6. Click Save — Vendo will discover your catalogs and tables

Permissions Required

PermissionPurpose
USE CATALOGAccess catalog metadata
USE SCHEMAAccess schema metadata
SELECTRead table data
SQL Warehouse accessExecute queries

Troubleshooting

  • Connection timeout — Ensure your SQL Warehouse is running (serverless warehouses auto-start)
  • Tables not appearing — Check Unity Catalog permissions for the service principal
  • Slow queries — Queries run on your SQL Warehouse compute. Scale up if needed
Last updated on
DestinationOverview