i have a macbook with tableau desktop. i am trying to connect to snowflake, but tableau is not recognizing the snowflake odbc driver. i followed the steps in snowflake documentation to install the drivers. the files are in the correct folders, but i don't think the driver is actually installing.

i have monterey OS. my colleague who has catalina has had no problem connecting to snowflake, while another colleague who also has monterey, is having the same issue i am. it seems like it may be because the file /usr/bin/python in catalina is renamed usr/bin/python3 in monterey.

is there any way i can get my machine connected to snowflake using tableau on monterey?

CodePudding user response：

First, have you tried using Snowflake Connectivity Diagnostic Tools to verify your network connection is good and you can connect to Snowflake? If yes, then please try to connect to Snowflake using SnowSQL to verify your ODBC install. If both of these are successful, and you have followed how to connect Tableau to a Snowflake data warehouse and set up the data source, then I would suggest you start a support case with Tableau.

CodePudding user response：

Navigate to ~/Library/ODBC/odbcinst.ini. You might be missing the DSN entry. If so, you can manually add the following:

[Snowflake]
Driver = /opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib

Snowflake recommends http://www.odbcmanager.net/, but even with that I've previously had trouble adding the DSN and needed to manually add it.