View full changelog

Quickly understand a Snowflake Table's Top Users

Date
  • Ian Gray
    Software Engineer at SELECT

If you are planning to deprecate a table in Snowflake, or there is a data quality issue, it is important to understand which people or systems are using the table. SELECT customers can now easily understand which users are regularly accessing a Snowflake table, and see the associated costs.

Snowflake tables top users table by cost

From the table page, click the Users tab to see a history of all Snowflake users that used the table within the given time range. By default, the table is ordered by cost, but you can sort it by any other column.

It is common practice for BI tools to use a single Snowflake user. To give deeper insights in this case, add the “BI Tool User” column, which highlights the BI tool username.

Snowflake tables top users with optional BI tool user column enabled

Not available for Snowflake Standard Edition Customers

This feature relies on the Snowflake access history view which is not available for customers on the Standard Edition of Snowflake.

Get up and running with SELECT in 15 minutes.

Snowflake optimization & cost management platform

Gain visibility into Snowflake usage, optimize performance and automate savings with the click of a button.

SELECT web application screenshot

Want to get notified when we release new features? 
Subscribe to get notified.