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.
Account name examples by region
If your account name is
Cloud Platform / Region
Full Account Name
AWSUS West (Oregon)
xy12345US East (Ohio)
xy12345.us-east-2.awsUS East (N. Virginia)
xy12345.us-east-1US East (Commercial Gov - N. Virginia)
xy12345.eu-central-1Asia Pacific (Tokyo)
xy12345.ap-northeast-1.awsAsia Pacific (Mumbai)
xy12345.ap-south-1.awsAsia Pacific (Singapore)
xy12345.ap-southeast-1Asia Pacific (Sydney)
GCPUS Central1 (Iowa)
xy12345.us-central1.gcpEurope West2 (London)
xy12345.europe-west2.gcpEurope West4 (Netherlands)
AzureWest US 2 (Washington)
xy12345.west-us-2.azureEast US 2 (Virginia)
xy12345.east-us-2.azureUS Gov Virginia
xy12345.us-gov-virginia.azureCanada Central (Toronto)
xy12345.canada-central.azureWest Europe (Netherlands)
xy12345.west-europe.azureSwitzerland North (Zurich)
xy12345.switzerland-north.azureSoutheast Asia (Singapore)
xy12345.southeast-asia.azureAustralia East (New South Wales)
If either of the following conditions is true, your account name is different than the structure described in this example:
When prompted by SnowSQL, enter the password for your Snowflake user.
For more details, see Connecting Through SnowSQL.