How-to guideSourcesManaged setup
Managed Databricks Setup
Prepare a SQL warehouse, Unity Catalog grants, and a service credential for Vendo's managed Databricks source connection.
Last reviewed July 13, 2026
Databricks setup is Vendo-led. Prepare the workspace resources below, then coordinate the final credential and connection configuration with Vendo.
Before you start
- Select a SQL warehouse suitable for the expected workload.
- Identify the catalog, schemas, tables, and views Vendo needs.
- Create or select a service principal.
- Confirm your organization permits token or OAuth-based machine access for the chosen connection method.
Grant least privilege
The principal generally needs:
- Permission to use the selected SQL warehouse.
USE CATALOGon the approved catalog.USE SCHEMAon approved schemas.SELECTon approved tables and views.
Do not grant write privileges unless the scoped integration explicitly includes a write workflow.
Connect with Vendo
- Share the non-secret workspace URL, warehouse HTTP path, and catalog/schema names.
- Agree on service-principal authentication and rotation.
- Apply the reviewed Unity Catalog grants.
- Transfer the credential through the approved secret channel.
- Ask Vendo to test metadata discovery and one small query.
Verify
- Confirm the visible objects match the grant scope.
- Run the same bounded query in Databricks SQL and Vendo.
- Compare row count, values, and warehouse/query history.
- Confirm a suspended warehouse starts as expected or document the start-up latency.
- Record the credential owner and expiry date.
Troubleshooting
| Symptom | Check |
|---|---|
| Warehouse unavailable | Warehouse state, entitlement, and HTTP path |
| Catalog or table missing | USE CATALOG, USE SCHEMA, and SELECT grants |
| Credential rejected | Principal status, token expiry, and workspace URL |
| First query is slow | Warehouse auto-start and cluster size |
Related
Last updated on