ODBC connections

ODBC Databases with unique setups: This document describes databases with distinct communication methods:

  • Snowflake ODBC

  • Databricks

ODBC-based drivers are exposed and can be used via the driver name.

  • Snowflake ODBC: SnowflakeDSIIDriver

  • Databricks: DatabricksDriver

Using odbc.ini and or odbcinst.ini

If it's necessary to use an odbc.ini file for defining connections, create a VOLUME pointed to /etc/odbc.ini or populate the odbc.ini file with content beforehand. For driver modifications, use /etc/odbcinst.ini as needed.

Snowflake ODBC

We recommend to use the "manual DSN" setup in WriteBackExtreme when using the containerized version.

Example DSN string:

driver=SnowflakeDSIIDriver;....

Databricks

To connect to Databricks, a "manual DSN" isn't available yet. Use the following workaround instead. The table below lists all required DSN attributes.

KeyRequiredFixed valueValue/Example

driver

DatabricksDriver

httpPath

e.g. /sql/1.0/warehouses/123456789

thriftTransport

2

AuthMech

3

Host

e.g. abc-123456789.azuredatabricks.net

Port

443

Ssl

1

transportMode

http

The attributes specified will generate a DSN string as follows:

driver=DatabricksDriver;HttpPath={htthPath};thriftTransport=2;AuthMech=3;Host={host};Port=443;ssl=1;transportMode=http

Last updated