Getting Started With Snowsight

This topic describes how to get started with Snowsight.

In this Topic:

Enabling Snowsight for Your Account

By default, Snowsight is enabled for account administrators (i.e. users with ACCOUNTADMIN role) only. Enabling Snowsight for all roles in your account requires a one-time setup.

  1. Log into Snowflake as an account administrator (or switch your session context to the ACCOUNTADMIN role after logging in).

  2. Click on Preview App Worksheets tab. The new web interface opens in a separate tab or window.

  3. Click Worksheets in the left-hand navigation bar. The Ready to Start Using Worksheets and Dashboards dialog opens.

  4. Click the Enable Worksheets and Dashboards button.

Snowsight is now enabled for all roles in your account.

Internal Snowflake Objects for Snowsight

The first time Snowsight is accessed in an account, Snowflake creates the following internal objects automatically to support the web interface:

Object Type

Name

Security integration

WORKSHEETS

Database

WORKSHEETS_APP

User

WORKSHEETS_APP_USER

Role

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.

Currently, the Snowsight user and role are returned when users 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.

Importing Worksheets from the Classic Web Interface

  1. Launch the new web interface. The home page displays the Get started panel.

  2. Click the Import Worksheets button. A confirmation dialog opens.

  3. Click the Import button to import your worksheets. The interface displays a success message that lists the number of worksheets imported.

Snowsight Orientation

Snowsight overview
  1. Perform actions on the open worksheet:

    • Move the worksheet to a new or existing folder or dashboard.

    • Duplicate the worksheet.

    • Apply standard SQL formatting to the query in the worksheet.

    • Delete the worksheet.

    In addition, you can open a dialog that shows supported keyboard shortcuts.

  2. Choose the session context (i.e. the current role, warehouse, and database for the user session).

  3. Write and edit queries in the query editor.

  4. Switch between activities: explore query results, create charts, and browse the schema.

  5. Create a new worksheet, share the current worksheet, or execute queries in the current worksheet.

  6. Open a previous version of the worksheet.