A couple of days ago, I update my MacOS to Catalina and immediately after that, all the Snowflake scripts I wrote in #Python started returning an Abort trap: 6 error. My initial thought was something must be a compatibility issue with either the python connector or new default terminal shell zsh. Fortunately I was wrong, but here is what I found and how i was able to do get my Python scripts running again. –Oh Happy Days.
Why is this happening
The error seems to be related to Catalina not allowing un-versioned dylibs to be called. Let’s shortcut this by linking the un-versioned dylib files to those with versions. Here’s the fix that worked for me.
A google search led me here: https://forums.developer.apple.com/thread/119429
From you terminal we need to run a few update using brew.
brew update && brew upgrade && brew install openssl
Once the updates are complete, execute the following steps
cd /usr/local/Cellar/openssl/1.0.2t/lib sudo cp libssl.1.0.0.dylib libcrypto.1.0.0.dylib /usr/local/lib/ cd /usr/local/lib sudo ln -s libssl.1.0.0.dylib libssl.dylib sudo ln -s libcrypto.1.0.0.dylib libcrypto.dylib
My more specific issue
More specifically for me, was ensuring the Snowflake Python Connector was functioning properly, so I also did a pip3 upgrade of that as well:
pip3 install --upgrade snowflake-connector-python
After skipping several modules that didn’t need any updates, we got to the a few updates from some files that are associated with crypto:
“Successfully installed asn1crypto-1.2.0 oscrypto-1.1.0 snowflake-connector-python-2.0.3”
After this, all is well …. so far 😉
Hope this helps!