DOCS

Using SELECT

Connect your Snowflake Account

Links to the setup guide for syncing a Snowflake account with SELECT.

Why doesn't the trend chart show all of my data?

Explains that overly granular date ranges get truncated, and how to fix it by shortening the range or widening the time grain.

→

What are 'Retained for Clones' storage costs?

Explains how storage costs become orphaned as "Retained for Clones" when a cloned object's source is dropped, and how to investigate them in Snowflake.

→

Does SELECT have an OpenAPI spec?

Links to SELECT's public OpenAPI spec and describes common API use cases like usage groups, teams, and access control.

→

What are all of the storage metrics in SELECT?

Defines Active, Time Travel, Failsafe, Clone, Total Billable, and Total Bytes storage metrics.

→

How can I monitor long running queries in my Snowflake Account?

Shows how to build a Custom SQL Monitor for still-running long queries, including required permissions and an example query and alert template.

→

How long does SELECT retain data

Covers the initial historical load, ongoing retention while a customer, and immediate deletion on offboarding.

→

How do I view query profiles in SELECT?

Steps to reach a query's Profile tab from either the Workloads page or Query History.

→

How do I monitor Cortex Function Spend

Steps to build a Saved View in Workloads filtered to non-null Cortex Function Cost.

→

How can I find Unused Tables and Schemas in SELECT?

Two approaches for finding unused tables and schemas: the Insights page's "Unused Table" filter, or custom date-range filters on the Storage page.

→

How is Utilizable Warehouse Size calculated?

Explains how QUERY_LOAD_PERCENT is converted into a node count and mapped to the smallest warehouse size that could have handled the query.

→

How do I monitor AI and Cortex spend in SELECT?

A complete guide to monitoring Snowflake AI and Cortex spend in SELECT: the AI Services SELECT tracks, the Snowflake AI Usage dashboard, and analyzing costs by resource type, model, user, and workload in Cost Explorer and Workloads, plus setting up spend alerts.

→

Why doesn't the Explorer page show Storage costs for my Usage Groups?

Explains that Usage Groups based on object tags aren't reflected on the Explorer page, and to check the Storage page instead.

→

How do I display Snowflake spend by User?

Shows how to group workload charts and tables by user to see per-user Snowflake spend.

→

How do I find queries that underutilize a warehouse?

Three methods, Utilizable Warehouse Size, Partitions Scanned, and short queries on large warehouses, for spotting oversized warehouse usage.

→

Can I estimate Snowflake time travel costs in advance using Select?

Explains that time travel costs can't be predicted in advance and must be measured empirically after enabling the feature.

→

What should I do during my free trial?

Points new customers to the free trial guide and the broader Usage Guides.

→

Why is the cost of a query in SELECT different than the cost in Snowflake's Query Attribution History?

Explains the methodology gaps (idle time, short queries, acceleration, AI, cloud services, data transfer) that make SELECT's cost-per-query figures typically higher than Snowflake's own attribution.

→

Are Adaptive Warehouses supported by SELECT?

Confirms cost reporting works normally for adaptive warehouses, but notes Automated Savings isn't compatible with them.

→

I found discrepancies in Iceberg Storage

Clarifies that Iceberg billable-bytes figures are a known Snowflake data-modeling quirk, not an actual charge, and explains the "Bytes" vs "Bytes (Billable)" fields.

→

Why does the Storage total on Home/Explorer differ from the Storage page?

Explains that account-level totals include retained clone bytes that dropped-source objects can no longer attribute at the database or table level.

→

How many of my teammates are using SELECT?

Points to Settings → Users for a list of users, page views, and last-visited dates.

→

What are all of the query time stats in SELECT?

Defines Execution, Compilation, and Queued time metrics, why Execution Time and Total Duration differ, and which one to optimize.

→

How do I calculate my Databricks spend from system tables to compare against SELECT?

How to independently verify SELECT's reported Databricks platform spend using Databricks' own system.billing.usage and system.billing.list_prices tables, including any negotiated discounts.

→

Get up and running in less than 15 minutes

Connect your Snowflake, Databricks, or BigQuery account and instantly understand your savings potential.

Book a demo Start free trial