Where users run queries dashboard
See who is running queries in Snowflake, how many they run, and which warehouses and accounts they use. It’s a quick way to spot users running queries on warehouses they shouldn’t be, or to understand who drives usage. The dashboard shows the last 30 days by default and supports up to 6 months of history.
Roles for viewing this dashboard
- Tenant admin
Access the dashboard
- From the left navigation menu, go to Dashboards, then Where users run queries.
- Set the Date range. It defaults to the last 30 days, and you can select up to 6 months.
- Optionally, narrow the results by Users, Tags, or Filters.
Usage at a glance
The top row summarizes activity for your selected date range and filters:
- Active users: users who ran at least one query
- Total queries: total queries run
- Avg queries per user: total queries divided by active users
- Warehouses used: distinct warehouses that were queried
Active users over time
A bar chart of active users per period. Choose Monthly, Weekly, or Daily to change the period length.
User listing
A table with one row for each combination of user, account, and warehouse:
- User name
- Account name
- Warehouse name
- Bytes scanned
- Query count
- Cost
Select any column header to sort by that column. To open a warehouse’s detail page, select the link icon in its row. If the warehouse was deleted or deactivated, or its account isn’t connected to Slingshot, an info icon appears instead and explains why.
Filter the data
- Date range: up to 6 months, within the last 6 months of history
- Users: one or more users
- Tags: Slingshot org tags, or a Snowflake or external tag on a warehouse
- Filters: Account, Region, and Warehouses
Export and take action
- Export CSV: download the data as a CSV file.
- Go to Optimizations: open Snowflake optimizations.
- Data last refreshed shows how current the data is.