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 tab list.

Worksheets page tabs

The Worksheets page includes the following tabs:

  • Recent

  • Shared with me

  • My Worksheets

  • Folders

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.

For assistive technology, the options button.

Options menu

The options menu, located in the upper-right corner of the Worksheets page, lets you:

  • Create a folder.

  • Import worksheets.

  • Manage filters.

  • Create a worksheet from a SQL file.

For assistive technology, the worksheet button.

Create worksheet

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 (For assistive technology, the options button.), 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

  1. On the options menu (For assistive technology, the options button.), select Import Worksheets.

    The Import Worksheets box appears, identifying the number of worksheets that are available to import.

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

  1. Select a worksheet.

    The worksheet opens.

  2. In the upper-right corner of the worksheet, select Share.

To share a folder:

  1. Select a folder.

    The folder opens.

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

Back to top