I get the following when I attempt to login using the snowsql client using an external browser.
/home/username/.snowsql/1.2.16/libz.so.1: version `ZLIB_1.2.9' not found (required by /lib/x86_64-linux-gnu/libpng16.so.16) Couldn't load XPCOM.
Here is my OS info
NAME="Pop!_OS"
VERSION="21.04"
ID=pop
ID_LIKE="ubuntu debian"
PRETTY_NAME="Pop!_OS 21.04"
VERSION_ID="21.04"
HOME_URL="https://pop.system76.com"
SUPPORT_URL="https://support.system76.com"
BUG_REPORT_URL="https://github.com/pop-os/pop/issues"
PRIVACY_POLICY_URL="https://system76.com/privacy"
VERSION_CODENAME=hirsute
UBUNTU_CODENAME=hirsute
LOGO=distributor-logo-pop-os
This is because Snowsql overrides LD_PRELOAD for its own bundling mechanism, and doesn't bother to unset it when it tries to start your browser.
This means your browser tries to use libs bundled with snowsql instead of your system libs.
You can "fix" by removing the libs bundled with SnowSQL that are causing issues (at least libz, libselinux for me) and replacing them with symlinks to those from your own platform:
cd ~/.snowsql/1.2.20
rm libz.so.1 libselinux.so.1
ln -s /usr/lib/x86_64-linux-gnu/libz.so.1 /usr/lib/x86_64-linux-gnu/libselinux.so.1 ./
Bug has been raised with Snowflake, they confirmed and reproduced, but this was months ago and I haven't heard anything since.
You might also say this is caused be SnowSQL bundling a version of zlib that it looks like first made it into Debian in 2005? I'm sure they have been very diligent about backporting security fixes, there's nothing to worry about here.