By default, the preview Worksheet is enabled for recent Snowflake accounts. If it is not enabled for your account, please contact Snowflake Support
to request it.

When the preview period ends, all accounts and users will be switched over to this Worksheet.

The Worksheet provides a powerful and versatile interface for creating and submitting SQL queries, as well as performing all DDL and most DML operations, and viewing the results as
your queries/operations complete.

Worksheets are designed to meet all your business and workflow needs, including:

Running ad hoc queries and performing other SQL operations.

Opening multiple, concurrent worksheets, each with its own separate session, allowing you to run queries in different worksheets with different contexts without any degradation in UI performance.

Saving a worksheet for later use.

Opening a worksheet from your library of saved worksheets.

Note

Saved worksheets are not accessible outside of the Snowflake web interface.

Saved worksheets cannot currently be shared with other users.

Loading SQL script files from your workstation or network into a worksheet. After you’ve loaded a script file, you can optionally edit and save it to your library of saved worksheets.

Logging out without losing your work. Snowflake retains the static contents of each worksheet, so you can log in again later and resume working where you left off. Snowflake displays the worksheets
that were open when you logged out.

Note that resized/collapsed panes, width changes to the Result/Data Preview columns, and even the cursor position in the SQL editor, are persisted:

When switching between open worksheets.

When closing and reopening the same worksheet.

Between user sessions.

Specify a different role for each worksheet and switch roles without losing your work. You can execute specific statements in a worksheet, then switch roles before continuing your work in the same
worksheet.

Note

Your current interface role determines the default role for worksheets that you open, but the worksheets are not tied to the interface role. Each worksheet has its own role that can be set
independently.

Log into Snowflake in another browser or tab. Any worksheet changes you made in one Snowflake instance persist to the other instance after a minute or two. You can continue working in the other
browser (or tab) without re-entering your work.

Refresh your browser, if necessary. If you’re in the middle of running queries, they will resume running when the refresh is completed. Note that if you log out of Snowflake, any active queries
stop running.

You can also perform other tasks on this page, including:

Resize the current warehouse to dynamically increase or decrease the compute resources utilized for executing your queries and DML statements.

Export the result for a selected query/statement (if the result is still available). For more information, see Exporting Query Results.

The object browser enables users to explore all databases, schemas, tables, and views accessible by the role selected for a worksheet.

The list of databases and other objects refreshes automatically when the worksheet context is changed. Users can also click the refresh button at the top of the object browser to view object
changes immediately.

The object browser can be collapsed at any time to make more room for the SQL editor and results/history panes.

Search for databases, schemas, tables, and views using the Find database objects field. Note that searches are “starts with” searches, and are also case-insensitive unless the search string is
enclosed in double quotes.

You can also search within a database or schema using the search icon that appears for the item when you hover over it in the object browser.

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 SQL editor in a worksheet supports the following keyboard keys and key combinations for formatting your queries and other SQL statements:

Tab Stops:

To insert a tab stop in a line (in 4 character intervals), use the [TAB] key:

If the cursor is at the beginning of the line, 4 blank spaces are inserted.

If the cursor is in the line, enough blank spaces are added to reach the next tab stop.

Indents/Outdents:

To indent/outdent a line (or multiple lines) 2 blank spaces, place the cursor anywhere in the line (or highlight the desired lines), hold down the [CMD] (Mac) or [CTRL]
(Windows) key and type one or more:

Right square brackets, ], to indent the line(s) the number of brackets typed.

Left square brackets, [ , to outdent the line(s) the number of brackets typed.

If a line is indented, all new lines after the indented line are automatically indented the same number of blank spaces.

Comments:

To comment out a line (or multiple lines), place the cursor anywhere in the line (or highlight the desired lines), hold down the [CMD] (Mac) or [CTRL] (Windows) key and type a
forward slash, /.

Text Highlighting:

To enable or disable text highlighting in all open worksheets, place the cursor anywhere in a worksheet, hold down the [SHIFT]+[CMD] (Mac) or [SHIFT]+[CTRL] (Windows)
keys and type the letter K.

Add Multiple Cursors:

To add multiple cursors in the same worksheet, hold down the [CMD] (Mac) or [CTRL] (Windows) key and click in each new location using the mouse left button or
the touchpad.

Select Text Area:

To select a text area, hold down the [OPTION] (Mac) or [ALT] (Windows) key. The cursor turns into a crosshair. Cick and drag using the mouse left button or the
touchpad.