2

I'm having trouble connecting to ODBC Snowflake in R Studio. Here are my connection settings, and I have installed the Snowflake driver as well as ODBC and I'm on an M1 Mac:

con <- DBI::dbConnect(odbc::odbc(),
                      Driver = '/opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib',
                      Server = <URL here from work>,
                      UID = <USERNAME>,
                      Trusted_Connection = "True",
                      authenticator = "externalbrowser",
                      Database = <DATABASENAME>)

I get the following error message after trying to run:

enter image description here

Phil
  • 7,287
  • 3
  • 36
  • 66
Erin Asks
  • 21
  • 3
  • [Can't open lib 'libSnowflake.dylib'](https://stackoverflow.com/questions/69066996/sequeldatabaseconnectionerror-odbcerror-01000-0-unixodbcdriver-manage) – Isaiah Oct 29 '22 at 03:58

1 Answers1

0

Be sure to install the ARM version of the library and not the universal one. For example, use snowflake_odbc_mac_arm64-2.25.7.dmg and not snowflake_odbc_mac-2.25.7.dmg

guest
  • 1