Snowsight Quick Tour¶
Once you have signed into 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.
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.
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.
For more details, see Using Worksheets in Snowsight.
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.
To learn more about charts in the context of worksheets and dashboards, see Visualizing Worksheet Data.
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.
To learn more, see Snowsight: Managing Data.
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.
For information about accessing and using the Snowflake Marketplace in Snowsight, see the About Snowflake Marketplace.
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.
For more information, see Monitoring Activity.
Admin pages let you understand Snowflake data use, manage warehouses, monitor resources, manage users and roles, administer Snowflake accounts, and more.
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.