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, for an account named xy12345:

    If the account is in: Account name is:
    AWS US West xy12345
    AWS US East xy12345.us-east-1
    AWS EU (Dublin) xy12345.eu-west-1
    AWS EU (Frankfurt) xy12345.eu-central-1
    AWS Asia Pacific (Singapore) xy12345.ap-southeast-1
    AWS Asia Pacific (Sydney) xy12345.ap-southeast-2
       
    Azure East US 2 xy12345.east-us-2.azure
    Azure West Europe xy12345.west-europe.azure
    Azure Australia East xy12345.australia-east.azure

    Important

    The structure of your account name is different if either of the following is true:

    • Your Snowflake Edition is VPS. For account name details, please contact Snowflake Support.
    • AWS PrivateLink is enabled for your account, in which case 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