Library/Application Support/iODBC/bin/iodbctest With this file updated with your Snowflake information you can now test the connection using the following command that is included with iODBC: Testing the Snowflake ODBC Installation and Configuration Here is an example of my local odbc.ini file: ĭriver = /opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib

The real configuration comes into play in the ~/Library/ODBC/odbc.ini file. The ~/Library/ODBC/odbcinst.ini should be set up properly. This driver has its configuration files in ~/Library/ODBC/odbcinst.ini and ~/Library/ODBC/odbc.ini. I chose to not install the optional ODBC Manager and configure the connection manually through the odbcinst.ini and odbc.ini files.Īfter iODBC has been installed the next step is to actually install the ODBC driver. Īt the time of writing the link in the Snowflake documentation ( ) is not currently working. Snowflake actually has pretty good documentation for setting up a local environment for Mac OS.

īefore digging into this integration I wanted to get my local environment set up so that I could experiment with querying the data outside of the application while we were settling on the presentation of what was to be included in the Snowflake views. After some research I came to the conclusion that one of the only ways to query the Snowflake views was through an ODBC connection using a combination of and. Recently I received a request to integrate a connection with an existing Rails application.

Odbc administrator for mac