Connect your Databricks Workspace

Prerequisites

You need Account Admin privileges and Metastore Admin privileges for your Databricks workspace
- https://docs.databricks.com/en/administration-guide/index.html

Head to the Databricks console
- https://accounts.cloud.databricks.com/
Note down your Databricks Account ID from the menu on the top right profile icon
- https://docs.databricks.com/aws/en/admin/account-settings/#locate-your-account-id
Click Workspaces, select a Unity Catalog-enabled workspace
Note down your Workspace URL
Open the workspace, and then note down your Workspace ID. Use these docs to identify your Workspace ID

In the workspace, select Settings from the top right Profile icon
Under Workspace admin, select Identity and access
Next to Service Principals, click Manage
Click Add service principal
- An Add new service principal modal pops up, click Add new
- Give the service principal a memorable name (e.g. select-service-principal)
Open the newly created service principal, select Secrets tab, then click Generate secret
Enter lifetime of 730 days, then click Generate
- you will need to create a new secret and update it in SELECT when it expires
Note down your Secret and Client ID

Navigate to SQL→SQL Warehouse from the navigation menu
Click Create SQL warehouse with the following config
- Name: pick a memorable name (e.g. select-sql-warehouse)
- Cluster size: 2X-Small
- Type: Serverless

Click Create
After the warehouse is created, the Manage permissions modal window is shown
- You can also access this modal by clicking Permissions
Search for and select the service principal you created (using the name or client id).
Select Can Use permission, click Add and close the modal
Note down the Warehouse ID

Navigate to Catalog from the navigation menu
Select system from the Catalog menu
Click Permissions → Grant on the right
Enter the following:
- For Principals, select the principal you created
- For Privilege presets, select Data Reader