I am trying to connect to a snowflake database to a rails app. I followed the necessary instructions found at https://docs.snowflake.com/en/user-guide/odbc.html. After installing unixodbc and configuring the drivers. I try to run the server from my rails application. But I always get the following error:
Sequel::DatabaseConnectionError: ODBC::Error: 01000 (0) [unixODBC][Driver Manager]Can't open lib '/opt/snowflake/snowflakeodbc/lib/universal/libSnowflake.dylib' : file not found
The "libSnowflake.dylib" appears to be present at the right location, I even checked the same in odbc.ini file.
The problem only appears to be happening in my Macbook M1 model, others seems to be just fine, I can vouch on this as I got the same error on my colleagues M1 device as well, while it installs perfectly on Intel enabled Macbook. Can someone please guide me what can be done in this case as I don't see much help on this specific topic.
