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>
Where:
<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 ofsnowflakecomputing.com
.<user_name>
is the login name for your Snowflake user.
Note that your full account name may include additional segments that identify the region and cloud platform where your account is hosted.
Account name examples by region
If your account locator is
xy12345
:Cloud Platform / . Region
Account Locator . (with additional segments if required)
Amazon Web Services (AWS)
US West (Oregon)xy12345
US East (Ohio)xy12345.us-east-2.aws
US East (N. Virginia)xy12345.us-east-1
US East (Commercial Gov - N. Virginia)xy12345.us-east-1-gov.aws
Canada (Central)xy12345.ca-central-1.aws
EU (Ireland)xy12345.eu-west-1
Europe (London)xy12345.eu-west-2.aws
EU (Frankfurt)xy12345.eu-central-1
Asia Pacific (Tokyo)xy12345.ap-northeast-1.aws
Asia Pacific (Mumbai)xy12345.ap-south-1.aws
Asia Pacific (Singapore)xy12345.ap-southeast-1
Asia Pacific (Sydney)xy12345.ap-southeast-2
Google Cloud Platform (GCP)
US Central1 (Iowa)xy12345.us-central1.gcp
Europe West2 (London)xy12345.europe-west2.gcp
Europe West4 (Netherlands)xy12345.europe-west4.gcp
Microsoft Azure
West US 2 (Washington)xy12345.west-us-2.azure
East US 2 (Virginia)xy12345.east-us-2.azure
US Gov Virginiaxy12345.us-gov-virginia.azure
Canada Central (Toronto)xy12345.canada-central.azure
West Europe (Netherlands)xy12345.west-europe.azure
Switzerland North (Zurich)xy12345.switzerland-north.azure
Southeast Asia (Singapore)xy12345.southeast-asia.azure
Australia East (New South Wales)xy12345.australia-east.azure
Important
If either of the following conditions is true, your account locator is different than the structure described in the above examples:
If your Snowflake Edition is VPS, please contact Snowflake Support for details about your account locator.
If AWS PrivateLink or Azure Private Link is enabled for your account, your account locator requires a
privatelink
segment in place of the region segment.For more details, see:
When prompted by SnowSQL, enter the password for your Snowflake user.
For more details, see Connecting Through SnowSQL.