*Tested on Red Hat Linux 8
snowsql can now be found here : SnowSQL – Snowflake Developers
You can either download latest version (recommended)
Or choose a particular version of choice:
1. Once you select rpm it will download to Downloads folder location specified by browser
2. scp/sftp rpm file to Linux server
3. Install the rpm as root or sudo
rpm -i snowflake-snowsql-1.2.20-1.x86_64.rpm 4. As non root user confirm snowsql installed
which snowsql
/usr/bin/snowsql
snowsql -v
Version: 1.2.20
5. Update the config file used by snowsql for a log directory that is writable other wise may get below error
Failed to initialize log. No logging is enabled: [Errno 13] Permission denied: '<path>/snowsql_rt.log' This config files is created in the users home directory/.snowsql/config
vi ~/.snowsql/config
change:
log_file = ../snowsql_rt.log
to:
log_file = ./snowsql_rt.log Start snowsql
If you have an account like: https://AB99999.eu-west-2.aws.snowflakecomputing.com
snowsql -a AB99999.eu-west-2.aws -u PSAMMY
or
If you have an account like: https://sgthsea-kf43267.snowflakecomputing.com
snowsql -a sgthsea-kf43267 -u PSAMMY