Getting Started With Worksheets¶
This topic describes how to get started using worksheets in Snowsight, the Snowflake web interface.
In this Topic:
Using the Worksheets Page¶
The Worksheets page lets you create, view, and manage your worksheets. The Worksheets page is the default page for Snowsight.
This section gives a brief overview of how to navigate and use the Worksheets page. This section includes examples and descriptions of the following interface elements:
Interface |
Description |
---|---|
The Worksheets page includes the following tabs:
|
|
Use Search, located in the upper-right corner of the page, to search the names and content of your Snowsight documents, such as worksheets and dashboards. |
|
The options menu, located in the upper-right corner of the Worksheets page, lets you:
|
|
Use Worksheet, located in the upper-right corner of the Worksheets page, to create a worksheet. |
Each tab includes a worksheets table. The worksheets table includes the following columns:
Title
Viewed
Updated
Role
You can sort by any column in the table. At the end of each row in the table, the worksheet owner is identified, as well as any users the worksheet is shared with.
To learn more about individual worksheets, see Querying Data Using Worksheets.
Managing Worksheets¶
To create an empty worksheet, in the upper-right corner of the page, select Worksheet.
To create a worksheet from an existing SQL script, on the options menu (), select Create Worksheet from SQL File.
To open a worksheet, go to one of the following Worksheets page tabs and select a worksheet:
- Recent
Displays the most recent worksheets you have opened.
- Shared With Me
Displays worksheets your colleagues have shared with you.
- My worksheets
Displays worksheets you created and own.
- Folders
Displays folders you created or your colleagues have shared with you. When you share a folder, all of the worksheets in the folder are shared.
Importing Worksheets From the Classic Web Interface¶
On the options menu (
), select Import Worksheets.
The Import Worksheets box appears, identifying the number of worksheets that are available to import.
Select Import.
Sharing Worksheets and Folders¶
Snowsight lets you send links to other Snowflake users to view or run worksheets and folders you own. Optionally, you can allow Snowflake users to duplicate shared worksheets to pursue new directions of analysis.
You can share worksheets, folders, and dashboards you own with other Snowflake users in your account.
Worksheets in Snowsight use unique sessions with specific roles and warehouses assigned in the context of the worksheet. To view shared query results, the Snowflake user must use the same role as the session context for the worksheet.
To share a worksheet:
Select a worksheet.
The worksheet opens.
In the upper-right corner of the worksheet, select Share.
To share a folder:
Select a folder.
The folder opens.
In the upper-right corner of the Worksheets page, select Share.
Internal Snowflake Objects for Worksheets¶
Snowflake creates the following internal objects to support using worksheets in Snowsight:
Object Type |
Name |
---|---|
Security integration |
WORKSHEETS |
Database |
WORKSHEETS_APP |
User |
WORKSHEETS_APP_USER |
Roles |
APPADMIN, WORKSHEETS_APP_RL |
These internal objects are used to cache query results in an internal stage in your account. This cached data is encrypted and protected by the key hierarchy for the account.
The limited privileges granted to the internal role only allow Snowsight to access the internal stage to store those results. The role cannot list objects in your account or access data in your tables.
The Snowsight user and role are returned when you query the USERS and ROLES views, respectively, in the ACCOUNT_USAGE schema in the SNOWFLAKE shared database. SHOW <objects> statements do not return these internal objects.