Install snowSQL on Windows

  1. 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