Top Gradient

SELECT FAQs

Here you’ll find answers to our most frequently asked questions. If you have a question that isn’t covered, please reach out.

General

What does SELECT's security architecture look like?

To start out, we have an entire Security FAQ, here. We recommend reading all 4 articles on our Security page, here.

How do I connect my Snowflake Account?

Details on syncing your Snowflake account to SELECT can be found here.

Automated Savings

How does the Automated Savings feature work?

Automated Savings suspends your Virtual Warehouses faster than Snowflake’s default behavior. Even if you’ve set a 60-second auto-suspend, the savings can still be quite significant.

For multi-cluster warehouses, the benefits are even greater. Snowflake gradually spins down additional clusters, but we suspend each cluster as soon as it’s no longer doing any work, saving minutes of idle compute time per cluster.

What permissions are needed for Automated Savings?

The only permission required is granted during execution of the setup script:

1GRANT MANAGE WAREHOUSES ON ACCOUNT TO ROLE <select_role>;

How do I enable Automated Savings?

Navigate to the Warehouses tab. Each warehouse in the table will have a toggle that you can turn on. Or use the checkboxes to enable multiple at once.

Enable Automated Savings in SELECT

User Management

How do I change my password?

For non-SSO users, you can change your password by logging out, then click “Forgot password?”.

Change password in SELECT

How do I manage users?

Please refer to our docs about user management.

Does SELECT offer SSO?

Yes, you can sign in with SSO with Okta and Azure AD. We also offer Sign in with Google.

Okta documentation

Azure AD documentation

Data Freshness and Quality

How often is my data refreshed?

Data in SELECT is refreshed once per day at 3:00 UTC. Customers can purchase an add-on to refresh their data more frequently.

When was my data last refreshed?

You can see information about your data freshness by using the notifications sidebar. Click the notification icon in the bottom left, and check the Metadata Sync Status section

How to check data freshness in SELECT.

The data looks out of date. Is there an issue?

If your data refresh is delayed for any reason or there is an ongoing incident with our app, you will be notified in the notifications section of the app, as shown here.

See Notifications in SELECT

Do you have a Site Status page?

Yes, our site status page is here. You can easily subscribe to updates to be notified of all incidents. Or, you can subscribe to individual incidents as they occur.

App Usage

What should I do during my free trial?

Great question. Glad you asked! We have a free trial guide to walk you through how to make the most of your trial experience.

Also, it is a great idea to take this time to skim all of our Usage Guides

How do I display Snowflake spend by User?

On the All Workloads page, you can use the 3 dots in the chart and group by user. (Use the search and type ‘user’).

Display Snowflake spend by User in SELECT

Also, in the table, you can remove columns by clicking a column header and click Hide. Then add ‘user’ to the Group By using the blue + Add Column on the right.

Here’s an example at the Workload + User grain.

Snowflake spend by User and Workload

Here’s an example at the User grain.

Snowflake spend by User

Get up and running in less than 15 minutes

Connect your Snowflake account and instantly understand your savings potential.

CTA Screen