Introduction to the UI

The Snowflake web interface is easy to use and powerful. You can use it to perform almost every task that can be performed using SQL and the command line.

 

Watch a quick video introduction to the UI here.

 

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

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

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.

 

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 Snowflake web interface).

Help Menu

To access this menu, click the 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.

 

Learn even more about the Snowflake Web Interface here.