Exploratory
Search…
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.
Install ODBC Driver for Windows
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.
- 1.Install unixodbc Install with your shell/terminal:
1
brew install unixodbc
Copied!
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.1
➜ ~ odbcinst -j
2
unixODBC 2.3.9
3
DRIVERS............: /usr/local/etc/odbcinst.ini
4
SYSTEM DATA SOURCES: /usr/local/etc/odbc.ini
5
FILE DATA SOURCES..: /usr/local/etc/ODBCDataSources
6
USER DATA SOURCES..: /Users/exploratory/.odbc.ini
7
SQLULEN Size.......: 8
8
SQLLEN Size........: 8
9
SQLSETPOSIROW Size.: 8
Copied!
So add the below to the odbcinst.ini file
1
[SnowflakeDSIIDriver]
2
APILevel=1
3
ConnectFunctions=YYY
4
Description=Snowflake DSII
5
Driver=/opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib
6
DriverODBCVer=03.52
7
SQLLevel=1
Copied!
1. Create a connection for Snowflake
First, you want to create a connection for Snowflake.
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.
Click Snowflake to select.
3. Preview and Import
Click "Run" button to see the data back from Snowflake.
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: https://stackoverflow.com/questions/69652761/error-loading-snowflake-odbc-driver-on-mac-m1-from-erlang-call-odbc-connect
Last modified 30d ago