Logging in to Snowflake¶
You can log in to Snowflake in many ways.
If you’re getting started with Snowflake, start by using Snowsight or SnowSQL, the command line client that you can download. After you get comfortable using Snowflake, you can explore connecting to Snowflake with other methods.
Your Snowflake Account Identifier¶
All access to Snowflake is through your account identifier. See Account Identifiers for details.
Signing in Using Snowsight¶
You can access Snowsight over the Internet, or using private connectivity to the Snowflake service.
Using the internet¶
To access Snowsight over the public Internet, do the following:
In a supported web browser, navigate to https://app.snowflake.com.
Provide your account identifier or account URL. If you’ve previously signed in to Snowsight, you might see an account name that you can select.
Sign in using your Snowflake account credentials.
You can also access Snowsight from the Classic Console:
Using private connectivity¶
After completing the configuration to use private connectivity, access Snowsight:
To sign in to Snowsight with private connectivity directly, without having been logged in to the Classic Console previously:
Enter either of the following URLs in the browser location bar:
orgnameis the name of your Snowflake organization.
account_nameis the unique name of your account within your organization.
cloud_region_idis the identifier for the cloud region (controlled by the cloud platform).
After signing in, you can find these details in the account selector in Snowsight.
If you are unsure of the values to enter, please contact your internal Snowflake administrator before contacting Snowflake Support.
Enter your Snowflake credentials.
Starting from the Classic Console, to sign in to Snowsight using private connectivity to the Snowflake service:
For more information about the tasks you can perform in Snowsight, refer to Snowsight quick tour.
Logging in Using SnowSQL¶
SnowSQL is the command line client for connecting to Snowflake to execute SQL queries and perform all DDL and DML operations, including loading data into and unloading data out of database tables.
Step 1: Download and Install SnowSQL¶
You can download the SnowSQL installer from the SnowSQL Download page. No authentication is required. This version of the SnowSQL installer enables auto-upgrade for patches.
For more detailed instructions, see Installing SnowSQL.
Configuring the Z Shell Alias (macOS Only)¶
If Z shell (also known as zsh) is your default terminal shell, set an alias to the SnowSQL executable so that you can run SnowSQL on the command line in Terminal. The SnowSQL installer installs the executable in
/Applications/SnowSQL.app/Contents/MacOS/snowsql and appends this path to the PATH or alias entry in
~/.profile. Because zsh does not normally read this file, add an alias to this path in
~/.zshrc, which zsh does read.
To add an alias to the SnowSQL executable:
Open (or create, if missing) the
Add the following line:
Save the file.
Step 2: Connect to Snowflake and Initiate a Session¶
From a terminal window, start SnowSQL from the command prompt using the following command:
$ snowsql -a <account_identifier>
<account_identifier>is your account identifier. Note that when you specify your account identifier, do not include the
You can further streamline login by specifying the
-uoption followed by your user login name:
$ snowsql -a <account_identifier> -u <user_login_name>
When prompted, enter your login name (if you didn’t provide it when executing SnowSQL) and your password.
If you specified a valid account identifier, user login name, and password, the SnowSQL prompt appears.
For security reasons, you cannot specify your password as an option on the command line; you must wait for SnowSQL to prompt you for your password.
However, if you would like to skip entering information on the command line or you need to automate login, you can provide all the required account and user credential information, as well as additional
Snowflake default usage information, as options in the SnowSQL
For more detailed installation, configuration, login, and usage information, see SnowSQL (CLI client).
Connecting Using Other Methods¶
In addition to the Snowflake web interface and SnowSQL, Snowflake supports numerous other methods for connecting, including:
Using 3rd-party client services and applications that support JDBC or ODBC.
Developing applications that connect through the Snowflake connectors/drivers for Python, Node.js, Spark, etc.
However, connecting to Snowflake using these other methods requires additional installation, configuration, and development tasks. For more information, see Connect to Snowflake.