Databricks
Generate Personal or OAuth M2M credentials
Omni can use either personal access token (PAT) or OAuth machine-to-machine (M2M) credentials to authenticate to Databricks.
To use a PAT: Follow these Databricks instructions to generate an Access Token for a service principal.
To use M2M: Follow these Databricks instructions to generate an M2M service principal and secret
Retrieve the HTTP Path and Host Name
Gather the HTTP Path and Server Hostname from the Connection Details page in Databricks. You can get there by navigating to SQL > SQL Warehouse > Click on <Your_Warehouse_Name>
> Connection Details.
Creating the connection in Omni
- Display Name:
<CONNECTION_NAME>
- Host:
<YOUR_HOSTNAME>
(from previous step) - HTTPPath
<YOUR_HTTP_PATH>
(from previous step) - Default Catalog:
<YOUR_CATALOG>
- User: leave blank
- Either:
- For PAT authentication, set the Password field to the PAT generated in the previous step
- For M2M authentication, check the
Enable OAuth M2M
box and enter your Application ID and OAuth Secret from the previous step
What's next?
Now that Databricks is set up, you can:
- Configure user permissions, schema refreshes, environments and timezone settings
- Learn how Omni generates the model associated with the connection