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: