Using Worksheets in Snowsight¶
Worksheets provide a powerful and versatile method for running SQL queries or Python code, as well as performing other Snowflake data loading, definition, and manipulation tasks.
After you open a worksheet in Snowsight, you can do any of the following:
In addition, you can write SQL statements and visualize the results. You can also write Python code.
Browse Other Worksheets from a Worksheet¶
When you open a worksheet, you can view other worksheets in the Worksheets explorer. You can search for other worksheets and manage worksheets from the Worksheets explorer.
Previewing Worksheet Contents¶
To preview the contents of a worksheet, you can hover over the name of the worksheet in the Worksheets explorer. The preview also shows the role used to run the worksheet.
From the preview, you can also copy the contents of the worksheet. Hover over the worksheet contents preview and select the Copy button that appears.
Update Worksheets with Keyboard Shortcuts¶
Snowsight provides keyboard shortcuts to help you quickly navigate and edit queries in worksheets. For example, you can move your cursor within a worksheet, perform find and replace, copy lines, format queries, and more using hotkeys.
To see all available keyboard shortcuts, open a worksheet and press [CMD]+[SHIFT]+[?] on a Mac keyboard or [CTRL]+[SHIFT]+[?] on a Windows keyboard.
You can also hover over the tab for the worksheet and select , then choose Show Shortcuts to view the shortcuts.
Switching Worksheet Versions¶
If you want to view past versions of a worksheet, do the following:
Sign in to Snowsight.
Select Worksheets to open the list of worksheets.
Open the worksheet.
Select the Updated timestamp for the worksheet.
From the drop-down list of worksheet versions, select the timestamp of the version that you want to open.
New versions of a worksheet are saved when you make changes and run a SQL query or the code in the worksheet.
Change the Session Context for a Worksheet¶
Set the session context for a worksheet to define the role and warehouse to use to run the contents of a worksheet. The worksheet context is preserved for future sessions.
Note
You cannot choose multiple roles. The context selector does not support secondary roles. To enable secondary roles in a SQL worksheet, run USE SECONDARY ROLES.
The role context for a worksheet determines which operations can be performed on Snowflake objects based on the access control privileges granted to the role.
To set the session context for a worksheet, do the following:
Sign in to Snowsight.
Select Worksheets to open the list of worksheets.
Open a worksheet.
Open the context selector.
Select a role to run the worksheet as.
Select a warehouse that the role has privileges to use.
Select anywhere outside the drop-down to close the context selector.
Note
Each worksheet is a unique session and can use roles different from the role you select on the user menu (your active role). Changing your active role does not change the role assigned to the worksheet with the context selector.
Resuming and Resizing Warehouses¶
Before or after you run your worksheet, you might need to resume or resize your warehouse.
You must have MODIFY or OWNERSHIP privileges on the warehouse to alter warehouse details.
To view and adjust warehouse details using the context selector, do the following:
Sign in to Snowsight.
Select Worksheets to open the list of worksheets.
Open a worksheet.
Open the context selector.
Select the Show warehouse details icon.
For the Status option, select the status and choose Resume if the warehouse is suspended.
For the Size option, select the size and choose a different size.
Select anywhere outside the drop-down to close the context selector.