Setup ODBC on Linux

When using Databricks, Snowflake or Teradata in WriteBackExtreme you need to configure an ODBC connection.

Snowflake

Install the driver from the snowflake website

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]
SERVER=<YOUR_SERVER>
Driver=/<path>/libSnowflake.so
Database=<YOUR_DATABASE_NAME>
Schema=PUBLIC
Warehouse=<YOUR_WAREHOUSE>

• <YOUR_SERVER> is the url of your snowflake instance (for example appsfortableau.west-europe.azure.snowflakecomputing.com)

• <path is the location where the snowflake library is located

• <YOUR_DATABASE_NAME> is your database name

• <YOUR_WAREHOUSE> is your warehouse

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

Make sure to set NoExecuteInSQLPrepare to true in ODBC configuration. (link)

This should be set in your simba.snowflake.ini file.