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.

Signing Into a Different Snowflake Account

Navigation

User menu » Sign Into Another Account.

This menu option is available for use by users who have logins in multiple Snowflake accounts and who switch between accounts to perform their work.

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.

Setting User Preferences

Navigation

User menu » Preferences.

The following preferences can be set:

Profile Image

Upload an image to identify you in the row for each worksheet or dashboard that you own.

Notify when queries finish

Specify whether to display browser notifications when queries finish executing.

Click the Enable notifications button. The browser displays a confirmation dialogue; accept the decision. Select When queries finish in the background from the Notify when queries finish dropdown list. Click the Save button.

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.