# 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.

<table><thead><tr><th width="161">Key</th><th width="102" data-type="checkbox">Required</th><th width="118" data-type="checkbox">Fixed value</th><th>Value/Example</th></tr></thead><tbody><tr><td>driver</td><td>true</td><td>true</td><td>DatabricksDriver</td></tr><tr><td>httpPath</td><td>true</td><td>false</td><td>e.g. /sql/1.0/warehouses/123456789</td></tr><tr><td>thriftTransport</td><td>true</td><td>true</td><td>2</td></tr><tr><td>AuthMech</td><td>true</td><td>true</td><td>3</td></tr><tr><td>Host</td><td>true</td><td>false</td><td>e.g. abc-123456789.azuredatabricks.net</td></tr><tr><td>Port</td><td>true</td><td>true</td><td>443</td></tr><tr><td>Ssl</td><td>true</td><td>true</td><td>1</td></tr><tr><td>transportMode</td><td>true</td><td>true</td><td>http</td></tr></tbody></table>

The attributes specified will generate a DSN string as follows:

<pre><code><strong>driver=DatabricksDriver;HttpPath={htthPath};thriftTransport=2;AuthMech=3;Host={host};Port=443;ssl=1;transportMode=http
</strong></code></pre>

<figure><img src="https://content.gitbook.com/content/MzOBMgQCQmnHEY9CGpbe/blobs/u0t70HuC0WMgOJLW2jv5/image.png" alt=""><figcaption></figcaption></figure>