Step 1. Log into SnowSQL¶
After SnowSQL is installed (see Prerequisites for details), to log in:
Open a terminal window.
Start SnowSQL at the command prompt:
$ snowsql -a <account_name> -u <user_name>`
<account_name>is the name assigned to your account by Snowflake. In the hostname you received from Snowflake (after your account was provisioned), your account name is the full/entire string to the left of
<user_name>is the login name for your Snowflake user.
Note that, depending on the cloud platform (AWS or Azure) and Snowflake Region where your account is hosted, the full account name may require additional segments, as shown in the following diagram:
For example, for an account named
If the account is in: Account name is: AWS US West
AWS US East
AWS EU (Dublin)
AWS EU (Frankfurt)
AWS Asia Pacific (Singapore)
AWS Asia Pacific (Sydney)
Azure East US 2
Azure West Europe
Azure Australia East
The structure of your account name is different if either of the following is true:
When prompted by SnowSQL, enter the password for your Snowflake user.
For more details, see Connecting Through SnowSQL.