Snowsight Quick Tour

After Signing in to Snowsight , you can create and manage all Snowflake objects, including virtual warehouses, databases, and all database objects. You can also use the interface to load limited amounts of data into tables, execute ad hoc queries and perform other DML/DDL operations, as well as view past queries. You can also manage user information to change your Snowflake user password and specify other preferences, such as your email address.

In addition, if you have the required administrator roles, you can perform administrative tasks in the Snowsight, such as creating and managing users.

Some noteworthy Snowsight features include:

  • Worksheet Organization: Do you have tens or even hundreds of worksheets? You can now group them into Folders to stay organized! Furthermore, when you click into a worksheet, the left pane is a Worksheet list so you can navigate across worksheets even faster.

  • Coding Productivity: Snowsight brings you auto-complete, one of the favorite features of data analysts and developers everywhere. It covers database objects as well as our SQL functions.

  • Visualizations: Oftentimes, a visualization is the best way to gain insight into your data. After your query results are complete, contextual statistics show up to the right of results with distributions, sums, or counts of column type values - giving you a quick intuition about the shape of your data. You can also toggle on the Charts result, to see various result dimensions as graphs. And finally, you can create Dashboards from sets of SQL queries or charts from your results, enabling easy and visual ongoing monitoring.

  • Collaboration: One of the best parts of Snowsight is that you can leverage the expertise of your whole team. You can share worksheets, dashboards or entire folders with users across your Snowflake account. They can view your results, give feedback, or even commit direct edits to help your project make progress.

  • Usage Data: It’s easier than ever to view actual usage by specific users, warehouses, queries and other useful dimensions. Usage views provide data in either tabular or chart form, show aggregate consumption across all usage types and more, all from a single page.

  • Activity History: Snowsight allows more intuitive query history browsing as well as getting past queries out and into a worksheet in one click. Data loading history is viewable through the Copy History views, to easily scan for recently loaded data.

  • Roles and Users: The new “Tree” view for roles and grants makes understanding privileges a much easier task. Roles or users can be searched and modified quickly, making their management simpler than before.

Please see our Snowsight Blog Post for more information about getting started with the Snowsight UI.

For more information about these and other administrative tasks you can perform, see Snowsight: The Snowflake Web Interface.

Main Interface

The Snowsight interface is composed of three sections:

  • The user menu (1) - Use this menu to switch roles, modify your profile, access documentation or log out.

  • The Snowsight navigation menu (2) - Use this menu to select one of the various Snowsight areas such as Worksheets, Dashboards, Data, and others. If a selected feature includes sub-elements they are displayed beneath the associated menu item. For example, to select databases select Data » Databases.

  • Content pane (3) - When a Snowsight menu item is selected, the associated content is displayed in the content pane. Note that some elements have additional child elements.

Snowsight main interface page with sections hightlighted

Worksheets page

Worksheets provide a simple way for you to write SQL queries (DML and DDL), see the results, and interact with them. Tasks you can perform in this page include:

  • Running ad hoc queries and other DDL/DML operations in a worksheet.

  • Examining multiple worksheets, each with its own separate session.

  • Exporting result for a selected statement, while results are still available.

Worksheet page in the Snowsight interface

For more details, see Managing and Using Worksheets in Snowsight.

Dashboards page

Dashboard pages allow you to create, modify and examine Dashboards. Dashboards are flexible collections of charts arranged as tiles. Dashboard charts all start with SQL to generate results and associated charts. These charts can be shared with others, modified, or displayed as dashboard tiles.

Dashboard page in the Snowsight interface

To learn more about charts in the context of worksheets and dashboards, see Visualizing Worksheet Data.

Data pages

Data pages of Snowsight let you interact with your Snowflake data, including:

  • Exploring databases and objects, including tables, functions, views, and more using the Database object explorer, a powerful tool for navigating Database and related objects. Additionally you can use search to find and browse database objects account-wide.

  • Sharing data with other accounts and access data that is shared with you.

  • Using Provider Studio to manage your experience as a Snowflake data provider.

Data page(s) in the Snowsight web interface

To learn more, see Snowsight: Managing Data.

Snowflake Marketplace

Snowflake Marketplace pages allow data consumers to access and query available data sets and services to drive informed data-driven decisions. A significant Snowflake Marketplace benefit lies in that you can directly access shared data without setting up a data pipeline or doing any coding. Data providers can publish data sets or make data analytics services available to Snowflake data consumers. Data consumers securely access live and governed shared data sets directly from their Snowflake accounts, receiving automatic updates in real time.

Marketplace page(s) in the Snowsight web interface

For information about accessing and using the Snowflake Marketplace in Snowsight, see the About Snowflake Marketplace.

Activity pages

Activity pages lets you monitor and view query details, explore executed query performance, monitor a variety of data loading statuses, and examine Database object history. Snowsight Activity is broken into two areas: Query History and Copy History. Query history displays details of queries executed in your Snowflake account in the last 14 days. Copy History displays data loading activity that has occurred over the last 365 days for all tables in your account.

Activity page(s) in the Snowsight web interface

For more information, see Monitoring Activity.

Admin

Admin pages let you understand Snowflake data use, manage warehouses, monitor resources, manage users and roles, administer Snowflake accounts, and more.

Activity page(s) in the Snowsight web interface

For more information, see Administering Snowflake.

Help & Support

The Help & Support page lets you find helpful information about using Snowflake, managing your support cases, and more.

User Menu

The User menu lets you change your password or security role for the session. For more information about security roles and how they influence the objects you can see in the interface and the tasks you can perform, see Overview of Access Control.

To access this menu, click the dropdown menu below to your login name in the upper left.

You can also use this dropdown menu to:

  • Switch languages for the user session, when additional languages have been enabled for your account.

  • Set your email address for notifications, if you are an account administrator.

  • Log out and close your current session and exit.

  • Determine organization, edition, cloud platform, and region of the current Snowflake account.

Important

When you exit Snowsight, Snowflake cancels any queries that you submitted during this session that are still running.