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
In a nutshell
  • 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.

Watch out

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.

Queryrun in worksheetChartbar, line, scatter, heat grid, scorecardDashboard tilerole and warehouseShareusers or link

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:

QuestionSource view
Credits by warehouseWAREHOUSE_METERING_HISTORY
Slow or failed queriesQUERY_HISTORY
Failed sign insLOGIN_HISTORY
Storage growthSTORAGE_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_ROLES says.
  • 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.
Exam tip

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 worksheetWhat the recipient can do
EditChange contents, run with another role, manage versions, share, move
View and RunSee the latest results and run if they have the worksheet's role; can duplicate and run with their own role
View ResultsSee the latest results if they have the role; can duplicate
Link with View and RunRun and see results with the worksheet role, but not duplicate or run contents
Link with View ResultsSee 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.

Owner shares dashboardRecipient opensmust use same roleSees resultsor runs queries if allowed

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:

ConstraintEffect
Role dependenceThe recipient needs the role used to generate the results to see them
Run permissionWithout run permission the recipient sees only the last results, not fresh data
Not yet signed in to SnowsightCannot be named directly; use link sharing
Link defaultA link does not grant view access until you allow it
Data privilegesRunning the queries still needs privileges on the underlying objects
One chart type per queryA 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 ACCOUNTADMIN through 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 ACCOUNTADMIN function 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.