What you will be able to do
- Filter Snowsight Query History, including for client-generated statements and queries executed by user tasks
- Generate a chart from worksheet results and turn it into a dashboard tile
- Share worksheets and dashboards, and explain the role and link constraints on viewing shared charts
- Explain what happens to a dropped user's dashboards and worksheets, and how to keep them recoverable
1.Filtering Query History
In Snowsight, Monitoring » Query History shows queries run in your account over the last 14 days, either as individual queries or grouped. You can always see your own queries. What else you can see depends on your active role. ACCOUNTADMIN sees all query history for the account. A role with MONITOR or OPERATE on a warehouse sees other users' queries on that warehouse. To see all users' individual queries, a role needs ACCOUNTADMIN or IMPORTED PRIVILEGES on the SNOWFLAKE database. GOVERNANCE_VIEWER on its own unlocks only Grouped Queries in this page. Details for queries older than seven days don't include User information, but you can still use the User filter to find a user's queries. Filters use your current time zone, and setting TIMEZONE doesn't change that.
Besides Status, User and time period, you can filter on SQL Text, Query ID, Warehouse, Statement Type, Duration, Session ID, Query Tag and Parameterized Query Hash. The exam focuses on two filters that are off by default:
- Client generated statements shows internal queries run by a client, driver or library, including the web interface. For example, opening the Warehouses page in Snowsight runs a SHOW WAREHOUSES in the background. Your account isn't billed for these statements. - Queries executed by user tasks shows SQL statements executed, and stored procedures called, by user tasks.
A third filter, Show replication refresh history, shows the queries that perform replication refreshes. Turn on Auto Refresh to refresh the list every ten seconds.
Checkpoint 1 of 6· Match them up
Match each Query History filter to the statements it reveals
Tap a term, then the definition that fits it.
Client-generated statements are internal queries from drivers and the web interface, and your account isn't billed for them. Task-executed queries have their own separate filter.
“Client generated statements, to view internal queries run by a client, driver, or library, including the web interface.”Source: docs.snowflake.com
Checkpoint 2 of 6· Exam question
A BI analyst reruns an identical, expensive aggregation on a large table several times during the morning and expects instant results. The administrator wants to confirm which condition would force Snowflake to ignore the persisted result and recompute. Select TWO.(Select 2)
Correct answers: A, B — The query text includes a call to `RANDOM()`, a function whose result is not reusable, so the persisted result is bypassed.; Rows were inserted into the underlying table after the first run, so the stored result no longer reflects the current data.
- A. Correct: non-reusable functions such as RANDOM or UUID_STRING make the query ineligible for persisted-result reuse, so it executes again.
- B. Correct: reuse requires that the underlying table data has not changed; new inserted rows invalidate the stored result.
- C. Incorrect: running again from the same worksheet is fine; persisted results are reusable across sessions as long as the other conditions hold.
- D. Incorrect: result reuse does not depend on warehouse size, and a persisted result can even be returned without a running warehouse.
- E. Incorrect: results of all sizes are persisted for 24 hours; only the access token handling differs for results larger than 100 KB.
Sources1
2.Turning worksheet results into a chart
After you run a query in a worksheet, select Chart above the results table and Snowsight generates a chart automatically. The chart types are bar, line, scatterplot, heat grid and scorecard, and each query shows one chart type at a time. In the Data section you add or remove columns and change how a column is represented. Charts can bucket date columns by date, week, month or year and numeric columns by integer values. They then aggregate each bucket with average, count, minimum, maximum, median, mode or sum, so you can change the grain without editing the SQL. The Appearance section controls styling.
The chart updates whenever the query reruns, as long as its columns still exist. If a column is renamed, you have to point the chart at the new name. Keep cost in mind too: generating charts and transforming data in worksheets can use compute.
Checkpoint 3 of 6· Put it in order
Put the steps for displaying a chart of query results in order
- 1.Run the worksheet.
- 2.Open a worksheet.
- 3.Above the results table for the query, select Chart.
A chart is built from query results, so the worksheet must be run before Chart is available above the results table.
“Above the results table for the query, select Chart.”Source: docs.snowflake.com
Sources2
3.Building dashboards to monitor activity
A dashboard is a collection of charts arranged as tiles, with each tile driven by a query. Create one from Projects » Dashboards » + Dashboard, or from a worksheet with Move to » New dashboard. Moving a worksheet into a dashboard takes it out of your worksheet list, and anyone you'd shared the worksheet with loses access to it. Tiles show a chart by default. Unplace Tile removes a tile but keeps its query. Delete removes the tile and its query permanently, along with any other tile that uses the same query. A context selector sets the role and warehouse the dashboard's queries run with, and Run refreshes every tile.
There is no special monitoring widget in these sources. A monitoring dashboard is ordinary tiles over activity data. Snowflake exposes that data through the QUERY_HISTORY and AGGREGATE_QUERY_HISTORY views in the SNOWFLAKE database's ACCOUNT_USAGE schema, and through the INFORMATION_SCHEMA QUERY_HISTORY table functions. Charting those queries as tiles gives you a monitoring view that runs under the dashboard's role and warehouse. The documentation says Legacy Dashboards and Legacy Worksheets are removed on June 22, 2026, and Workspaces replaces worksheets for SQL editing.
Checkpoint 4 of 6· Check yourself
You move a worksheet that you'd shared with two colleagues into a new dashboard. What happens to the colleagues' access?
Creating a dashboard from a worksheet removes the worksheet, revokes its permissions and breaks its links. The query now lives only in the dashboard.
“those users lose access to the worksheet when you create a dashboard because the worksheet is removed when the dashboard is created.”Source: docs.snowflake.com
4.Sharing worksheets, dashboards and charts, and the limits
You share a chart with other people by sharing the worksheet or dashboard that contains it. Worksheets: open the worksheet, select Share, invite users, choose their permissions, and optionally set what people with the link can access. Recipients get the most recently run version of the worksheet. Dashboards: editors and owners can share with individual collaborators or with a link.
| Constraint | Consequence |
|---|---|
| Viewer role | The viewer must use the same role as the session context for the dashboard's queries |
| Primary role only | DEFAULT_SECONDARY_ROLES is ignored |
| Invite list | Only shows users who have previously signed in to Snowsight; share a link to reach anyone else |
| Link default | People with the link cannot view the dashboard until you change the setting |
| View without Run | You can let people view results without running the underlying queries |
| Organization | You cannot organize dashboards into folders |
Checkpoint 5 of 6· Check yourself
You want to share a dashboard chart with an analyst who has never signed in to Snowsight. What works?
The invite list only shows users who have signed in to Snowsight before, so you send a link instead. People with the link can't view the dashboard by default, so you have to change that setting first.
“By default, people with the link cannot view the dashboard.”Source: docs.snowflake.com
5.Recovering dropped dashboards
The available documentation covers dashboard recovery in one situation: when the user who owns the dashboards is dropped. In that case, the user's folders, worksheets and dashboards become inaccessible and aren't transferred to anyone else unless they were shared. Recipients with View, View + Run or Edit permission keep that access, but only users with Edit permission can modify or delete the shared items. If no one else has Edit, the owner's items can't be deleted at all. For worksheets that weren't shared, an administrator can recover up to 500 worksheets per dropped user. Unshared dashboards have no equivalent: they stay inaccessible.
In practice, recovering a dashboard comes down to sharing it before the owner is dropped, ideally giving Edit permission to at least one other user. These sources don't describe restoring a dashboard that someone deleted directly, and Snowsight warns that deleting a tile can't be undone.
Checkpoint 6 of 6· Check yourself
An administrator drops a departing employee. Their dashboards were never shared. What can the administrator recover?
Administrators can recover up to 500 unshared worksheets of a dropped user, but unshared dashboards stay inaccessible.
“If a dropped user’s worksheets do not have sharing enabled, an administrator can recover up to 500 worksheets owned by the user.”Source: docs.snowflake.com
Sources5
Exam traps
Each one states something that sounds right. Open it to see what is actually true.
1.The SHOW statements that Snowsight runs in the background are billed like any other query, so they should appear in the default Query History view.Why is that wrong?
They are client-generated statements. They only appear when you turn on that filter, and your account isn't billed for them.
Covered in Filtering Query History
2.Anyone you share a dashboard with can see its charts, whatever role they use.Why is that wrong?
Viewers must use the same role as the session context for the dashboard's queries, and secondary roles are ignored.
Covered in Sharing worksheets, dashboards and charts, and the limits
3.Deleting a tile only hides it, and you can bring its query back later.Why is that wrong?
Delete removes the tile and its query permanently. To keep the query, use Unplace Tile.
Covered in Building dashboards to monitor activity
Practise it for real
Chart sample order data in a worksheet and promote it to a dashboard tile
1.Open a worksheet and run a query that counts orders by O_ORDERDATE from SNOWFLAKE_SAMPLE_DATA.TPCH_SF1.ORDERS.
Why: Charts are generated from query results, so you need results first.
You should see: A results table with an order count and a date column.
2.Above the results table, select Chart.
Why: Snowsight builds a chart from the results automatically.
You should see: A chart that you can inspect by hovering over the data points.
3.Change the chart type to Bar, then change the date column's bucketing from day to month in the Data section.
Why: Bucketing changes the grain without editing the SQL.
You should see: Monthly bars that show aggregated order counts.
4.From the worksheet name, choose Move to » New dashboard and name it.
Why: This turns the worksheet into a dashboard tile.
You should see: A dashboard with a chart tile, and the worksheet gone from your worksheet list.
Stuck? Get a nudge
If the chart says a column can't be found, you probably renamed it in the SQL. Point the chart at the new column name.
Sources
Every claim above is drawn from one of these pages, quoted as it was written on the date shown.
- 1.
“The Query History page lets you explore queries executed in your Snowflake account over the last 14 days.”
↩︎ Filtering Query History“Queries executed by user tasks, to view SQL statements executed or stored procedures called by user tasks.”
↩︎ Filtering Query History“If your active role is the ACCOUNTADMIN role, you can view all query history for the account.”
↩︎ Filtering Query History“Details for queries executed more than seven days ago do not include User information”
↩︎ Filtering Query History“The QUERY_HISTORY view and AGGREGATE_QUERY_HISTORY view in the ACCOUNT_USAGE schema of the SNOWFLAKE database.”
↩︎ Building dashboards to monitor activity“Your account is not billed for client-generated statements.”
↩︎ Exam trap 1“Client generated statements, to view internal queries run by a client, driver, or library, including the web interface.”
↩︎ Checkpoint - 2.
“Each query supports one type of chart at a time.”
↩︎ Turning worksheet results into a chart“If a column name changes, you must update the chart to use the new column name.”
↩︎ Turning worksheet results into a chart“Chart generation and data transformations in worksheets can result in compute usage.”
↩︎ Turning worksheet results into a chart“Above the results table for the query, select Chart.”
↩︎ Checkpoint - 3.
“Dashboards are flexible collections of charts arranged as tiles.”
↩︎ Building dashboards to monitor activity“Legacy Dashboards will be removed from Snowflake on June 22, 2026.”
↩︎ Building dashboards to monitor activity“Editors and owners can share a dashboard with individual collaborators or by enabling and using link sharing.”
↩︎ Sharing worksheets, dashboards and charts, and the limits“The list only shows users that have previously signed in to Snowsight.”
↩︎ Sharing worksheets, dashboards and charts, and the limits“To view shared dashboards, the Snowflake user must use the same role as the session context for the queries that drive the dashboard.”
↩︎ Exam trap 2“Deleting a tile from a dashboard also deletes the underlying queries. This action cannot be undone.”
↩︎ Exam trap 3“those users lose access to the worksheet when you create a dashboard because the worksheet is removed when the dashboard is created.”
↩︎ Checkpoint“Dashboards run exclusively with the user’s primary role, regardless of the value set for DEFAULT_SECONDARY_ROLES.”
↩︎ Prediction“By default, people with the link cannot view the dashboard.”
↩︎ Checkpoint - 4.
“The worksheet that is shared is the most recently run version.”
↩︎ Sharing worksheets, dashboards and charts, and the limits - 5.
“the folders, worksheets, and dashboards owned by that user become inaccessible and do not transfer to another user unless sharing is enabled.”
↩︎ Recovering dropped dashboards“dashboards will be inaccessible if they were not previously shared with another user.”
↩︎ Recovering dropped dashboards“only users with Edit permissions can modify or delete the shared folders, worksheets, and dashboards.”
↩︎ Recovering dropped dashboards“If a dropped user’s worksheets do not have sharing enabled, an administrator can recover up to 500 worksheets owned by the user.”
↩︎ Checkpoint