To configure Excel on Mac OS X El Capitan to use Snowflake:
- Install the Snowflake ODBC driver for Mac OS:
- Disable the rootless/SIP feature on El Capitan that prevents root users from copying files to system folders:
Note: This step requires a machine reboot.
- Copy the libSnowflake.dylib driver and simba.snowflake.ini file from the downloaded Snowflake ODBC driver to the /usr/lib/ folder:
~$ sudo cp /opt/snowflake/snowflakeodbc/lib/universal/* /usr/lib/
- Manually add the libSnowflake.dylib driver to the ODBC driver manager:
- Open Launchpad and run ODBC Manager.
- Click on the Drivers tab, and check if the Snowflake driver is already present. If it is, verify that the file path is /usr/lib/Snowflake.dylib. If it is not, click Add.
- Type a name for the driver, such as "Snowflake".
- Locate and choose the driver file libSnowflake.dylib in the /usr/lib folder.
- Click Add.
- Close the ODBC Manager.
- Create the Snowflake DSN using the newly added driver:
- Launch Excel.
- Go to Data > New Database Query > Import from Database.
- Under User DSN, click Add. A dialog opens.
- Select the Snowflake driver you added in Step#4. The DSN configuration window opens.
- Enter a unique DSN name for your Snowflake connection
- In the keyword section add the following key and value pairs:
- Click OK to save settings. Focus returns to the iODBC Data Source Chooser window.
- Test the new DSN by clicking on the name followed by Test button.
- Enter your Snowflake username and password, and click OK. A message states the test results.
- Proceed to import data from newly created Snowflake DSN:
- With the iODBC Data Source Chooser window open, click on new DSN, and hit OK.
- Enter your Snowflake username and password. The Microsoft Query window opens.
- Type the desired SQL statement, and click Run.
- Click Return Data to import the results to the spreadsheet.