LogoLogo
About UsCustomersResourcesGet Started for Free
  • What is Select Star?
  • 🏁Getting Started
    • 1. Data Source Setup
    • 2. Mark Service Accounts
    • 3. Hide Unwanted Datasets
    • 4. Invite Owners
    • 5. Add Documentation
    • Next Steps
  • 🔄Integrations
    • Snowflake
      • Using Key Pair Authentication
      • Using Password Authentication
      • Snowflake Tag Sync
      • Snowflake Key Pair Rotation
    • Databricks
      • Databricks on AWS
      • Databricks on Azure
    • BigQuery
    • AWS Redshift
      • Manual setup
    • Microsoft SQL Server / MS SQL (beta)
      • Query Logs
    • MySQL (beta)
      • Query Logs
    • Oracle (beta)
      • Query Logs
    • Salesforce (beta)
    • DB2 (beta)
    • PostgreSQL
      • AWS Aurora PostgreSQL
      • AWS RDS PostgreSQL
      • PostgreSQL on-prem
    • AWS Glue (beta)
    • dbt
      • dbt Cloud
      • dbt Core (open source)
      • dbt Tags
      • dbt Tests
      • dbt docs Sync
        • Github dbt docs Sync
        • Bitbucket dbt docs Sync
      • dbt Impact Report
      • dbt Project Dependencies
    • Apache Airflow (beta)
    • Tableau
      • Tableau Cloud
      • Tableau Server
    • PowerBI
    • Looker
    • Metabase
    • Fivetran (beta)
    • Mode
    • Sigma Computing
    • Sisense / Periscope (beta)
    • Looker Studio (beta)
    • ThoughtSpot
    • QuickSight (beta)
      • Event Logs
    • Hex (beta)
    • Slack
    • Monte Carlo
    • Private Network
    • Request an Integration
  • ✨Features
    • Search
    • Table Page
    • Database Page
    • Dashboard Page
    • Data Lineage
    • Entity Relationship Diagram (ERD)
    • Queries & Joins
    • Tags
    • Teams
    • Discussion
    • Downstream Notifications
    • Documentation
      • Pages
      • Metrics
        • Metrics Generation
      • Glossary
    • Automated Documentation
    • User Analytics
    • Chrome Extension
      • Organization-wide install
    • Source Tables
    • Cost Analysis
    • Schema Change Detection
    • AI Features & Settings
      • Ask AI Chatbot
    • Request a Feature
  • 🧭Data Discovery
    • Where's my data?
    • Where's my dashboard?
    • How can I get the full context of this data?
    • My dashboard looks off
    • Change management
    • I'm new to the team
    • I have a data question
  • 🗃️Data Management
    • Add Documentation
      • CSV Metadata Upload
    • Collections
    • Tags
    • Data Ownership
    • Sensitive / PII Data
    • Automated PII Detection
  • 📚Learning Data
    • Getting Started: Looker
    • Getting Started: Mode
    • Getting Started: Tableau
    • Getting Started: Snowflake
    • Getting Started: Databricks
    • Getting Started: Data Warehouse
    • Getting Started: BigQuery
      • Nested Fields
    • Getting Started: Sigma
    • Getting Started: ThoughtSpot
  • 🛠️Data Source Management
    • Manage Data Sources
    • Connect Data Source Users to Select Star
    • Custom Attributes
    • Recent Queries
  • 👥User Management
    • Invite Users
    • Roles & Permissions
    • SAML SSO
    • Importing Roles and Teams (Okta)
    • Policy Based Access Control
    • Account and User Settings
  • 💻Select Star API
    • Overview
    • API Token
    • Getting Started
    • Rich Text Descriptions via API
    • Troubleshooting
    • API Examples
    • API Reference
  • 🔓Security & Compliance
  • ❓FAQ
    • Icon Map
  • 📰Changelog
    • May 20, 2025 - Chrome Extension, Notifications, and More!
    • April 16, 2025 - Semantic Models, AI Metrics, and More!
    • March 12, 2025 - Fivetran Integration, Tableau Updates and More!
    • February 6, 2025 - Collections, Slack App Published, Salesforce Formula Lineage and more!
    • December 10, 2024 - Hex Integration, Impact Score & Snowflake Key Pair Authentication!
    • November 13, 2024 - New Navigation, Airflow and More!
    • September 30, 2024 - Upstream Data Quality Issue Tracking & 5 New Integrations!
    • August 30, 2024 - Monte Carlo, dbt Cross-Project Lineage
    • July 31, 2024 - Glossary Import, Lineage Updates & more!
    • July 9, 2024 - Lineage Explorer 2.0, Slack AI and Notifications
    • February 29, 2024 - AI Chat, Schema Change Notifications
    • February 23, 2024 - Manual Lineage Creation
    • November 23, 2023 - Bulk AI Documentation
    • October 19, 2023 - Downstream Notifications
    • October 16, 2023 - New Homepage
    • October 13, 2023 - dbt Impact Report
    • Historical Changelogs
  • Security & Compliance
  • System Status
Powered by GitBook
On this page
  • Introduction
  • Date Range Filtering
  • Benefits of Cost Analysis

Was this helpful?

  1. Features

Cost Analysis

PreviousSource TablesNextSchema Change Detection

Last updated 10 months ago

Was this helpful?

Cost Analysis is only available on certain plans. Please reach out to support@getselectstar.com to enable or trial the feature.

This feature is currently only supported for Snowflake (DWH), Sigma and Mode (BI tools)

Introduction

With Cost Analysis, you will gain insights about your Snowflake Spend at the query, dashboard, warehouse and user level. You will be able to view Cost (in Credits) of your big ticket dashboards and identify which queries are the most expensive by sorting them by cost. You will also be able to identify Snowflake Spend for each active warehouse, and have the ability to track Snowflake Spend by teams and users.

To access the Cost Analysis page, click Settings from the menu on the top right, and click Snowflake Cost Analysis in the Admin section on the left sidebar.

This feature contains 3 tabs

  • Overview - This tab provides a high-level summary of total expenditure, cost trends, and key cost drivers to quickly assess the overall cost landscape.

  • Data - This tab provides detailed insights on query cost, dashboard cost, and warehouse cost, allowing admins to analyze and optimize resource allocation for efficient cost management.

  • User - This tab provides a comprehensive breakdown of the cost by team and user, allowing admins to track and analyze cost allocation across different groups.

Date Range Filtering

Each Cost Analysis page has a date range picker to filter metrics by specific dates. Currently, the maximum date range limit is 14 days.

Dates and Times shown are in UTC timezone

Benefits of Cost Analysis

Our Cost Analysis feature provides a centralized view of your Snowflake compute costs, and enables your organization to gain insights into your usage patterns and identify cost optimization opportunities. This feature provides:

  • Near Real-time Cost Monitoring: This feature displays up-to-date information on credit consumption, allowing you to track costs in near real-time and react promptly to any unexpected spikes.

  • Cost Breakdown: It provides a detailed breakdown of costs by warehouses, user, and dashboards, enabling you to pinpoint areas of high expenditure and optimize resource allocation.

  • Forecasting and Budgeting: By analyzing historical data and usage patterns, this feature can help forecast future costs, allowing you to plan budgets effectively.

  • Query and Dashboard Usage Analysis: It can help correlate query and dashboard usage metrics with cost, helping you identify expensive queries that can be optimized or tuned for better efficiency.

✨