Logging into Snowflake

When logging into Snowflake for the first time, we recommend using either the web-based user interface or SnowSQL (the command line client available for download from the interface).

Then, once you’re more familiar with Snowflake, you can explore connecting to Snowflake using other methods.

In this Topic:

Logging in Using the Web Interface

The Snowflake web interface is accessible via a URL of the form https://<account_name>.snowflakecomputing.com, where account_name is the name assigned to your account by Snowflake (e.g. abc123 in https://abc123.snowflakecomputing.com). Note that a secure (https) connection is required:

  1. Point your browser at the Snowflake URL for your account.

    If your web browser is able to communicate with the Snowflake service, the following login screen is displayed:

    Snowflake web interface login page
  2. Enter your credentials (user login name and password) and click Log In.

For more information about the tasks you can perform in the web interface, see Quick Tour of the Web Interface.

Logging in Using the Command Line Client (SnowSQL)

SnowSQL is our next-generation 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.

Downloading and Installing SnowSQL

  1. After logging into the Snowflake web interface (see above), go to:

    Help > Download...

  2. In the Downloads dialog, click CLI Client (snowsql):

    CLI Client (SnowSQL) option in Downloads dialog
  3. In the dialog, click the download icon for your platform. The downloaded file is saved as:

    Windows:snowsql-windows_x86_64.msi
    Linux:snowsql-linux_x86_64.bash
    Mac OS:snowsql-darwin_x86_64.pkg
  4. Run the installer for your platform:

    Windows:Double-click the snowsql-windows_x86_64.msi file.
    Linux:Type bash snowsql-linux_x86_64.bash on the terminal command line.
    Mac OS:Double-click the snowsql-darwin_x86_64.pkg file.
  5. Follow the instructions provided by the installer.

Connecting to Snowflake using SnowSQL

  1. From a terminal window, start SnowSQL from the command prompt using the following command:

    $ snowsql -a <account_name>
    

    Where account_name is the name assigned to your account by Snowflake. You can find your account name in the URL you received from Snowflake. Your account name is the first segment in the domain (e.g. abc123 in https://abc123.snowflakecomputing.com).

    You can further streamline login by specifying the -u option followed by your user login name:

    $ snowsql -a <account_name> -u <user_login_name>
    
  2. When prompted, enter your login name (if you didn’t provide it when executing SnowSQL) and your password.

If you specified a valid account, user login name, and password, the SnowSQL prompt appears.

Tip

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 config file.

For more detailed installation, configuration, login, and usage information, see Snowflake CLI Client (SnowSQL).

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, or Spark.

However, connecting to Snowflake using these other methods requires additional installation, configuration, and development tasks. For more information, see Connecting to Snowflake.