Step 1. Log into SnowSQL

After SnowSQL is installed (see Prerequisites for details), start SnowSQL to connect to Snowflake:

  1. Open a terminal window.

  2. Start SnowSQL:

    $ snowsql -a <account_identifier> -u <user_name>
    
    Copy

    Where:

Note

If your account has an identity provider (IdP) that has been defined for your account, you may use a web browser to authenticate instead of a password, as the following example demonstrates.

$ snowsql -a <account_identifier> -u <user_name> --authenticator externalbrowser
Copy

For more information, refer to Using a Web Browser for Federated Authentication/SSO.

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

If you log in successfully, SnowSQL displays a command prompt that includes your current warehouse, database, and schema.

Note

If you get locked out of the account and cannot obtain the account identifier, you can find it in the Welcome email that Snowflake sent to you when you signed up for the trial account, or you can work with your ORGADMIN to get the account details. You can also find the values for locator, cloud, and region in the Welcome email.

If your Snowflake user does not have a default warehouse, database, and schema, or if you did not configure SnowSQL to specify a default warehouse, database, and schema, the prompt displays no warehouse, no database, and no schema. For example:

user-name#(no warehouse)@(no database).(no schema)>
Copy

This prompt indicates that there is no warehouse, database, and schema selected for the current session. You create these objects in the next step. As you follow the next steps in this tutorial to create these objects, the prompt automatically updates to include the names of these objects.

For more details, see Connecting Through SnowSQL.

Next: Step 2. Create Snowflake Objects