- Select Help on the WebUI Ribbon

- Select Download…

- Select Windows

- Navigate to s/w directory




- Open the msi installer file





Open DOS or better still powershell prompt
Permission Warning on using SnowSQL
If you recieve a warning similar to below when running snowsql, we need to update log directory in the config file.
Failed to initialize log. No logging is enabled: [Errno 13] Permission denied: 'C:\\Users\\snowsql_rt.log_bootstrap'
Locate the snowsql config file: %USERPROFILE%\.snowsql\config
for me this was:
C:\Users\psammy\.snowsql\config
open file in notepad and edit To avoid a permission warning:
change
: log_file = ../snowsql_rt.log
to
:log_file = ./snowsql_rt.log
First time run snowsql l it appears to perform some initial install actions.
Installing version: 1.2.20 [########----------------------------] 23%
00:00:Installing version: 1.2.20 [########----------------------------] 24%
00:00:Installing version: 1.2.20 [#########---------------------------] 25%
..
..
00:00:Installing version: 1.2.20 [####################################] 100%
To connect we just need the below details
- Account details without snowflake.com extension
- %%nnn.<region>.<cloudprovider
- Example: ab12345.eu-west-2.aws
- Username
- Password
Then to connect we simply type:
snowsql -a ab12345.eu-west-2.aws -u PSAMMY