Connect with Snowsql

Question

I would like to set up Snowsql client so I can connct for the first time and run commands like PUT.

I dont know where to find exacte values of :

accountname = xxxx
username = xxxx
password = xxxx

When I run following command from Windows command prompt :

C:\Users\noureddine.ettalhi>snowsql -a ettalhi -u ettalhi
Password:
250001 (08001): Failed to connect to DB. Verify the account name is correct: ettalhi.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!

It kept saying the mentioned error. so what value should I give for account ?

where are the steps to follow to use SnowSql for the first time ?

Thanks.

Answer 1

Since you are using snowsql client you may also create profiles in the config files located at .snowsql/config

[connections.MY_DEV]
accountname = myco.us-east-1
username = myuserid
database = mydb
role = mydb_admin
schema =  myschema
warehouse = my_WH

Once you have set up a profile this then you can specify the snowsql -c My_DEV will prompt for password .. just another way

Answer 2

Use fully qualified account name i.e Name + Regional Zone + Cloud Provider Name

For example:

1. your account name is oi12345
2. Regional zone is ca-central-1
3. Cloud provider is aws

Then your fully qualified account name is oi12345.ca-central-1.aws

Now let's say your userName is bestUser123

Now your command should be:

snowsql -a oi12345.ca-central-1.aws -u bestUser123