Quick Tour of the Web Interface

Snowflake provides a web-based graphical interface for creating and monitoring 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 other DML/DDL, and view past queries. And the interface is the easiest place to change your Snowflake user password and specify other preferences.

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

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
Tables  
Views      
Schemas    
Stages  
File Formats  
Sequences  

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

Note

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 the help 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...

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

User Preferences Menu

User menu in the Snowflake web interface

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 and the tasks you can perform in the interface, see Understanding Access Control in Snowflake.

You can also use this dropdown to close your current session and exit the Snowflake web interface.

Important

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