# Snowflake You can quickly import data from your Snowflake into Exploratory. ## Prerequisite: ODBC Drivers 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. ![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F-M4HLCK3olgduYoe3RVS%2Fuploads%2Fgit-blob-ace6e94d01c42062431d48fcbfbd5ac39829be40%2Fsnowflake-arm-odbc.png?alt=media) ### Install ODBC Driver for Windows To Install ODBC Driver for Snowflake for Windows, please follow the [instruction](https://docs.snowflake.com/en/user-guide/odbc-windows.html) ### Install ODBC Driver for Mac First, you need to install homebrew to manage your packages and you have the necessary admin rights on your machine. Homebrew installation: [link](http://brew.sh/) 1. Install unixodbc Install with your shell/terminal: ```sh brew install unixodbc ``` Then follow the [instruction](https://docs.snowflake.com/en/user-guide/odbc-mac.html) 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. ```sh ➜ ~ 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. ```sh 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 ```sh [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. ```sh [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. ```sh # unixODBC #ODBCInstLib=libodbcinst.a(libodbcinst.so.1) ODBCInstLib=/usr/local/lib/libodbcinst.dylib ``` For Mac with Apple Silicon (M1/M2), the library file location is `/opt/homebrew/lib/libodbcinst.dylib` by default. ```sh # unixODBC ODBCInstLib=/opt/homebrew/lib/libodbcinst.dylib ``` ## 1. Create a connection for Snowflake First, you want to create a connection for Snowflake. ![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2Fsync%2F18b0847356381459ed63d71e02bb30d8a23e5f0b.png?generation=1610731203463059\&alt=media) After filling the below database information: * Host - Snowflake server * Warehouse - Warehouse Name * Database - Database Name * ODBC Driver Name for Snowflake - It shows list of installed drivers. Regardless of the driver selected here, when you publish a Data source that uses the connection, "/usr/lib64/snowflake/odbc/lib/libSnowflake.so" is used for Scheduling. (Both exploratory.io and Collaboration Server have /usr/lib64/snowflake/odbc/lib/libSnowflake.so) * Username - Username of the Snowflake * Password - Password of the Snowflake Click ‘Test Connection’ button to make sure the information is correct, before you save it. ## 2. Open Snowflake Import dialog Select 'Import Database Data' from Add New Data Frame menu. ![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2F-M4oMvCUDQwHTJ0eWi_f%2F-M4oN-qBMezITjny_pQQ%2Fimport-database.png?generation=1586795453631702\&alt=media) Click Snowflake to select. ![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2Fsync%2F0f9f15d6bc5cfb2a32d7ccc6707ae0f8f97918c8.png?generation=1610731204596268\&alt=media) ## 3. Preview and Import Click "Run" button to see the data back from Snowflake. ![](https://2850417076-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-M4HLCK3olgduYoe3RVS%2Fsync%2Fe6b48e2963741eb97b53599ad2144c65a08f2304.png?generation=1610731206036509\&alt=media) If it looks ok, then you can click 'Import' to import the data into Exploratory. ## 4. Known Issues Currently, Snowflake does not support Snowflake ODBC drive on Apple M1 Mac. ref: