# Using SELECT

URL: https://select.dev/docs/reference/faq/using-select
Index of all SELECT docs: https://select.dev/docs/llms.txt

> FAQs about using SELECT

- [Connect your Snowflake Account](https://select.dev/docs/reference/faq/using-select/connect-your-snowflake-account.md): Links to the setup guide for syncing a Snowflake account with SELECT.
- [Why doesn't the trend chart show all of my data?](https://select.dev/docs/reference/faq/using-select/why-doesn-t-the-trend-chart-show-all-of-my-data.md): 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?](https://select.dev/docs/reference/faq/using-select/what-are-retained-for-clones-storage-costs.md): 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?](https://select.dev/docs/reference/faq/using-select/does-select-have-an-openapi-spec.md): 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?](https://select.dev/docs/reference/faq/using-select/what-are-all-of-the-storage-metrics-in-select.md): Defines Active, Time Travel, Failsafe, Clone, Total Billable, and Total Bytes storage metrics.
- [How can I monitor long running queries in my Snowflake Account?](https://select.dev/docs/reference/faq/using-select/how-can-i-monitor-long-running-queries-in-my-snowflake-account.md): 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](https://select.dev/docs/reference/faq/using-select/how-long-does-select-retain-data.md): Covers the initial historical load, ongoing retention while a customer, and immediate deletion on offboarding.
- [How do I view query profiles in SELECT?](https://select.dev/docs/reference/faq/using-select/how-do-i-view-query-profiles-in-select.md): Steps to reach a query's Profile tab from either the Workloads page or Query History.
- [How do I monitor Cortex Function Spend](https://select.dev/docs/reference/faq/using-select/how-to-i-monitor-cortex-function-spend.md): 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?](https://select.dev/docs/reference/faq/using-select/how-can-i-find-unused-tables-and-schemas-in-select.md): 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?](https://select.dev/docs/reference/faq/using-select/how-is-utilizable-warehouse-size-calculated.md): 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?](https://select.dev/docs/reference/faq/using-select/how-do-i-monitor-ai-and-cortex-spend-in-select.md): 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?](https://select.dev/docs/reference/faq/using-select/db-costs-on-explorer-page.md): 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?](https://select.dev/docs/reference/faq/using-select/how-do-i-display-snowflake-spend-by-user.md): 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?](https://select.dev/docs/reference/faq/using-select/how-do-i-find-queries-that-underutilize-a-warehouse.md): 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?](https://select.dev/docs/reference/faq/using-select/can-i-estimate-snowflake-time-travel-costs-in-advance-using-select.md): 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?](https://select.dev/docs/reference/faq/using-select/what-should-i-do-during-my-free-trial.md): 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?](https://select.dev/docs/reference/faq/using-select/why-is-the-cost-of-a-query-in-select-different-than-the-cost-in-snowflake-s-query-attribution-history.md): 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?](https://select.dev/docs/reference/faq/using-select/are-adaptive-warehouses-supported-by-select.md): Confirms cost reporting works normally for adaptive warehouses, but notes Automated Savings isn't compatible with them.
- [I found discrepancies in Iceberg Storage](https://select.dev/docs/reference/faq/using-select/i-found-discrepancies-in-iceberg-storage.md): 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?](https://select.dev/docs/reference/faq/using-select/why-does-the-storage-total-on-home-explorer-differ-from-the-storage-page.md): 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?](https://select.dev/docs/reference/faq/using-select/how-many-of-my-teammates-are-using-select.md): 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?](https://select.dev/docs/reference/faq/using-select/what-are-all-of-the-query-time-stats-in-select.md): 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?](https://select.dev/docs/reference/faq/using-select/calculate-databricks-spend-from-system-tables.md): 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.