Storage Spend Summary
Spendview for Snowflake, the free module from DataOps.live observability, generates granular insights from the operational metadata of one or more Snowflake accounts storage. It lets you monitor accounts' storage spend drivers in a centralized view.
Accessing Spendview for Snowflake
Ensure that you have added the Snowflake accounts you want to monitor to the Snowflake Accounts page in Spendview for Snowflake.
- Open Spendview for Snowflake in your browser.
- Enter your username and password in the open form and click Sign in.
- On the menu bar, click Storage to open a centralized view of the Snowflake accounts' storage spending.
Your access to the icons on the left sidebar depends on your role in Spendview. See Access levels and roles for more information.
Overview
From the Storage page, you can visualize and analyze several graphical metadata representations about the storage cost of one or more Snowflake accounts and drill down into the accounts' storage cost-driver issues in seconds.
Use the fields on the top bar to choose your time- and account-specific visualization options:
- To look at the storage cost of specific accounts, click in the Account field and select the accounts you want to monitor. Click Clear selection at the bottom of the list to remove your filter.
- To look at the storage cost of specific warehouses in the selected accounts, click in the Warehouses field and select the warehouses you want to monitor. Click Clear selection at the bottom of the list to remove your filter.
- To look at the storage cost during a specific date and time range, click in the date field and select the period you want to monitor.
- To show or hide all static warehouses in the selected accounts, toggle the Show inactive WHs option on or off.
Toggle on or off Credits or Dollars to show the credit score trends or the dollar score trends in the storage metrics.
In the overall storage summary metrics, you can learn about the following:
The percentage changes in the metrics will be red if the spend has increased and green if the spend has decreased. To get this rate, subtract the first period's spend — a month or a different period — from the second period's spend and divide that by the last spend's total. Multiply the result by 100, and you have the percentage.
| Name | Description |
|---|---|
| Total spend per period | Dollars or credits spent on storage across the warehouses in the selected accounts over the chosen period in the date field |
| TB per period | Terabyte spent on storage across the warehouses in the selected accounts over the chosen period in the date field |
| Monthly storage | Dollars or credits spent on storage across the warehouses in the selected accounts over the last 30 days |
| Avg. monthly storage | Average monthly storage spent in dollars or credits across the warehouses in the selected accounts over the last 6 months |
| Monthly failsafe | Dollars or credits spent on failsafe across the warehouses in the selected accounts over the last 30 days |
| Avg. monthly failsafe | Average monthly failsafe spent in dollars or credits across the warehouses in the selected accounts over the last 6 months |
| Monthly stage | Dollars or credits spent on stage across the warehouses in the selected accounts over the last 30 days |
| Avg. monthly stage | Average monthly stage spent in dollars or credits across the warehouses in the selected accounts over the last 6 months |
| Monthly combined | Dollars or credits spent on storage, failsafe, and stage across the warehouses in the selected accounts over the last 30 days |
| Avg. monthly combined | Average monthly spent in dollars or credits on storage, failsafe, and stage across the warehouses in the selected accounts over the last 6 months |
| Monthly in TB | Terabyte spent on storage across the warehouses in the selected accounts over the last 30 days |
| Avg. monthly in TB | Average monthly TB spent across the warehouses in the selected accounts over the last 6 months |
Storage by type
This chart uses color codes to show the type of storage used.
- Point to a specific storage type/color on the chart to display the storage type, percentage, and value.
- Click Show Details on the bottom right to open more details listing storage overview for the selected accounts.
Storage by type by database
This bar chart uses color codes to show the storage used by type and database.
- Point to a specific storage type on a database bar to display the storage type, whether active, clone, time travel, or failsafe.
- Click Show Details on the bottom right to open more details listing storage overview for the selected accounts.
Storage used
This bar chart shows how many Terabytes are used on storage and the predicted changes for the selected accounts.
- Point to a bar on the chart to display the total storage used by the selected accounts at that particular date.
- Click Show Details on the bottom right to open more details listing storage overview for the selected accounts.
Stage used
This bar chart shows how many Terabytes are used on stage and the predicted changes for the selected accounts.
- Point to a bar on the chart to display the Terabytes used on stage by the selected accounts at that particular date.
- Click Show Details on the bottom right to open more details listing storage overview for the selected accounts.
Failsafe used
This bar chart shows how many Terabytes are used on failsafe and the predicted changes for the selected accounts.
- Point to a bar on the chart to display the Terabytes used on failsafe by the selected accounts at that particular date.
- Click Show Details on the bottom right to open more details listing storage overview for the selected accounts.
