Data and Object Management · Topic 11 of 11
Snowsight Charts, Dashboards, Sharing and Recovery
Visualize results with Snowsight charts, monitor activity with dashboards, share worksheets, dashboards and charts, and know limits and recovery.
- 5 min
- Chart types: bar, line, scatterplot, heat grid, scorecard; one chart type per query.
- Dashboards run with the primary role and chosen warehouse; viewers need the same role.
- Worksheet permissions: Edit, View and Run, View Results, plus link variants.
What it is
Snowsight is Snowflake's web interface. Besides running SQL, it can chart results, collect charts and tables into dashboards, and share that work with colleagues. An administrator uses these to watch activity (credits, warehouse load, failed logins) and to hand results to people who do not write SQL.
Legacy Worksheets are retired in favor of Workspaces, and Snowflake set June 22, 2026 as the removal date for Legacy Dashboards. The exam outline still lists these topics, so learn the concepts below, but check the current state of your own account.
How it works
Visualizing results with charts
After a query runs, select Chart above the results. The chart types are bar, line, scatterplot, heat grid and scorecard.
- A query supports one chart type at a time.
- You can change chart type, add or remove columns and adjust appearance. Available styling depends on the type.
- Date columns can be bucketed by date, week, month or year. Numbers can be bucketed by integer values. Each bucket is reduced with average, count, minimum, maximum, median, mode or sum.
- Charts update when you re-run the query as long as the columns still exist. If a column is renamed, update the chart.
- Chart generation and data transformations can use compute from the warehouse.
Dashboards to monitor activity
A dashboard is a set of charts and tables arranged as tiles. Each tile is backed by a query. Typical monitoring dashboards use SNOWFLAKE.ACCOUNT_USAGE views:
| Question | Source view |
|---|---|
| Credits by warehouse | WAREHOUSE_METERING_HISTORY |
| Slow or failed queries | QUERY_HISTORY |
| Failed sign ins | LOGIN_HISTORY |
| Storage growth | STORAGE_USAGE |
Key behaviors:
- The context selector sets the role and warehouse that run the dashboard queries.
- Dashboards run with the user's primary role; secondary roles are disabled in dashboards, whatever
DEFAULT_SECONDARY_ROLESsays. - Unplace Tile removes a tile but keeps its query. Delete removes the tile and its query and cannot be undone. If two tiles share a query, deleting one deletes both.
- Moving a worksheet into a dashboard removes it from the worksheet list; people it was shared with lose access and old links stop working.
- Dashboards cannot be organized into folders.
Give a monitoring dashboard a role that can read SNOWFLAKE.ACCOUNT_USAGE (through IMPORTED PRIVILEGES or a SNOWFLAKE database role) and a small warehouse, since viewers must use that same role to see the results.
Sharing worksheets and dashboards
Owners and editors can share. You can share directly with users who have signed in to Snowsight before; for anyone else, turn on link sharing.
| Permission on a worksheet | What the recipient can do |
|---|---|
| Edit | Change contents, run with another role, manage versions, share, move |
| View and Run | See the latest results and run if they have the worksheet's role; can duplicate and run with their own role |
| View Results | See the latest results if they have the role; can duplicate |
| Link with View and Run | Run and see results with the worksheet role, but not duplicate or run contents |
| Link with View Results | See the latest results and contents, but not run or duplicate |
Folders use the same permissions, and a worksheet put in a shared folder inherits them. Collaborators see the most recently run version; unrun edits stay private.
For dashboards, editors and owners share with individual users or by link. By default people with the link cannot view the dashboard, so you must allow it, and you can allow viewing results without running the queries. To view a shared dashboard, a user must use the same role as the dashboard's session context.
Sharing charts and constraints
A chart lives inside a worksheet or a dashboard tile, so you share a chart by sharing that worksheet or dashboard. There is no separate per chart sharing in the docs, and the same permissions and constraints apply:
| Constraint | Effect |
|---|---|
| Role dependence | The recipient needs the role used to generate the results to see them |
| Run permission | Without run permission the recipient sees only the last results, not fresh data |
| Not yet signed in to Snowsight | Cannot be named directly; use link sharing |
| Link default | A link does not grant view access until you allow it |
| Data privileges | Running the queries still needs privileges on the underlying objects |
| One chart type per query | A tile or worksheet query shows one chart type at a time |
Recovering dropped dashboards
The docs do not describe a self service restore for a deleted dashboard, and deleting a tile cannot be undone. What is documented:
- If a user is dropped, worksheets owned by that user can be recovered by
ACCOUNTADMINthrough Settings, General, Recover worksheets. It returns up to the 500 most recently modified worksheets as an archive. The title and contents of the most recently executed version come back, not version history, sharing settings or results. - That recovery covers worksheets only; no documented recovery exists for dashboards owned by a dropped user, so plan for them before dropping an owner.
The safe practice is to export the dashboard definition and its SQL to version control before deleting or retiring the user who owns it.
Common mistakes
Sharing a dashboard and not the role. The viewer sees nothing unless they use the matching role.
Deleting a tile to hide it. Delete is permanent and removes the query; use Unplace Tile.
Relying on secondary roles in a dashboard. They are disabled there.
Dropping a user who owns dashboards. The documented recovery covers worksheets only, so save the dashboard SQL first.
Sharing by name with a person who never opened Snowsight. Use a link.
What to remember for the exam
- Chart types: bar, line, scatterplot, heat grid, scorecard; one chart type per query.
- Dashboards run with the primary role and chosen warehouse; viewers need the same role.
- Worksheet permissions: Edit, View and Run, View Results, plus link variants.
- Charts are shared through their worksheet or dashboard.
- Delete tile is permanent; Recover worksheets is an
ACCOUNTADMINfunction for a dropped user.
Check yourself
Which role runs the queries of a dashboard?
The user's primary role in the dashboard context, with secondary roles disabled.
How do you share with a colleague who has never signed in to Snowsight?
Turn on link sharing and send the link.
What is the difference between Unplace Tile and Delete?
Unplace keeps the query; Delete removes the tile and its query and cannot be undone.
Topic 11 of 11 in Data and Object Management
Test yourself on Data and Object Management
The full Snowflake ADA-C02 question bank has 814 questions, with timed practice exams and an explanation for every answer.
This study guide is independent and is not affiliated with, endorsed by, or sponsored by Snowflake. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.