Administering Snowflake

The Admin area of Snowsight, the Snowflake web interface, is your Snowflake command center. Use the Admin area to:

  • Understand your Snowflake usage.

  • Manage Snowflake warehouses.

  • Set up and view details about resource monitors.

  • Manage users and roles.

  • Administer Snowflake accounts in your organization.

  • Administer network policies and monitor session activity.

  • Set up payment and payout methods.

  • Review and accept the Provider and Consumer Terms of Service.

  • Set organization contacts for Snowflake security, privacy, and product notifications.

  • Connect to Snowflake partners to explore extended functionality.

This topic describes how to use the Admin area to administer your Snowflake experience.

Using the Admin Area

This section gives a brief overview of how to use the Admin area of Snowsight.

The Admin area includes the following:

Usage

The Usage page provides detailed information about your Snowflake consumption across all relevant services, in either credits or the appropriate currency. The Usage page is the default page for the Admin area.

Note

Only users with the ACCOUNTADMIN role and that role being the currently active one can view usage data. Other users will see an error message instructing them to switch to a relevant role.

If a user has the ACCOUNTADMIN role, but does not have the ORGADMIN role, they can only view costs for the current account. The Account filter that would allow them to switch to a different account does not appear.

This section provides a brief overview of how to navigate and use the Usage page.

Interface

Description

Filter usage

Use the filters, located in the upper-left corner of the page, to filter your usage data. You can filter by:

  • Date range

  • Account

  • Type of usage:

    • All Usage Types — Displays results as currency. Only appears for users with the ACCOUNTADMIN role and the ORGADMIN role.

    • Compute: Displays — usage in credits used.

    • Storage: Displays — usage in bytes stored.

    • Data Transfer — Displays usage in bytes transfered.

Aggregate usage

In the upper-right corner of the page, choose to aggregate your usage data by day (default), hour, or month.

The Usage page requires a warehouse. Snowsight uses the default warehouse for your user profile. If you cannot see the Usage page, or if you want to switch warehouses, in the upper-right corner of the page, select a warehouse.

Warehouses

The Warehouses page lets you view and manage your Snowflake warehouses. The Warehouses page provides a detailed table of your warehouses.

This section provides a brief overview of how to navigate and use the Warehouses page.

Interface

Description

Filter warehouses

In the upper-right corner of the page, search and filter the table of your warehouses. You can filter by:

  • Status

    • All (default)

    • Suspended

    • Started

    • Resuming

    • Resizing

    • Suspending

  • Size

    • All (default)

    • X-Small

    • Small

    • Medium

    • Large

    • X-Large

    • 6X-Large

Create warehouse

In the upper-right corner of the page, select Warehouse to create a warehouse.

For assistive technology, the more button.

Warehouse menu

Each row of the warehouses table includes a menu of actions for the corresponding warehouse.

The warehouse menu lets you do the following:

  • Edit the warehouse. You can configure the following warehouse options:

    • Name

    • Size

    • Comment

    • Multi-cluster Warehouse

    • Mode

    • Clusters

    • Auto Resume

    • Auto Suspend

    • Suspend After (min)

  • Suspend or resume the warehouse.

  • Drop the warehouse.

  • Transfer ownership of the warehouse to another role.

For more information, Snowflake provides detailed technical documentation about warehouses.

The warehouses table includes the following columns:

  • Name

  • Status

  • Size

  • Clusters

  • Running

  • Queued

  • Owner

  • Created

To view additional details about a warehouse, select a warehouse in the table.

Warehouse Details

When you select a warehouse in the warehouses table, the warehouse details page appears.

This section provides a brief overview of how to navigate and use the warehouse details page.

Interface

Description

Basic details

Basic details about your warehouse are located at the top of the page. Hover over the details to view additional information.

For assistive technology, the more button.

Warehouse details menu

The warehouse details menu, located in the upper-right corner of the page, lets you do the following:

  • Edit the warehouse. You can configure the following warehouse options:

    • Name

    • Size

    • Comment

    • Multi-cluster Warehouse

    • Mode

    • Clusters

    • Auto Resume

    • Auto Suspend

    • Suspend After (min)

  • Suspend or resume the warehouse.

  • Drop the warehouse.

  • Transfer ownership of the warehouse to another role.

For more information, Snowflake provides detailed technical documentation about warehouses.

The warehouse details page includes the following sections:

  • Warehouse Activity

  • Details

  • Privileges

Warehouse Activity

The Warehouse Activity section provides a graph of activity over a period of time:

  • Hour

  • Day

  • Week

  • 2 Weeks (default)

Details

The Details section provides additional information about your warehouse, including:

  • The status of the warehouse.

  • The size of the warehouse.

  • Maximum and minimum number of clusters the warehouse can use.

  • The scaling policy.

  • The number of tasks that are running and queued.

  • The period of no activity before the warehouse is automatically suspended.

  • If the warehouse is suspended, whether to automatically resume the warehouse when needed.

  • The last time the warehouse resumed operation.

