Linux

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

Go to your odbc configuration file. Typically located at /etc/odbc.ini

Add a section for your configuration like the example below.

[your_dsn_name]
Driver          = </path/to/driver>
Description     =
Host            = <yourhost>.azuredatabricks.net
Port            = 443
HttpPath        = <your http path> e.g. /sql/1.0/warehouses/12345678
ThriftTransport = 2
AuthMech        = 3
transportMode   = http
ssl             = 1
DefaultStringColumnLength = 4000

The DSN name you specify between the [] at the top is the unique name you'll need in WriteBackExtreme to configure the connection.