# SELECT Documentation

> Documentation for SELECT, a cost and performance platform for Snowflake, Databricks and BigQuery. Each link is the Markdown version of a docs page. The full text of every page is at https://select.dev/docs/llms-full.txt.

## Reference

- [Welcome to SELECT](https://select.dev/docs/reference/setup-guide/welcome-to-select.md): Learn about how to get started with SELECT
- [Connect your Snowflake Account](https://select.dev/docs/reference/setup-guide/connect-snowflake-account.md): Create a new Snowflake User and connect your Snowflake account to SELECT
- [Connect your Databricks Workspace](https://select.dev/docs/reference/setup-guide/connect-your-databricks-workspace.md): Create a new Databricks Service Principal and connect your Databricks workspace to SELECT
- [Connect your BigQuery Organization](https://select.dev/docs/reference/setup-guide/connect-bigquery-organization.md): A walkt though on how to connect you BQ org to SELECT
- [PrivateLink](https://select.dev/docs/reference/setup-guide/privatelink.md): Connect SELECT to your Snowflake or Databricks instance through PrivateLink connection to avoid public internet
- [PrivateLink for Snowflake Account on AWS](https://select.dev/docs/reference/setup-guide/privatelink/privatelink-for-snowflake-account-on-aws.md): How to create a PrivateLink connection from SELECT to your Snowflake account running on AWS
- [PrivateLink for Snowflake Account on Azure](https://select.dev/docs/reference/setup-guide/privatelink/privatelink-for-snowflake-account-on-azure.md): How to create a PrivateLink connection from SELECT to your Snowflake account running on Azure
- [PrivateLink for Databricks Workspace on AWS](https://select.dev/docs/reference/setup-guide/privatelink/privatelink-for-databricks-workspace-on-aws.md): How to create a PrivateLink connection from SELECT to your Databricks workspace running on AWS
- [PrivateLink for Databricks Workspace on Azure](https://select.dev/docs/reference/setup-guide/privatelink/privatelink-for-databricks-workspace-on-azure.md): How to create a PrivateLink connection from SELECT to your Databricks workspace running on Azure
- [Connect your AWS bill to SELECT (Private Preview)](https://select.dev/docs/reference/setup-guide/connect-your-aws-bill-to-select.md): Create a CUR 2.0 data export and a read-only IAM user, then connect your AWS bill to SELECT
- [Workloads](https://select.dev/docs/reference/using-select/workloads.md): Categorize SQL queries into workloads
- [Lineage](https://select.dev/docs/reference/using-select/lineage.md): Use data lineage to understand total data asset cost and ensure ROI
- [Insights](https://select.dev/docs/reference/using-select/insights.md): An overview of key optimization opportunities
- [Usage Groups](https://select.dev/docs/reference/using-select/usage-groups.md): Create flexible cost categories in SELECT
- [Budgets](https://select.dev/docs/reference/using-select/budgets.md): Set and manage budgets across different areas
- [Monitors](https://select.dev/docs/reference/using-select/monitors.md): SELECT’s Monitors feature helps you get timely notifications about your data platform.
- [Overview](https://select.dev/docs/reference/using-select/monitors/overview.md): Overview of SELECT's Monitors feature
- [Configure Destinations](https://select.dev/docs/reference/using-select/monitors/configure-destinations.md): Choose where you will be notified for alerts from your monitors
- [Using Monitors](https://select.dev/docs/reference/using-select/monitors/using-monitors.md): Learn how to view and use monitors within SELECT's App
- [Custom SQL Monitors](https://select.dev/docs/reference/using-select/monitors/custom-sql.md): Learn how to create your own monitors for a SQL query
- [Best Practices and Troubleshooting](https://select.dev/docs/reference/using-select/monitors/best-practices-and-troubleshooting.md): Learn best practices and troubleshooting for Monitors
- [Jira](https://select.dev/docs/reference/using-select/jira.md): SELECT's Jira integration is here. Connect your Jira workspace to SELECT and seamlessly link tickets to track and resolve cost optimization issues — all without leaving your workflow.
- [Organization Dashboard](https://select.dev/docs/reference/using-select/snowflake-organization.md): An annual view of your organization's spend, broken down into components
- [Views](https://select.dev/docs/reference/using-select/views.md): Save customized pages in SELECT
- [Actions & Savings](https://select.dev/docs/reference/using-select/actions-and-savings.md): Log cost-saving changes as Actions and let SELECT measure realized savings on your warehouses, including automated before/after spend calculations.
- [Access Management](https://select.dev/docs/reference/using-select/access-management.md): Authenticate through SSO, or grant specific permissions to users
- [User Management](https://select.dev/docs/reference/using-select/access-management/user-management.md): Learn how to invite teammates and manage users in SELECT.
- [Role Based Access Control](https://select.dev/docs/reference/using-select/access-management/role-based-access-control.md): Understand SELECT's permission system and how to configure granular access controls.
- [Teams](https://select.dev/docs/reference/using-select/access-management/teams.md): Learn how to create and manage teams for simplified permissions and collaborative resource ownership.
- [Authentication Management](https://select.dev/docs/reference/using-select/access-management/auth-management.md): Learn how to configure authentication preferences and methods to suit your security needs.
- [Setup Okta SSO](https://select.dev/docs/reference/using-select/access-management/okta-sso.md): Learn how to setup Okta SSO with SELECT
- [Setup Entra ID (Azure AD) SSO](https://select.dev/docs/reference/using-select/access-management/azure-ad-sso.md): Learn how to setup Entra ID (Azure AD) SSO with SELECT
- [Setup SAML Identity Provider SSO](https://select.dev/docs/reference/using-select/access-management/saml-sso.md): Learn how to setup a SAML identity provider SSO connection with SELECT.
- [SCIM](https://select.dev/docs/reference/using-select/access-management/scim.md): SCIM provisioning is available as an add-on. Contact support for configuration instructions.
- [Copilot](https://select.dev/docs/reference/using-select/copilot.md): Learn how to use SELECT Copilot, our AI assistant for cost and performance analysis.
- [Overview](https://select.dev/docs/reference/using-select/copilot/copilot-overview.md): Learn how to use SELECT Copilot, our AI assistant for cost and performance analysis across your data platform.
- [MCP Server](https://select.dev/docs/reference/using-select/copilot/mcp-server.md): Connect Select Copilot to Claude Code, Cursor, Codex, and other AI tools using the Model Context Protocol.
- [Custom Dashboards](https://select.dev/docs/reference/using-select/dashboards.md): Custom dashboards let you build your own views across any combination of resources, metrics, and time ranges
- [SELECT Free Trial Guide](https://select.dev/docs/reference/usage-guide/select-free-trial-guide.md): A guide to make the most out of your free trial with SELECT
- [Using Views for Ongoing Cost Reviews](https://select.dev/docs/reference/usage-guide/using-views-for-ongoing-cost-reviews.md): Let's review how to use Saved Views and Favorites in SELECT to establish a cost review ritual.
- [Identifying Optimization Opportunities](https://select.dev/docs/reference/usage-guide/identifying-optimization-opportunities.md): Learn how to use SELECT to find cost optimization opportunities.
- [Exploring Costs in SELECT](https://select.dev/docs/reference/usage-guide/exploring-costs-in-select.md): Let's look at the most common ways to explore costs in SELECT.
- [Understanding Cost Spikes](https://select.dev/docs/reference/usage-guide/understanding-cost-spikes.md): We will walk through how to use SELECT to understand cost spikes in your Snowflake account
- [Allocating Costs with Usage Groups](https://select.dev/docs/reference/usage-guide/allocating-costs-with-usage-groups.md): Usage Groups are a flexible way to attribute Snowflake spend in SELECT. Let's dive in.
- [Resource Based Access Control in SELECT](https://select.dev/docs/reference/usage-guide/usage-group-rbac-guide.md): This guide demonstrates how to control access to specific resources in SELECT
- [Accessing Data in SELECT](https://select.dev/docs/reference/usage-guide/accessing-select-data.md): Export your SELECT data
- [Using Monitors to Stay on Top of Cost](https://select.dev/docs/reference/usage-guide/monitors-guide.md): Learn how to use monitors to get alerted of spikes or anomilies in your Snowflake account.
- [dbt](https://select.dev/docs/reference/integrations/dbt.md): Learn how to use SELECT dbt integration
- [Custom Workloads](https://select.dev/docs/reference/integrations/custom-workloads.md): Observe any Snowflake or BigQuery workload with query tags or comments.
- [Looker](https://select.dev/docs/reference/integrations/looker.md): Learn about SELECT's Looker integration
- [Mode](https://select.dev/docs/reference/integrations/mode.md): Learn about using MODE integration in SELECT
- [Hex](https://select.dev/docs/reference/integrations/hex.md): Learn about SELECT's HEX integration
- [Periscope](https://select.dev/docs/reference/integrations/periscope.md): Learn about using Periscope within SELCT
- [Fivetran](https://select.dev/docs/reference/integrations/fivetran.md): Learn about using SELECT's Fivetran integration
- [Tableau](https://select.dev/docs/reference/integrations/tableau.md): Learn how to configure SELECT's Tableau Integration
- [Opsgenie](https://select.dev/docs/reference/integrations/opsgenie.md): Learn about using Opsgenie in SELECT
- [Managing Usage Groups via Terraform](https://select.dev/docs/reference/api-reference/managing-usage-groups-terraform.md): Learn how to manage your Usage Groups via Infrastructure as code with Terraform
- [Working with the Usage Groups API](https://select.dev/docs/reference/api-reference/working-with-the-usage-groups-api.md): A full guide to programmatically creating and managing Usage Groups in Snowflake using the SELECT Usage Groups API, with examples, best practices, and troubleshooting tips.
- [Automated Savings](https://select.dev/docs/reference/faq/automated-savings.md): Find out how our Automated Savings feature works
- [How do I assign CAN_MANAGE to all my compute resources in Databricks?](https://select.dev/docs/reference/faq/automated-savings/how-do-i-assign-can_manage-to-all-my-compute-resources-in-databricks.md): An automated way to provision the required access needed for Databricks Automated Savings
- [What Snowflake permissions are required for Automated Savings?](https://select.dev/docs/reference/faq/automated-savings/automated-savings-permissions.md): The single Snowflake grant needed to enable Automated Savings, which is applied automatically by the setup script.
- [How do I enable Automated Savings?](https://select.dev/docs/reference/faq/automated-savings/how-do-i-enable-automated-savings.md): Steps to turn on Automated Savings for one or multiple warehouses from the Warehouses tab.
- [Can Automated Savings negatively impact performance?](https://select.dev/docs/reference/faq/automated-savings/can-automated-savings-impact-performance.md): Explains that Automated Savings has shown no performance drawbacks across SELECT's customer base, since it never resizes warehouses or reduces cluster counts.
- [How does automated savings work?](https://select.dev/docs/reference/faq/automated-savings/how-does-the-automated-savings-feature-work.md): Describes how Automated Savings monitors warehouses in real time and makes short-lived configuration changes to cut cost without affecting query performance.
- [How can I see my Automated Savings in Dollars?](https://select.dev/docs/reference/faq/automated-savings/how-can-i-see-my-automated-savings-in-dollars.md): Shows how to view realized and estimated dollar savings on the warehouse chart, including how to read the total and projected annualized savings figures.
- [User Management](https://select.dev/docs/reference/faq/user-management.md): Learn about managing users in SELECT
- [How do I change my password?](https://select.dev/docs/reference/faq/user-management/how-do-i-change-my-password.md): Explains how non-SSO users reset their password via the "Forgot password?" link.
- [Does SELECT offer SSO?](https://select.dev/docs/reference/faq/user-management/does-select-offer-sso.md): Confirms SSO support via Okta and Azure AD (paid add-on) and free Google sign-in, with links to setup docs.
- [How do I manage users?](https://select.dev/docs/reference/faq/user-management/how-do-i-manage-users.md): Points to SELECT's user management documentation.
- [Data Freshness and Quality](https://select.dev/docs/reference/faq/data-freshness-and-quality.md): Learn about data freshness in SELECT
- [The data looks out of date. Is there an issue?](https://select.dev/docs/reference/faq/data-freshness-and-quality/the-data-looks-out-of-date-is-there-an-issue.md): Explains that delayed refreshes or ongoing incidents are surfaced in the app's notifications section.
- [When was my data refreshed?](https://select.dev/docs/reference/faq/data-freshness-and-quality/data-freshness.md): Covers the default daily refresh schedule, how to check the last sync time via the notifications sidebar, and how to request a different schedule.
- [Why does SELECT not offer real time data or high frequency batches?](https://select.dev/docs/reference/faq/data-freshness-and-quality/why-does-select-not-offer-real-time-data-or-high-frequency-batches.md): Breaks down the cost reasons, to you and to SELECT, for daily-only refreshes by default, with Custom SQL Monitors as an alternative for intraday needs.
- [Do you have a Site Status page?](https://select.dev/docs/reference/faq/data-freshness-and-quality/do-you-have-a-site-status-page.md): Points to SELECT's status page and explains how to subscribe to incident updates.
- [Using SELECT](https://select.dev/docs/reference/faq/using-select.md): 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.
- [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.
- [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.
- [Security](https://select.dev/docs/reference/faq/security.md): Frequently asked questions about Security.
- [Security Architecture](https://select.dev/docs/reference/faq/security/security-architecture.md): Points customers to SELECT's public Security FAQ and Security page for architecture details.

## Resources

- [Resources](https://select.dev/docs/resources/snowflake-developer-guide/resources.md): Cost Management & Optimization Resources from SELECT
- [Snowflake Query Queuing: Analyzing Queued Overload](https://select.dev/docs/resources/snowflake-developer-guide/snowflake-queuing.md): In this post, Ian explains what queuing means in Snowflake and how to check for it.
- [How to setup Snowflake key pair authentication](https://select.dev/docs/resources/snowflake-developer-guide/snowflake-key-pair.md): In this post Ian covers how to secure your Snowflake machine users with key pair authentication
- [Snowflake MFA Setup: Enabling & Disabling](https://select.dev/docs/resources/snowflake-developer-guide/snowflake-mfa.md): In this post, Ian explains how to enable MFA in your Snowflake account, and how account admins can disable it for a given user.
- [Snowflake DATEDIFF: 4 Quick Reference Examples](https://select.dev/docs/resources/snowflake-developer-guide/snowflake-datediff.md): Learn how to leverage Snowflake's most popular date function: DATEDIFF
- [About](https://select.dev/docs/resources/health-check-app/health-check-app.md): SELECT Health Check Native App
- [Frequently Asked Questions](https://select.dev/docs/resources/comparisons/faq.md): Frequently asked questions about how SELECT compares to other tools
- [SELECT vs. Homegrown Cost Monitoring](https://select.dev/docs/resources/comparisons/select-vs-homegrown.md): Learn how SELECT compares to homegrown Snowflake cost monitoring tools.
- [SELECT vs. Snowflake's Native Cost Monitoring Features](https://select.dev/docs/resources/comparisons/select-vs-snowflake.md): SELECT vs Snowflake's Cost Monitoring Features
- [SELECT vs. Keebo](https://select.dev/docs/resources/comparisons/select-vs-keebo.md): SELECT vs Keebo
- [SELECT vs. Capital One Slingshot](https://select.dev/docs/resources/comparisons/select-vs-capital-one-slingshot.md): SELECT vs. Capital One Slingshot
- [SELECT vs. Chaos Genius](https://select.dev/docs/resources/comparisons/select-vs-chaos-genius.md): SELECT vs. Chaos Genius
- [SELECT vs. espresso.ai](https://select.dev/docs/resources/comparisons/select-vs-espresso-ai.md): SELECT vs. espresso.ai
- [About](https://select.dev/docs/resources/dbt-snowflake-monitoring/dbt-snowflake-monitoring.md): Learn about the open-source dbt package written by SELECT
- [Quickstart](https://select.dev/docs/resources/dbt-snowflake-monitoring/quickstart.md): A quickstart guide from SELECT
- [Example Usage](https://select.dev/docs/resources/dbt-snowflake-monitoring/example-usage.md): See some examples queries you can run on top of the models.
- [Contributing](https://select.dev/docs/resources/dbt-snowflake-monitoring/contributing.md): Contributing set-up guide

## API reference

- [API reference index](https://api-docs.select.dev/llms.txt): Markdown index of the SELECT API docs. Each endpoint page includes the part of the OpenAPI spec for that endpoint.

## Optional

- [OpenAPI spec, API v2](https://api.select.dev/v2/openapi.json): Full spec, about 3 MB. For code generation. To read about an endpoint, use its page in the API reference index.
- [OpenAPI spec, API v1](https://api.select.dev/public_openapi): Full spec of the older API.