Skip to main content

SELECT - Snowflake Cost Observability & Optimization Service Description

Overview of the Platform​

SELECT for Snowflake is a software-as-a-service (SaaS) application that provides cost observability, usage analytics, optimization insights, and automated warehouse configuration adjustments for customer Snowflake environments. SELECT for Snowflake enables organisations to monitor, analyse, govern, and optimise Snowflake compute usage and associated spend through automated analysis of Snowflake account metadata and query workload behaviour.

SELECT for Snowflake is delivered as a vendor-hosted web application accessed via browser interface and supported integrations. No customer-side software installation is required; customers provision Snowflake metadata access credentials, and initial onboarding includes account connection and configuration of usage groups and monitors. Most customers are fully operational in under fifteen minutes.

The following sections describe the major features and capabilities available in SELECT for Snowflake.

Core Analytics and Reporting​

Cost and Usage Observability​

Single pane of glass for Snowflake spend – SELECT for Snowflake aggregates and visualises Snowflake usage and credit consumption, providing a single source of truth for every credit spent. The platform attributes compute spend across Snowflake resources including warehouses, workloads, users, queries, and metadata-derived assets. It highlights the annualised costs of all Snowflake resources—tables, tasks, LLM models and more—making them readily accessible within a few clicks.

Workload-level and query-level cost analysis – SELECT for Snowflake uses query parsing and fingerprinting to deliver workload-level and query-level cost analysis. Users can explore historical spend trends, drill into individual query costs, and identify the specific workloads driving consumption. Query-level insights accelerate performance optimization and help educate business users on query best practices.

Forecasting – SELECT for Snowflake includes usage and spend forecasting across supported resource dimensions. Forecasts are accessible in dashboards and budgets, enabling proactive decision-making and planning.

Usage Groups (Cost Allocation and Governance)​

Flexible cost attribution – Usage Groups provide a flexible way of creating cost categories within SELECT for Snowflake. They allow customers to allocate Snowflake costs to teams, projects, or departments using a variety of Snowflake attributes such as users, roles, query tags, warehouses, databases, and workload classifications. Usage Groups support showback and chargeback reporting, enabling organisations to decentralise cost management and promote a shared sense of cost ownership.

Budgets and forecasting – Customers can assign budgets to each Usage Group and forecast costs on a monthly, quarterly, or annual basis. Teams are automatically alerted when they are forecasted to exceed their budget. Budget threshold alerts and projected overrun notifications ensure proactive spend governance.

Configuration as code – Usage Groups can be configured and updated through the web interface or automatically via JSON or YAML definitions. Version history is maintained for all Usage Group changes, allowing customers to review and restore prior configurations at any time. Usage Groups integrate with Insights, Monitors, and the broader analytics experience throughout SELECT for Snowflake.

Insight Generation and Recommendations​

Insights​

Intelligent recommendations engine – SELECT for Snowflake’s Insights engine continuously analyses Snowflake accounts for optimisation opportunities. It scans all Snowflake resources and queries for common anti-patterns and inefficiencies, and surfaces detailed optimisation recommendations to end users.

Actionable insights dashboard – The Insights page provides an overview of insight categories with the ability to drill into each category. Users can quickly see total potential savings along with the estimated effort for each opportunity. Insights can be filtered by resource, potential savings, or level of effort to help teams prioritise their work. Query-level insights include performance and cost diagnostics derived from Snowflake metadata and query profiles, helping users accelerate query workloads, reduce compute costs, and adopt query best practices.

Automated Optimisation​

Automated Savings​

Continuous warehouse optimisation – SELECT for Snowflake’s Automated Savings feature continuously monitors Snowflake query workloads and warehouse utilisation and automatically adjusts virtual warehouse configurations—including cluster scaling behaviour and related parameters—to improve utilisation efficiency. The feature is designed to reduce compute spend with no engineering effort required from the customer.

Granular control and transparency – Customers can see the potential savings for each virtual warehouse and easily toggle the Automated Savings feature on or off for complete control. SELECT for Snowflake provides full transparency into the exact actions taken and the savings generated, so customers can validate results at any time. All optimisation actions are limited to configuration parameters and do not modify customer data, schemas, or query logic.

Alerts and Anomaly Detection​

Monitors​

Spend anomaly alerts – SELECT for Snowflake provides configurable monitors for spend anomalies and usage spikes. Monitors support multiple detection methods:

  • Threshold Monitors allow customers to set explicit spend thresholds for accounts, warehouses, or other Snowflake resources and receive alerts when those thresholds are crossed.

  • Anomaly Monitors automatically determine whether a metric is anomalously high or low, accounting for seasonal patterns. Sensitivity can be adjusted to balance between rapid detection and minimising false positives.

  • Custom SQL Monitors allow customers to define their own SQL-based alerting logic for scenarios where out-of-the-box monitors do not apply. Monitors can run on daily, weekly, or monthly schedules.

Recurring digests – Users can subscribe to digests at recurring intervals (daily, weekly, or monthly) summarising spend at the account level or by Usage Group, warehouse, or specific workload. Proactive notifications help maintain cost awareness across the organisation.

Integrations​

Data ecosystem integrations – SELECT for Snowflake integrates with popular data tools that sit on top of Snowflake and drive significant compute consumption. Supported integrations include tools such as dbt, Looker, Sigma, and other transformation, BI, and ingestion platforms where metadata access is available. These integrations provide enhanced cost attribution and lineage context, allowing customers to understand the total cost of assets originating from these systems and surface optimisation opportunities specific to each tool.

