Cost Analysis Dashboard

Wondering where spend occurs? The Cost analysis dashboard provides transparency for your Snowflake expenses expenses. Review enterprise-wide cost info across 4 categories including total, warehouse, storage, and serverless costs, to allocate spending effectively.

To access cost analysis data:

1. From the left navigation menu, go to Dashboards, then Cost analysis.
2. Select a tab (Total costs, Warehouse costs, Storage costs, or Serverless costs) to view additional details.
3. Filter or export/view data for deeper analysis.  

Total Costs

The Total costs tab summarizes enterprise-wide costs and displays projections.

1. Enterprise Cost by Day, Month, and Week: total costs by day, month, or week within the contract period
   • Select Day, Month, or Week from the pick list.
2. Cost Types by Month: month-over-month costs for the duration of the contract
3. Total Cost by Account: total cost by Snowflake account
4. Total Cost by Type: costs grouped by usage type
5. Enterprise Cost Projections: enterprise-wide cost projections for the contract period
6. Warehouse Cost Projections: warehouse usage and cost during the contract period
7. Storage Cost Projections: storage costs for the contract period
   ℹ️

   Machine learning models compare past costs with trends to generate projections. For Cost Projection visuals, select Edit forecast to open Forecast properties.
8. Total Costs by Business Org: costs bucketed by department
9. Organization Cost by Day, Month, Week: costs stacked by org, then day, month, or week
   • Select Day, Month, or Week from the pick list.

Warehouse Costs

The Warehouse Costs tab slices warehouses by day, week, month, account, and environment; along with displaying warehouse cost projections, compute cost, month-over-month cost analysis, costliest users and queries, and warehouse costs by Business org.

1. Warehouse Cost by Day, Month, Week: costs by day, month, or week
   • Select Day, Month, or Week from the pick list.
2. Warehouse Cost by Account: costs by Snowflake account
3. Warehouse Cost by Environment: total warehouse cost by environment
4. Warehouse Cost Projections: warehouse cost projections for the contract period
   ℹ️

   Machine learning models compare past costs with trends to generate projections. For Cost Projection visuals, select Edit forecast to open Forecast properties.
5. Compute Cost by Warehouse: costliest warehouse in descending order
6. Delta In Compute Cost Between Periods by Day, Month, Week: compute cost trends between periods of time by days, months, or weeks
7. Costly Users: top 100 users with the most compute costs in descending order
8. Costly Queries: 50 costliest queries in descending order
9. Warehouse Cost by Business Org: warehouse costs bucketed by departments

The Storage costs tab organizes your tenant’s storage expenses for AWS S3 buckets managed by Snowflake, based on a 30-day rolling average.

1. Data Transfer Cost by Account: cost of moving data around your warehouse by Snowflake account
2. Storage Cost by Account: total storage costs
3. Data Transfer Cost by Month: monthly costs associated with data transmission for your Tenant
4. Storage Cost by Database: a list of the costliest databases in descending order
5. Delta In Database Cost Between Periods by Month: monthly compute cost trends
6. Storage Cost and Space Usage (TB) by Month: the bars represent storage size in terabytes (TB), while the line reflects storage costs
7. Storage Cost by Month: monthly storage cost
8. Storage Cost Projections: storage cost projections for the contract period
   ℹ️

   Machine learning models compare past costs with trends to generate projections. For Cost Projection visuals, select Edit forecast to open Forecast properties.
9. Storage Cost by Schema: storage costs grouped by how your data’s organized in Snowflake

Use the pin icon to keep the Forecast properties visible.

Serverless Costs

The Serverless Costs collates your resource allocations and pipeline costs.

1. Auto Clustering Cost by Account: costs associated with automatically adjusting resources by Snowflake account
2. Pipe Cost by Account: data pipeline costs segmented by their Snowflake account
3. Auto Clustering Cost by Month: monthly automated resource allocation costs
4. Pipe Cost by Month: monthly data pipeline costs
5. Replication Cost by Month: monthly resource/data duplication costs

Editing Forecast properties

Make adjustments to any projection visual with a few tweaks to the Forecast properties.

1. Use the 3 dots to open the menu.
2. Select Edit forecast.
3. Adjust the Forecast properties.
4. Use the Apply button to save your settings.

Adding Filters

Want even more granular visual insights? Add filters. For Slingshot tags filters include

• Region: Available cloud regions,
• Account name: Snowflake account name(s),
• Warehouse name: Individual warehouse data, and
• Business orgs: Data for warehouses associated with a business org in Slingshot.

To add filters,

1. Select Add Filter to open the Filter flyout.
2. Expand the menu for the filter you’d like to apply.
3. Make your selections.
4. Review your cost insights.

View or export summary data

Sometimes, you’d like to see a summary or need to download the insights information.

1. Hover over a visual, 3 dots appear.
2. Click the dots to see the options.
3. Select View summary data to review the summary on the page.
4. Or select Export to CSV to generate a file with the insights.