Today I tested how to use snowsql to connect to SnowFlake. I put the connection credential in the config file. But I encountered the following error message in the intial attempt:
(venv) c:\Users\Yu\.snowsql>snowsql
250001 (08001): Failed to connect to DB: abcdefg-hij01234.snowflakecomputing.com:443. Incorrect username or password was specified.
If the error message is unclear, enable logging using -o log_level=DEBUG and see the log to find out the cause. Contact support for further help.
Goodbye!
It turned out I need to enclose the password with double quotes in the config file.
for example, in the c:\Users\Yu\.snowsql\.config file:
accountname =abcdefg-hij01234
username =denissun
# password =Ab0cdE725##FG0 -- not working
password = "Ab0cdE725##FG0" -- works!
After put double quotes, I tested again and it succeeded:
(venv) c:\Users\Yu\.snowsql>snowsql
* SnowSQL * v1.4.1
Type SQL statements or !help
denissun9883#COMPUTE_WH@(no database).(no schema)>!help
+------------+-------------------------------------------+-------------+--------------------------------------------------------------------------------------------+
| Command | Use | Aliases | Description |
|------------+-------------------------------------------+-------------+--------------------------------------------------------------------------------------------|
| !abort | !abort <query id> | | Abort a query |
| !connect | !connect <connection_name> | | Create a new connection |
| !define | !define <variable>=<value> | | Define a variable as the given value |
| !edit | !edit <query> | | Opens up a text editor. Useful for writing longer queries. Defaults to last query |
| !exit | !exit | !disconnect | Drop the current connection |
| !help | !help | !helps, !h | Show the client help. |
| !options | !options | !opts | Show all options and their values |
| !pause | !pause | | Pauses running queries. |
| !print | !print <message> | | Print given text |
| !queries | !queries help, <filter>=<value>, <filter> | | Lists queries matching the specified filters. Write <!queries> help for a list of filters. |
| !quit | !quit | !q | Drop all connections and quit SnowSQL |
| !rehash | !rehash | | Refresh autocompletion |
| !result | !result <query id> | | See the result of a query |
| !set | !set <option>=<value> | | Set an option to the given value |
| !source | !source <filename>, <url> | !load | Execute given sql file |
| !spool | !spool <filename>, off | | Turn on or off writing results to file |
| !system | !system <system command> | | Run a system command in the shell |
| !variables | !variables | !vars | Show all variables and their values |
+------------+-------------------------------------------+-------------+--------------------------------------------------------------------------------------------+
It could be due to my password has special characters.
