Problem
When you install unixODBC and the Snowflake ODBC driver, there are instances where the Snowflake driver does not appear in Exploratory’s Data Connection Setup dialog. This issue is often related to the ODBC configuration file not being properly set up.
Resolution Steps
Identify the ODBC Configuration File
Use the following R command to list the ODBC configuration details:
data.frame(odbc::odbcListConfig())
Execute this command within the R Script Data Frame in Exploratory.
The first row of the output will indicate the location of the ODBC configuration file. In the example above, the configuration file is located at:
/usr/local/etc/odbcinst.ini
Verify Snowflake Driver Configuration
Open the identified configuration file and ensure the Snowflake ODBC driver is properly listed. If it is not, you will need to add the appropriate driver settings to the file.