Skip to main content

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)