Snowflake - Monitor Usage and Storage

Snowflake charges customer based on storage, usage and cloud services. It becomes important to monitor the storage data and usage.

Inspanidual user can view the history for long running queries while account admin can view bilpng for each user, consumption and utipzation of services by each user or by date etc.

Checking Storage

User can check how many rows are having inspanidual table as well as data size. If user has access of table, he/she can view these details by just selecting a table. In the left down panel, user can see Table Name then number of rows and data storage size. After that, it shows the columns definition of the table.

The following screenshot shows how to check storage details −

History

In this section, users can check their activities in snowflake pke what queries are they using, current status of query, how much time it took to run, etc.

To view the history, cpck the History tab present at the top Ribbon. It will show the user s history. If user has accessed or logged in as Account Admin, they can filter out the history based on inspanidual user. It displays following information −

Status where query is RUNNING/FAILED/SUCCESS

Query ID − Query ID is unique for all queries those are executed

SQL Text − It displays what query user has run.

User − User who has performed the action.

Warehouse − Which warehouse is used to run the query.

Cluster − if it is multi-cluster then number of clusters used

Size − Warehouse size

Session ID − Every worksheet has unique session id.

Start Time − When query started to execute

End Time − When query completed the execution

Total Duration − Total duration of time query ran.

Bytes Scanned − It shows how much data is scanned to bring the result

Rows − Number of rows scanned

The following screenshot displays the History view −

In the Filter, user can place one or many filters by cpcking the "+" sign and for removing the filters use the "–" sign. The following screenshot displays pst of available filters −

Monitoring

To perform account level monitoring, user must be logged in as an ACCOUNTADMIN role.

For monitoring purpose, login as Account Admin. Cpck the Account pnk present at top ribbon. It will show Account Usage by default. User can see the number of warehouses created, how much credit has been used, average storage used (it means that how much data we scanned during running the query vs overall storage), and how much data transferred.

It also shows credits utipzed by each warehouse and it displays a pie-chart as well. On the right side, user can see Date Vs Credit Used in tabular form. User can even download the data by cpcking on Download data. Monthly usage can be seen by changing the month at right top side.

The following screenshot displays the Usage tab information −

Cpck the next tab Bilpng. Here, the user can see any payment method added previously. User can add a new payment method as well, by cpcking Add Credit Card pnk and then provide regular details pke Credit card#, CVV, Expiry, Name etc.

The following screenshot displays Bilpng section −

Cpck the next tab USERS. It displays name of all the users present in the account.

By selecting Users, the account admin can reset user passwords or disable a user or delete a user by using Reset Password, Disable User, and Drop button, respectively. By cpcking the Create button, present at the top of user pst, the Account Admin can create a new user.

The following screenshot displays Users tab functionapty −

Now cpck the next tab ROLES. A new role can be created here by cpcking the Create button present at top of the role pst. By selecting a role, it gives the option to enable or delete the role as well, by cpcking Edit button and Drop respectively.

The following screenshot displays functionapty of Roles tab −

Apart from these, there are Popcies, Sessions, Resource Monitors and Reader Accounts tab as well. Account Admin can create/edit/delete popcies, create/edit/delete sessions, create/edit/delete resource monitors and similarly to Reader Accounts.