search

Snowflake-Labs / sqltools-snowflake-driver

A Snowflake driver for the SQLTools VSCode extension.
MIT License
35 stars 15 forks source link

Keep on getting Network Error #9

Closed FanliZhou860815 closed 3 years ago

FanliZhou860815 commented 3 years ago

Keep on receiving this ERROR: Error opening connection Network error. Could not reach Snowflake., {"code":401001,"data":{"driver":"Snowflake","driverOptions":{}}} when trying to connect to Snowflake. Same connection setting works on Snowflake UI and other SQL tools on the same machine. Could anyone help please ? Thanks in advance !

WoggyG commented 3 years ago

I have the same error however i can connect to Snowflake with other IDEs

[1608073630196] ERROR (ls): Connecting error: {"code":401001,"data":{"driver":"Snowflake","driverOptions":{}},"name":"NetworkError"} ns: "conn-manager" [1608073630197] ERROR (ext): ERROR: Error opening connection Network error. Could not reach Snowflake., {"code":401001,"data":{"driver":"Snowflake","driverOptions":{}}} ns: "error-handler"

WoggyG commented 3 years ago

managed to solve it

the trick is in the snowflake account name. it has to look like this

xyz123.ap-southeast-2

or

follow the table here : https://docs.snowflake.com/en/user-guide/connecting.html#your-snowflake-account-name

FanliZhou860815 commented 3 years ago

It works! Thank you very much @WoggyG ！