Source and destination

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:

  • Server hostname
  • Port
  • Access token
  • 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 the server hostname, port, access token, and HTTP path.

  2. (Optional) If you'd like to sync data to your Databricks instance using Polytomic, you need to enter an AWS S3 bucket (for storing intermediate data) and access key pair.

  3. Click save