Quick Tour of the Web Interface

Once you have logged into the Snowflake web-based graphical interface, you can create and manage all Snowflake objects, including virtual warehouses, databases, and all database objects. You can also use the interface to load limited amounts of data into tables, execute ad hoc queries and perform other DML/DDL operations, and view past queries. And the interface is where you can change your Snowflake user password and specify other preferences, such as your email address.

In addition, if you have the required administrator roles, you can perform administrative tasks in the interface, such as creating and managing users. For more information about the administrative tasks you can perform, see Managing Your Snowflake Account.

In this Topic:

Databases Page

Databases page in the Snowflake web interface

The Databases page shows information about the databases you have created or have privileges to access. Tasks you can perform in this page (if you have the necessary privileges) include:

  • Create, clone, or drop a database.
  • Transfer ownership of a database to a different role.

In addition, you can click the name of a database to view and perform tasks on the objects in the database:

  Create Clone Drop Modify Load Data Transfer Ownership
File Formats  

Warehouses Page

Warehouses page in the Snowflake web interface

Each time you log into the interface, you start on the Warehouses page. This page shows information about the virtual warehouses you have created or have privileges to access. Tasks you can perform in this page (if you have the necessary privileges) include:

  • Create or drop a warehouse.
  • Suspend or resume a warehouse.
  • Configure a warehouse.
  • Transfer ownership of a warehouse to a different role.

Worksheet Page

Worksheet page in the Snowflake web interface

The Worksheet provides a powerful interface for entering and submitting SQL queries, as well as performing DDL and DML operations, and viewing the results side-by-side as your queries/operations complete. Tasks you can perform in this page include:

  • Run ad hoc queries and other DDL/DML operations in a worksheet, or load SQL script files.
  • Open up to six concurrent worksheets, each with its own separate session.
  • Save and reopen worksheets.
  • Log out of Snowflake or switch roles within a worksheet, as well as refresh your browser, without losing your work:
    • If you log out of Snowflake, any active queries stop running.
    • If you’re in the middle of running queries when you refresh, they will resume running when the refresh is completed.
  • Resize the current warehouse to increase or decrease the compute resources utilized for executing your queries and DML statements.
  • Export the result for a selected statement (if the result is still available).


The query details and results displayed in the worksheet are only maintained for your current user session. If you log out of the web interface and log back in, the results from your previous session are no longer displayed in the worksheet; however, you can use the History page to see queries you executed in previous sessions.

History Page

History page in the Snowflake web interface

The History page allows you to view and drill into the details of all queries executed in the last 14 days. The page displays a historical listing of queries, including queries executed from SnowSQL or other SQL clients. You can perform the following tasks on this page:

  • Filter queries displayed on the page.
  • Scroll through the list of displayed queries. The list includes (up to) 100 queries. At the bottom of the list, if more queries are available, you can continue searching.
  • Abort a query that has not completed yet.
  • View the details for a query, including the result of the query. Query results are available for a 24-hour period. This limit is not adjustable.
  • Change the displayed columns, such as status, SQL text, ID, warehouse, and start and end time, by clicking any of the column headers.

Help Menu

To access this menu, click the Help icon in the upper right:

Help menu in the Snowflake web interface

From the dropdown menu, choose one of the following actions:

  • View the Snowflake Documentation in a new browser tab/window.

  • Visit the Support Portal in a new browser tab/window.

  • Download… the Snowflake clients by opening a dialog box where you can:

    • Download the Snowflake CLI clients (SnowSQL and sfsql) and ODBC driver.
    • View download info for the Snowflake JDBC driver, Python components, Node.js driver, and Snowflake Connector for Spark.
  • Show help panel with context-sensitive help for the current page

User Preferences Menu

To access this menu, click the dropdown next to your login name in the upper right:

User menu in the Snowflake web interface

You can then change your password or security role for the session (if you have multiple roles assigned to you). For more information about security roles and how they influence the objects you can see in the interface and the tasks you can perform, see Access Control in Snowflake.

You can also use this dropdown to:

  • Set your email address for notifications (if you are an account administrator).
  • Close your current session and exit the Snowflake web interface.


When you exit the interface, Snowflake cancels any queries that you submitted during this session and are still running.