Overview
Steps to connect from Excel on M1 Mac to Snowflake via ODBC.
Environment
- MacBook Pro (M1 chip, macOS Ventura 13.0)
- Microsoft Excel for Mac (Version 16.68)
Prerequisites
Install iODBC and ODBC Manager.
brew install libiodbc
Download and install ODBC Manager from: http://www.odbcmanager.net/
Install Snowflake ODBC Driver
Download the Snowflake ODBC driver for macOS from the Snowflake documentation page and install it.
After installation, the driver files will be located at:
/opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib
Configure simba.snowflake.ini
Edit /opt/snowflake/snowflakeodbc/lib/universal/simba.snowflake.ini:
[Driver]
DriverManagerEncoding=UTF-16
ICULib=/opt/snowflake/snowflakeodbc/lib/universal/icu/lib/libicuuc.dylib
ICUi18n=/opt/snowflake/snowflakeodbc/lib/universal/icu/lib/libicui18n.dylib
LogLevel=0
LogPath=/tmp
ODBCInstLib=/usr/local/iODBC/lib/libiodbcinst.dylib
SwapFilePath=/tmp
Configure odbc.ini
Edit /Library/ODBC/odbc.ini:
[ODBC Data Sources]
snowflake_dsn=SnowflakeDSIIDriver
[snowflake_dsn]
Driver=/opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib
Description=
uid=YOUR_USERNAME
pwd=YOUR_PASSWORD
server=YOUR_ACCOUNT.snowflakecomputing.com
database=YOUR_DATABASE
schema=YOUR_SCHEMA
warehouse=YOUR_WAREHOUSE
role=YOUR_ROLE
Register in ODBC Manager
Launch ODBC Manager and register the DSN configured in odbc.ini.
Connect from Excel
In Excel, use Data > Get External Data > New Database Query to connect via ODBC.
Select the DSN registered above and enter credentials to connect to Snowflake.
Troubleshooting
If the connection fails, check the following:
- Verify the iODBC library path in
simba.snowflake.iniis correct - Check that the
ODBCInstLibpath points to the correctlibiodbcinst.dylib - Ensure ODBC Manager shows the DSN as properly configured