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 region where your account is hosted, the full account name may require additional segments, as shown in the following diagram:
For example, if your account name is
Full Account Name
AWSUS West (Oregon)
xy12345US East (N. Virginia)
xy12345.eu-central-1Asia Pacific (Singapore)
xy12345.ap-southeast-1Asia Pacific (Sydney)
AzureEast US 2
xy12345.east-us-2.azureUS Gov Virginia
If either of the following conditions is true, your account name is different than the structure described above:
When prompted by SnowSQL, enter the password for your Snowflake user.
For more details, see Connecting Through SnowSQL.