Alerting integrations – SELECT for Snowflake supports alert delivery to Email, Slack, Microsoft Teams, PagerDuty, Opsgenie, and custom webhook endpoints, ensuring seamless integration with existing incident management and communication workflows.

API and data sharing – All data visible in the SELECT for Snowflake web application can be accessed through a secure Snowflake data share, enabling customers to incorporate SELECT for Snowflake’s cost and usage data into their own reporting and analytics pipelines. Integration coverage may vary by tool and version.

Artificial Intelligence​

AI-Powered Capabilities​

SELECT for Snowflake leverages AI to deliver meaningful value while maintaining strict data security and privacy controls. AI capabilities within SELECT for Snowflake include summarisation of key Snowflake query data that previously required manual exploration and analysis, generation of understandable and concise descriptions of complex queries, and identification of inefficiencies with proposed remedial actions across customer Snowflake accounts.

Data Privacy and Security​

SELECT for Snowflake maintains a rigorous approach to data handling when using AI features:

  • Strict data lifecycle – All data provided to SELECT for Snowflake is processed only for authorised purposes and is securely handled afterward. SELECT for Snowflake does not use customer data to train AI models.

  • Sanitised data transmission – The only data transmitted to AI subprocessors is sanitised query text and performance metrics. No sensitive data is shared. SELECT for Snowflake is working to establish zero-data-retention (ZDR) policies with its AI subprocessors.

  • Compliant vendors – Third-party AI partners are carefully vetted to ensure they meet stringent compliance standards, including GDPR, CCPA, SOC 2, ISO 27001, and HIPAA. Vendors are continuously monitored for ongoing compliance.

Transparency and Explainability​

SELECT for Snowflake prioritises transparent and explainable AI. Every output produced by AI systems is logged in a comprehensive audit trail. Key decision-making logic is hand-written, with AI used only for use cases such as SQL generation where high confidence exists in the initial recommendation. AI features operate on a human-in-the-loop basis: outputs are provided as recommendations for users to apply their own judgment, and no automated actions are taken by AI features without user direction.

Data Security and Compliance​

Security and Access Model​

SELECT for Snowflake operates using read-only access to designated Snowflake metadata views and system tables. SELECT for Snowflake does not access, read, copy, or process customer table data contents. Only Snowflake metadata related to usage, configuration, and query execution is accessed. A customer-provisioned, limited-privilege Snowflake service account is required for operation.

SELECT for Snowflake retains customer usage metadata while they are an active customer, and automatically deletes it upon offboarding.

Compliance and Certifications​

SELECT for Snowflake meets industry-standard security requirements, including SOC 2 Type II certification, demonstrating a commitment to managing data securely and protecting the privacy and interests of customer organisations. The certification covers critical areas including security, availability, processing integrity, confidentiality, and privacy. SELECT for Snowflake conducts routine internal and external audits to verify that practices align with the latest compliance standards.

Architecture and Data Protection​

SELECT for Snowflake employs a defence-in-depth security architecture:

  • End-to-end encryption – Data is encrypted at rest and in transit using AES-256 encryption.

  • Secure APIs – All data exchanges occur through authenticated APIs, ensuring only authorised systems and personnel can access data.

  • Zero-trust policies – Systems operate on a zero-trust basis; every access request is verified, authenticated, and logged.

  • Multi-factor authentication (MFA) – MFA is required for all access points to prevent unauthorised logins.

  • Data siloing – Each client’s data is processed in isolated, virtualised environments, eliminating cross-contamination risks.

  • Real-time monitoring – Systems are monitored continuously, using advanced analytics to detect and respond to potential threats.

  • Disaster recovery – Redundant backups and a robust disaster recovery plan ensure data safety and accessibility.

Access Controls​

SELECT for Snowflake provides role-based access controls (RBAC) that allow customers to grant users access to specific Snowflake accounts or the entire Snowflake organisation. Customers can expose a subset of Snowflake costs from selected resources to each team or department, ensuring that sensitive billing information is shared only with authorised personnel.

Saved Views and Personalisation​

Many screens in SELECT for Snowflake feature filterable and configurable tables and charts. Instead of repeating configuration and filters on each visit, users can save views for easy reuse. Saved views can be favourited, which pins them to the sidebar for quick access. This capability supports weekly cost-review rituals and helps teams maintain consistent visibility into their Snowflake spend.

Supported Platforms​

SELECT for Snowflake supports Snowflake environments. SELECT for Databricks supports Databricks and is available for purchase separately. Planned future platform support includes:

  • BigQuery (targeted availability: H2 2026)

Future platform support is roadmap only and not guaranteed unless explicitly included in the customer quote.

Exclusions​

SELECT for Snowflake does not:

  • Modify customer data tables or records.

  • Execute customer SQL workloads.

  • Replace Snowflake native billing systems.

  • Guarantee specific savings outcomes.

  • Provide financial accounting or invoice reconciliation services.

  • Control third-party tool behaviour.

  • Override Snowflake platform limits or billing rules.

Conclusion​

SELECT for Snowflake provides a comprehensive, Snowflake-focused cost observability and optimisation platform that combines deep usage analytics, intelligent recommendations, fully automated warehouse savings, flexible cost allocation, and proactive anomaly detection. By leveraging Cost and Usage Observability, Usage Groups, Insights, Automated Savings, Monitors, data ecosystem Integrations, AI-powered capabilities, and granular access controls, organisations can achieve deep cost visibility, enforce financial accountability, detect anomalies quickly, optimise resource usage, and democratise spend management across the enterprise. SELECT for Snowflake’s security posture, read-only access model, and rapid onboarding make it suitable for organisations seeking to embed cost management best practices into their Snowflake operations.

Last updated on