Privileges

Use the Privileges section to view, grant, and revoke privileges on the warehouse.

Resource Monitors

The Resource Monitors page lets you view and manage your resource monitors. The Resource Monitors page provides a detailed table of your resource monitors.

Use resource monitors to schedule actions that are triggered when usage of credit quota reaches a certain threshold. You specify the threshold for each resource monitor.

This section provides a brief overview of how to navigate and use the Resource Monitors page.

Interface

Description

Filter resource monitors

In the upper-right corner of the page, search and filter the table of your resource monitors. You can filter by:

  • Level

    • All (default)

    • (Empty)

    • Account

    • Warehouse

  • Warehouses

    • All (default)

    • (Empty)

    • A specific warehouse

  • Frequency

    • All (default)

    • Monthly

    • Daily

    • Weekly

    • Yearly

    • Never

Create resource monitor

In the upper-right corner of the page, select Resource Monitor to create a warehouse.

For assistive technology, the more button.

Resource monitor menu

Each row of the resource monitors table includes a menu of actions for the corresponding resource monitor.

The resource monitor menu lets you do the following:

  • Edit the resource monitor. You can configure the following warehouse options:

    • Name (view only)

    • Credit Quota

    • Monitor Type

    • Schedule

    • Actions

  • Drop the resource monitor.

For more information, Snowflake provides detailed technical documentation about resource monitors.

The resource monitors table includes the following columns:

  • Name

  • Quota Used

  • Level

  • Warehouses

  • Frequency

  • Start Time

To view additional details about a resource monitor, select a resource monitor in the table.

Resource Monitor Details

When you select a resource monitor in the resource monitors table, the resource monitor details page appears.

This section provides a brief overview of how to navigate and use the resource monitor details page.

Interface

Description

Basic details

Basic details about your resource monitor are located at the top of the page.

For assistive technology, the more button.

Resource monitor details menu

The resource monitor details menu, located in the upper-right corner of the page, lets you do the following:

  • Edit the resource monitor. You can configure the following resource monitor options:

    • Name (view only)

    • Credit Quota

    • Monitor Type

    • Schedule

    • Actions

  • Drop the resource monitor.

For more information, Snowflake provides detailed technical documentation about warehouses.

The resource monitor details page includes the following sections:

  • Details

  • Privileges

Details

The Details section provides additional information about your resource monitor, including:

  • The percentage of quota that has been consumed.

  • The level the resource monitor operates on (warehouse or account).

  • The credit quota, including used and remaining credits.

  • The frequency of operation.

  • When the resource monitor last started.

  • When the resource monitor last ended.

  • The threshold of quota usage that triggers a notification.

  • Whether to suspend credit usage by the warehouse or account when the threshold is reached.

Privileges

Use the Privileges section to view, grant, and revoke privileges on the resource monitor.

Users & Roles

The Users & Roles area of Snowsight includes two pages:

  • Users

  • Roles

This section provides a brief overview of how to navigate and use the Users & Roles area.

Interface

Description

Users and Roles pages

In the upper-left corner of the Users & Roles area, select the Users page (default) or the Roles page.

Users

The Users page lets you view and manage Snowflake users for your account. The Users page provides a detailed table of your users.

This section provides a brief overview of how to navigate and use the Users page.

Interface

Description

Filter users

In the upper-right corner of the page, search and filter the users table. You can filter by:

  • Owner

    • All (default)

    • (Empty)

    • A specific role, such as ACCOUNTADMIN.

  • Status

    • All (default)

    • (Empty)

    • Disabled

    • Enabled

    • Expired

    • Frozen

    • Locked

    • Temporary

Create user

In the upper-right corner of the page, select User to create a user.

For assistive technology, the more button.

User menu

Each row of the users table includes a menu of actions for the corresponding user.

The user menu lets you do the following:

  • Edit the user. You can configure the following user options:

    • User Name

    • Email

    • Comment

    • Login Name

    • Display Name

    • First Name

    • Last Name

    • Default Role

    • Default Warehouse

    • Default Namespace

  • Reset the user’s password.

  • Disable the user.

  • Drop the user.

  • Grant a role to the user.

  • Revoke a role from the user.

For more information, Snowflake provides detailed technical documentation about managing users.

Comment

If a user has a comment, the comment icon appears in the row for the corresponding user. To view the comment, hover over the comment icon.

The users table includes the following columns:

  • Name

  • Display Name

  • Status

  • Last Login

  • MFA (Multi-factor authentication)

  • Owner

To view additional details about a user, select a user in the table.

User Details

When you select a user in the users table, the user details page appears.

This section provides a brief overview of how to navigate and use the user details page.

Interface

Description

