Databricks
Source + Destination — Vendo connects to your Databricks SQL warehouses to query Delta Lake tables directly. No data is copied or moved — everything runs in your lakehouse.
Key Benefits
- Zero-Copy Access — Query Delta Lake tables directly. Data never leaves your lakehouse.
- SQL Warehouse Endpoints — Fast, serverless query execution via Databricks SQL.
- Unity Catalog — Full support for catalog and schema-level access control.
- Simple Authentication — Personal access tokens for quick setup.
How It Works
Vendo connects to the Databricks SQL Statement Execution REST API. When you run a model, build an audience, or query data, Vendo submits SQL to your SQL warehouse endpoint and retrieves results. No JDBC drivers or network tunnels needed.
No data is stored by Vendo. Query results are used in-flight and discarded after processing.
Authentication
| Method | Description |
|---|---|
| Personal Access Token | Generated from Databricks User Settings. Simplest setup. |
What You Need
- A Databricks workspace with a SQL warehouse
- A personal access token
- The workspace URL and SQL warehouse HTTP path
- Optional: Unity Catalog name and schema
Platform Details
| Setting | Value |
|---|---|
| Connection Method | Databricks SQL Statement Execution REST API |
| Query Execution | Async (execute + poll if needed) |
| Authentication | Personal access token |
| Data Storage | None — zero-copy |
| Catalog Support | Unity Catalog |
What to Expect After Setup
- Connection Verified — Vendo tests connectivity to your SQL warehouse
- Schema Browser — Browse catalogs, schemas, and tables in the Vendo UI
- Query Ready — Run SQL queries, build models, and create audiences
- No Sync Needed — Queries execute directly against your lakehouse
Related Guides
Last updated on