Getting Started with Snowflake (Log in to SnowSQL)

739 viewsNative Apps Frameworksnowflakenativeapps

Getting Started with Snowflake (Log in to SnowSQL):

Alejandro Penzini Edited question December 13, 2023

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:
Copy code
$ 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:

Copy code
$ snowsql -a -u --authenticator externalbrowser
For additional information, see Using a Web Browser for Federated Authentication/SSO.

Password Entry:

When prompted by SnowSQL, enter the password associated with your Snowflake user.
Successful Login:

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.

Additional Note:
If your Snowflake user lacks default warehouse, database, and schema settings, or if SnowSQL was not configured with defaults, the prompt will indicate:

Copy code
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.

Alejandro Penzini Answered question December 13, 2023

Maximize Your Data Potential With ITS

Feedback on Q&A