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 locator is
Cloud Platform / . Region
Account Locator . (with additional segments if required)
Amazon Web Services (AWS)US 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)
Google Cloud Platform (GCP)US Central1 (Iowa)
xy12345.us-central1.gcpEurope West2 (London)
xy12345.europe-west2.gcpEurope West4 (Netherlands)
Microsoft 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 locator is different than the structure described in the above examples:
If AWS PrivateLink or Azure Private Link is enabled for your account and you wish to use private connectivity to connect to Snowflake, run the SYSTEM$GET_PRIVATELINK_CONFIG function to determine the private connectivity URL to use.
For more details on private connectivity, see:
When prompted by SnowSQL, enter the password for your Snowflake user.
For more details, see Connecting Through SnowSQL.