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 classic web interface

This 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:





Load Data

Transfer Ownership





File Formats


Warehouses Page

Warehouses page in the classic web interface

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 classic web interface

This page 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 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).

For more details, see Using Worksheets for Queries / DML / DDL.

History Page

History page in the classic web interface

This 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.

For more details, see Using the History Page to Monitor Queries.

Help Menu

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

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 client (SnowSQL) 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 Menu

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

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:

  • Switch languages for the user session (if additional languages have been enabled for your account).

  • Set your email address for notifications (if you are an account administrator).

  • Log out (close your current session and exit the classic web interface).

  • Determine the organization, edition, cloud platform, and region of the Snowflake account you are logged into.


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

Back to top