Administering Snowflake¶

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

• Warehouses

• Resource Monitors

• Users & Roles

• Security

• Billing

• Contacts

• Accounts

• Partner Connect

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.

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

• Filter usage

• Aggregate usage

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.

• Filter warehouses

• Create warehouse

• Warehouse menu

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.
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.

• Basic details

• Warehouse details menu

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.
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.

• Filter resource monitors

• Create resource monitor

• Resource monitor menu

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.
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.

• Basic details

• Resource monitor details menu

Interface	Description
Basic details	Basic details about your resource monitor are located at the top of the page.
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.

• Users and Roles pages

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.

• Filter users

• Create user

• User menu

• Comment

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.
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.

• User details menu

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.

• Roles tabs

• Create role

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.

• Role and user explorer

• Roles graph

• Graph navigation

• Details

• Details menu

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.

• Basic details

• Role details menu

Interface	Description
Basic details	Basic details about the role are located at the top of the page.
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:

• Network Policies

• Sessions

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

• Network Policies and Sessions pages

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.

• Create network policy

• Basic details

• Activate and deactivate policies

• Network policy menu

• Network policy preview

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.

• Filters

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
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.

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.

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.

• Filters

• Create account

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.

• Search

• Partner categories

• Filters

• Partner tiles

Interface	Description
Search	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.