User details menu

The user details menu, located in the upper-right corner of the page, lets you do the following:

  • Edit the user. You can configure the following user options:

    • User Name

    • Email

    • Comment

    • Login Name

    • Display Name

    • First Name

    • Last Name

    • Default Role

    • Default Warehouse

    • Default Namespace

  • Reset the user’s password.

  • Disable the user.

  • Drop the user.

  • Grant a role to the user.

  • Revoke a role from the user.

For more information, Snowflake provides detailed technical documentation about managing users.

The user details page includes the following sections:

  • About

  • Privileges

  • Granted Roles

About

The About section provides additional information about your user, including:

  • The user’s login name.

  • The user’s display name.

  • The default role, warehouse, and namespace for the user.

  • Whether multi-factor authentication is enabled for the user.

  • The last time the user logged in.

  • The status of the user.

  • The number of roles granted to the user.

Privileges

Use the Privileges section to manage a user’s global Snowflake privileges. The Privileges section lets you grant global privileges on roles to your user, such as APPLY SESSION POLICY and MONITOR.

For more information, Snowflake provides detailed technical documentation about users and privileges.

Granted Roles

The Granted Roles section lists the roles granted to the user. Use the Granted Roles section to view, grant, and revoke roles.

Roles

The Roles page lets you view and manage roles for your account. The Roles page provides the following:

  • A graph that shows the relationships between your roles.

  • A detailed table of your roles.

This section provides a brief overview of how to navigate and use the Roles page.

Interface

Description

Roles tabs

The Roles page includes the following tabs:

  • Graph

  • Table

Create role

In the upper-right corner of the page, select Role to create a role.

Graph

The Graph tab provides the roles graph. The roles graph displays the hierarchy of roles in your account. Paths in the graph show inheritance. The graph is organized in descending order of hierarchy, representing inheritance from parent to child roles.

This section provides a brief overview of how to navigate and use the roles graph.

Interface

Description

Role and user explorer

The role and user explorer, located next to the left nav, lets you select individual roles and users. The selected role or user becomes the focus of the roles graph.

At the top of the role and user explorer, switch between Roles and Users to select a focus. Search the explorer to filter roles and users by name.

Roles graph

The roles graph, located in the center of the page, provides a visual hierarchy of your roles.

On the graph, select a role to view additional details about the role.

Graph navigation

In the upper-right corner of the graph, zoom in and out, and center the graph on the focused role or user.

Details

When you select a role, Details about the role appear on the right side of the graph.

Manage Grants provides the following actions:

  • Grant Role

  • Grant to Role

  • Grant to User

  • Revoke Grant of Role

  • Revoke Grant to Role

  • Revoke Grant to User

  • Manage Global Privileges

Details menu

The details menu, located in the upper-right corner of the details, lets you do the following:

  • Center the graph on the selected role.

  • View the role detail page.

For more information, Snowflake provides detailed technical documentation about managing roles.

Table

The roles table includes the following columns:

  • Name

  • Granted Roles

  • Granted To Roles

  • Users

  • Created

  • Owner

To view additional details about a role, select a role in the table.

Role Details

When you select a role in the roles table, the role details page appears.

This section provides a brief overview of how to navigate and use the role details page.

Interface

Description

Basic details

Basic details about the role are located at the top of the page.

For assistive technology, the more button.

Role details menu

The role details menu, located in the upper-right corner of the page, lets you do the following:

  • Grant a different role to this role.

  • Grant this role to a different role or user.

  • Revoke a different role from this role.

  • Revoke this role from a different role or user.

  • View, grant, and revoke global privileges.

  • Edit the role. You can configure the following role options:

    • Name

    • Comment

  • Drop the role

For more information, Snowflake provides detailed technical documentation about managing roles.

The role details page includes the following sections:

  • About

  • Privileges

  • Role grants

  • User grants

About

The About section provides additional information about your role, including:

  • The number of other roles granted to this role.

  • The number of other roles that are granted this role.

  • The number of other users that are granted this role.

Privileges

Use the Privileges section to manage a role’s global Snowflake privileges. The Privileges section lets you grant global privileges on other roles to this role, such as APPLY SESSION POLICY and MONITOR.

For more information, Snowflake provides detailed technical documentation about roles and privileges.

Role Grants

The role grants section includes two tabs:

  • Granted Roles

  • Granted to Roles

Use the tabs to view, grant, and revoke roles. You can search the tables to filter by name.

The Granted Roles tab provides a table of other roles granted to this role.

The Granted to Roles tab provides a table of other roles that are granted this role.

User Grants

The user grants section provides a table of users that are granted this role. Use the section to view, grant, and revoke roles. You can search the table to filter by name.

Security

The Security area of Snowsight includes two pages:

This section provides a brief overview of how to navigate and use the Security area.

Interface

Description

Network Policies and Sessions pages

