Snowflake
You can quickly import data from your Snowflake into Exploratory.
To use the Snowflake Data Source, you need to install ODBC driver.
If you use Mac with Apple Silicon (M1/M2), you need to install the ODBC driver for architecture macaarch64.

First, you need to install homebrew to manage your packages and you have the necessary admin rights on your machine.
- 1.Install unixodbc Install with your shell/terminal:
brew install unixodbc
Then follow the instruction to install Mac ODBC Driver. Once installed, now you need to register the ODBC driver.
Since now you installed the unixODBC, you can use
odbcinst
command from Terminal. And if you try odbcinst -j
, you can know the location of driver registration file (odbcinst.ini) like below.➜ ~ odbcinst -j
unixODBC 2.3.9
DRIVERS............: /usr/local/etc/odbcinst.ini
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
USER DATA SOURCES..: /Users/exploratory/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
if you use Mac with Apple Silicon (M1/M2), you might see slight different location like below.
unixODBC 2.3.11
DRIVERS............: /opt/homebrew/etc/odbcinst.ini
SYSTEM DATA SOURCES: /opt/homebrew/etc/odbc.ini
FILE DATA SOURCES..: /opt/homebrew/etc/ODBCDataSources
USER DATA SOURCES..: /Users/hidekoji/.odbc.ini
SQLULEN Size.......: 8
SQLLEN Size........: 8
SQLSETPOSIROW Size.: 8
So add the below to the odbcinst.ini file
[SnowflakeDSIIDriver]
APILevel=1
ConnectFunctions=YYY
Description=Snowflake DSII
Driver=/opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib
DriverODBCVer=03.52
SQLLevel=1
if you use Mac with Apple Silicon (M1/M2), driver path is different so it looks like this.
[SnowflakeDSIIDriver]
APILevel=1
ConnectFunctions=YYY
Description=Snowflake DSII
Driver=/opt/snowflake/snowflakeodbc/lib/libSnowflake.dylib
DriverODBCVer=03.52
SQLLevel=1
Open the Snowflake ODBC config file located at
/opt/snowflake/snowflakeodbc/lib/universal/simba.snowflake.ini
For Mac with Apple Silicon (M1/M2), the location is
/opt/snowflake/snowflakeodbc/lib/simba.snowflake.ini
Make sure that unixODBC section points to the
libodbcinst.dylib
file which is installed with homebrew. Please note the location of the libodbcinst.dylib
varies per installation.# unixODBC
#ODBCInstLib=libodbcinst.a(libodbcinst.so.1)
ODBCInstLib=/usr/local/lib/libodbcinst.dylib