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