In the upper-left corner of the Security area, select the Network Policies page (default) or the Sessions page.

Network Policies

The Network Policies page lets you view and manage your network policies. The Network Policies page is the default page for the Security area. The Network Policies page lists all your active and inactive network policies.

This section provides a brief overview of how to navigate and use the Network Policies page.

Interface

Description

Create network policy

In the upper-right corner of the page, select Network Policy to create a network policy.

To learn more, Snowflake provides detailed technical documentation about network policies.

Basic details

Each network policy on the page includes brief details and the current status (inactive or active) of the policy.

Activate and deactivate policies

Select Activate Policy, located on the right side of each network policy, to activate the corresponding network policy.

Select Deactivate Policy to deactivate the corresponding network policy.

Network policy menu

Each network policy on the page includes a menu of actions for the corresponding network policy.

The network policy menu lets you do the following:

  • Edit the network policy. You can configure the following network policy options:

    • Allowed IP addresses

    • Blocked IP addresses

    • Comment

  • Drop the network policy.

Network policy preview

The policy preview, located at the center of each network policy, lets you view and search the CIDRs and IP addresses in the network policy.

Sessions

The Sessions page provides a detailed table of open Snowflake sessions. The sessions table includes the following columns:

  • Session ID

  • User Name

  • Start Time

  • Client Driver

  • Client Net Address

  • Authentication

This section provides a brief overview of how to navigate and use the Sessions page.

Interface

Description

Filters

In the upper-right corner of the page, search and filter the sessions table. You can filter by:

  • User Name

    • All (default)

    • A specific user.

  • Client Driver

    • All (default)

    • Go

    • PythonConnector

  • Authentication

    • All (default)

    • OAuth

    • Password

    • Fed SAML 2.0

To learn more, Snowflake provides detailed technical documentation about sessions.

Billing

The Billing section of Snowsight includes two pages:

  • Payment Methods

  • Billing & Terms

This section provides a brief overview of how to navigate and use the Billing pages.

Interface

Description

The Billing section of the Snowsight with Billing & Terms selected.

Billing pages

In the upper-left corner of the Billing area, select the Payment Methods tab or the Billing & Terms tab.

Payment Methods

The Payment Methods tab lets you configure the credit card that you want to use with Snowflake.

To navigate and use the Payment Methods tab.

Interface

Description

Add credit card

Click Credit Card, located in the upper-right corner of the page, to add a payment method.

Billing & Terms

The Billing & Terms tab tab includes two sub-sections

Anaconda

The Anaconda Python packages sub-section of the Billing & Terms tab allows you to enable support for Python Anaconda packages.

and

Snowflake Marketplace Billing

The Snowflake Marketplace Billing sub-section lets you sign terms of service and configure a payment method for Snowflake Marketplace.

For more information about billing and the Snowflake Marketplace, see the Snowflake Marketplace documentation.

Contacts

The Notification Contacts page of Snowsight lets you set email addresses to receive security, privacy, and product notifications.

Emails are sent in accordance with the Snowflake Policy Notice.

Note

Only users with the ORGADMIN role can view contact information. Other users will not see Admin » Contacts. The role need not be currently active, but only granted.

Accounts

The Accounts page of Snowsight lets you view and manage accounts for your organization. The Accounts page provides a detailed table of your accounts.

This section provides a brief overview of how to navigate and use the Accounts page.

Interface

Description

Filters

In the upper-right corner of the page, search and filter the accounts table. You can filter by:

  • Edition

    • All (default)

    • Standard

    • Enterprise

    • Business Critical

  • Cloud

    • All (default)

    • AWS

    • Azure

    • GCP

  • Region

    • All (default)

    • Regions that have at least one account.

To learn more, Snowflake provides detailed technical documentation about editions, cloud platforms, and regions.

Create account

Use Account, located in the upper-right corner of the page, to create an account for your organization.

Note

Account is only visible if you are using the ORGADMIN role.

Partner Connect

The Partner Connect page of Snowsight lets you connect with third-party tools and services offered by Snowflake business partners. To learn more, see Snowflake Partner Connect.

This section provides a brief overview of how to navigate and use the Partner Connect page.

Interface

Description

In the upper-left corner of the Partner Connect page, search for a Snowflake partner.

Partner categories

Use the categories, located in the upper-left corner of the page, to filter the Partner Connect page. The page provides the following categories:

  • All Categories (default)

  • Business Intelligence

  • CI/CD

  • Data Integration

  • Data Science & ML

  • Security & Governance

Filters

In the upper-right corner of the page, filter partners. You can filter by:

  • Providers

    • All (default)

    • Individual Snowflake partners

  • Cloud

    • All (default)

    • Connected

    • Unconnected

Partner tiles

Partners appear as tiles in the center of the page. Select a partner to learn more about the offered capabilities and for free trial information.