Search code examples
snowflake-cloud-data-platformsnowsql

Not able to connect to Snowflake database with snowsql


I am not able to connect with snowsql by Windows console:

<!-- language: lang-html -->
    C:\Users\musik>snowsql -a [myAccount] -u [myUserName]<br>
    Installing version: 1.2.0  [####################################]  100%<br>
    Password:<br>
<!-- end snippet -->

I get this error message:

250001 (08001): Failed to connect to DB. Verify the account name is correct: [myAccount].snowflakecomputing.com:443. HTTP 403: Forbidden
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!

Screenshot

Then I used -o log_level=DEBUG. In the log file I can see that I am getting a "forbidden" error:

2019-12-05 16:45:16,510 (6472/MainThread) snowflake.connector.network DEBUG        network:822  - HTTP 403: Forbidden. Retrying...

What can I do? Has somebody the same issue?


Solution

  • From my comment earlier: Be sure to include the region and such in your account. It should include everything up to the snowflakecomputing.com in the URL that you use to access Snowflake through the UI.