[SOLVED] SnowSQL fails with "The library Security could not be found" after upgrading to mac Big Sur

SnowSQL fails with "The library Security could not be found" after upgrading to mac Big Sur

After upgrading to macOS Big Sur my snowsql scripts all fail with "The Library Security could not be found"

$ snowsql -q "select 1 x"
User: me
Password: XXX
The library Security could not be found
If the error message is unclear, enable logging using -o log_level=DEBUG and see the log to find out the cause. Contact support for further help.
Goodbye!

This reminds me of an issue I ran into with the snowflake-connector-python library involving oscrypto library being used instead of openssl when I upgraded to macOS Catalina several months ago, the issue is documented here: https://github.com/snowflakedb/snowflake-connector-python/issues/235

When I first saw the issue today I was running an earlier version of SnowSQL (1.1.something) then I upgraded to 1.2.9 and got the same error. I tried adding the "-o log_level=DEBUG" to the SnowSQL command line but it didn't output any additional information.

Solution

Could you try the following steps?

Move the User's snowsql directory to a backup: mv ~/.snowsql ~/.snowsql.prebigsur
Move the SnowSQL application to the trash from the Applications folder.
Make sure "/Applications/SnowSQL.app" is gone.
Then download and install the latest SnowSQL from the darwin repo (https://sfc-repo.snowflakecomputing.com/snowsql/bootstrap/1.2/darwin_x86_64/index.html)