Open fishstoryyy opened 3 years ago
👋 the companyname
is probably not required in the account. The account
The regular pattern of the account is: <account_name>[.<region_id>][.<cloud>]
. (e.g. 'xy12345.east-us-2.azure') , and it needs to be one of the supported account locators listed at https://docs.snowflake.com/en/user-guide/connecting.html#your-snowflake-account-name . Can you please check the link above and try with the supported snowflake account locators?
If you're connecting to snowflake not via the listed account locators but through an internally managed proxy then it's currently not supported by this sql client.
btw, a new version (0.4.2) of the sql client is published to VSCode Marketplace with some more information on the connection form. Can you please upgrade, try again and let me know how is it going?
Thank you for your response. My apology for a late reply.
With regards to the example xy12345.east-us-2.azure
you gave and other account locators listed here, what I should use to replace xy12345
? My url looks like this: https://prod.us-east-1.companyname.snowflakecomputing.com
.
Thanks you very much in advance.
I'm presuming yo fixed it. If not I suggest installing snowsql https://docs.snowflake.com/en/user-guide/snowsql-start.html and then on linux/mac login via snowsql -a <account>> -u <<user>
That way you can confirm all is okay before using this connector.
Hi anujghai,
I haven't found a fix yet. I was able to get it work on Python through the snowflake-connector-python but once I copy and paste the same credentials (account name and password) to this connector, the connection didn't go through.
Okay, I tested with the python connector using a script like below (Replace
import snowflake.connector import getpass
uname = input('Enter Username: ') pword = getpass.getpass(prompt='Enter password: ', stream=None)
ctx = snowflake.connector.connect(
user=uname,
password=pword,
account='
@fishstoryyy - did you ever find a solution here? My account name is companyname.eu-west-1 and I receive the same error. Again, it works just fine with the python connector.
Hi everyone, I am getting the following network error when testing a connection.
Not sure if it is caused by my account name. My account name (the part left to .snowflakecomputing.com) follows a format like this:
letters_only.us-east-1.companyname
If the account name is not the cause, could it be a proxy issue?
Can someone please help? Really looking forward to making use of this extension.