Step 1. Log into SnowSQL

.

Step List

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 name is xy12345:

    Cloud Platform / Region

    Full Account Name

    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
    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

    GCP
    US Central1 (Iowa)

    xy12345.us-central1.gcp
    Europe West2 (London)

    xy12345.europe-west2.gcp
    Europe West4 (Netherlands)

    xy12345.europe-west4.gcp

    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 name is different than the structure described in this example:

    • If your Snowflake Edition is VPS, please contact Snowflake Support for details about your account name.

    • If AWS PrivateLink is enabled for your account, your account name requires an additional privatelink segment. For more details, see AWS PrivateLink & Snowflake.

  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