Windows

Before you start, be sure to read the Databricks ODBC page

There are multiple ways to authenticate. We will describe the username/password authentication in this example.

1. Be sure you have the latest Simba Spark ODBC driver installed. (2.8.2 or higher, release from June 4th 2024)

2. In ODBC Administrator, Go to the `User DSN` tab and press the `Add` button.

3. Select the Simba Spark ODBC Driver

4. 

5. Fill in at least these fields:

   1. Data source (this is the key you define to identify your connection, this is the DSN name you need when creating the connection in the management console)

   2. Host(s)

   3. Port: 443

   4. Database

   5. Mechanism: User Name and Password

   6. User Name: token

   7. Password (this would be your personal access token)

   8. Thrift Transport: HTTP

   9. Select the HTTP Options button

      1. Fill in your HTTP Path

   10. Click the SSL Options button

       1. Check the Enable SSL Option

       
   11. Go to Advanced options and set the Default String Column length to 4000

       
   12. Click the Test button to confirm that connection is successful.

   13. Click the OK Button to save the changes

   14. Now it is time to create a connection in the management console.