Step 1. Log into SnowSQL

After SnowSQL is installed (see Prerequisites for details), to log in:

  1. Open a terminal window.

  2. 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:

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

For more details, see Connecting Through SnowSQL.

Next: Step 2. Create Snowflake Objects