Once SnowSQL is installed, initiate the connection to Snowflake using the following steps:
1. Open a Command Line Window:
Launch your command line interface.
2. Start SnowSQL:
Enter the following command in the command line window:
$ snowsql -a -u
Replace with the unique identifier for your Snowflake account, following the preferred format: organization_name-account_name. Refer to Format 1 (Preferred): Account Name in Your Organization for more details.
is your Snowflake user login.
If your account utilizes an identity provider (IdP), enabling web browser authentication is an option. Use the following command:
$ snowsql -a -u –authenticator externalbrowser
For additional information, see Using a Web Browser for Federated Authentication/SSO.
When prompted by SnowSQL, enter the password associated with your Snowflake user.
Upon successful login, SnowSQL will display a command prompt containing information about your current warehouse, database, and schema.
If you encounter issues accessing your account and lack the account identifier, refer to the Welcome email sent by Snowflake upon trial account signup or collaborate with your ORGADMIN for account details. The Welcome email also provides values for locator, cloud, and region.
If your Snowflake user lacks default warehouse, database, and schema settings, or if SnowSQL was not configured with defaults, the prompt will indicate:
user-name#(no warehouse)@(no database).(no schema)>
This signifies that no warehouse, database, or schema is selected for the current session. These objects will be created in the subsequent steps of the tutorial, and the prompt will automatically update to reflect their names.
For more comprehensive information, consult Connecting Through SnowSQL.