*Tested on Red Hat Linux 8
snowsql can now be found : SnowSQL – Snowflake Developers
1. Navigate to the Linux directory, and choose the latest version from the list of rpms.
2. Once you select rpm it will download to Downloads folder location specified by browser
3. scp/sftp rpm file to Linux server
4. Install the rpm as root or sudo
rpm -i snowflake-snowsql-1.2.20-1.x86_64.rpm 5. As non root user confirm snowsql installed
which snowsql
/usr/bin/snowsql
snowsql -v
Version: 1.2.20
6. 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