Skip to main content

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: