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, depending on the cloud platform (AWS or Azure) and Snowflake Region where your account is hosted, the full account name may require additional segments, as shown in the following diagram:

    Structure of Snowflake account hostnames

    For example, if your account name is xy12345:

    Snowflake Region

    Full Account Name

    AWS

    US West

    xy12345

    US East

    xy12345.us-east-1

    Canada

    xy12345.ca-central-1

    EU (Dublin)

    xy12345.eu-west-1

    EU (Frankfurt)

    xy12345.eu-central-1

    Asia Pacific (Singapore)

    xy12345.ap-southeast-1

    Asia Pacific (Sydney)

    xy12345.ap-southeast-2

    Azure

    East US 2

    xy12345.east-us-2.azure

    US Gov Virginia

    xy12345.us-gov-virginia.azure

    West Europe

    xy12345.west-europe.azure

    Australia East

    xy12345.australia-east.azure

    Important

    If either of the following conditions is true, your account name is different than the structure described above:

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

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

    For more details about regions and platforms, see Snowflake Regions and Cloud Platforms.

  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