Setup
1
Get your Databricks credentials
You’ll need:
- Workspace URL (e.g.,
https://your-workspace.cloud.databricks.com) - SQL Warehouse ID or Cluster ID
- Personal Access Token
2
Create a Personal Access Token
- In your Databricks workspace, go to User Settings
- Click Developer > Access tokens
- Click Generate new token
- Copy the token
3
Go to Settings
Navigate to Settings > Integrations in Adapt
4
Add the secrets
Add the following secrets:
5
Test the connection
Ask Adapt to list your catalogs or tables
Security Recommendations
- Use a dedicated service principal or user with minimal permissions
- Grant read-only access to specific catalogs/schemas
- Consider using Unity Catalog row-level security for sensitive data
- All queries are logged for audit purposes