Databricks
Connecting to Databricks
Create an Omni user in Databricks
Generate a user in Omni with permissions to select from tables you want to query.
GRANT USAGE ON DATABASE <YOUR_DATABASE> TO <omni>@<your.databricks.com>
GRANT SELECT ON DATABASE <YOUR_DATABASE> TO <omni>@<your.databricks.com>
-- if you use the hive_metastore catalog, you'll need READ_METADATA privileges
GRANT READ_METADATA ON DATABASE <YOUR_DATABASE> TO <omni>@<your.databricks.com>
Generate a PAT
Omni uses personal access tokens to authenticate to Databricks. Follow the instructions in databricks to generate an Access Token.
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
- Password:
<YOUR_PAT>
(from previous step)