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.

Key	Required	Fixed value	Value/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