Databricks provides instructions on how to setup a SQL endpoint with correct permissions and retrieve login credentials. It is recommended you follow the Official Databricks Documentation for setting up an ODBC connection.

At the end of the instructions, you should have the following credentials from Databricks, which you will use to set up Polytomic:

  • Host (server address)
  • Port
  • User ID (this may be "token" if you set up an API key)
  • Password (this may be your API key if you set one up).
  • HTTP Path

Once you have set up your endpoint and credentials, you can set up Polytomic to read data from Databricks.

  1. In Polytomic, go to ConnectionsAdd ConnectionDatabricks.
  1. Enter in the Host, Port, UserID, Password, and HTTP Path.

  2. Click save