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 of snowflakecomputing.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 Virginia	`xy12345.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 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:
- AWS PrivateLink & Snowflake
- Azure Private Link & Snowflake

When prompted by SnowSQL, enter the password for your Snowflake user.

For more details, see Connecting Through SnowSQL.

Next: Step 2. Create Snowflake Objects