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.
This section provides a brief overview of how to navigate and use the Usage page.
Interface |
Description |
---|---|
Use the filters, located in the upper-left corner of the page, to filter your usage data. You can filter by:
|
|
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 |
---|---|
In the upper-right corner of the page, search and filter the table of your warehouses. You can filter by:
|
|
In the upper-right corner of the page, select Warehouse to create a warehouse. |
|
Each row of the warehouses table includes a menu of actions for the corresponding warehouse. The warehouse menu lets you do the following:
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 about your warehouse are located at the top of the page. Hover over the details to view additional information. |
|
The warehouse details menu, located in the upper-right corner of the page, lets you do the following:
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 |
---|---|
In the upper-right corner of the page, search and filter the table of your resource monitors. You can filter by:
|
|
In the upper-right corner of the page, select Resource Monitor to create a warehouse. |
|
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:
|
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 about your resource monitor are located at the top of the page. |
|
The resource monitor details menu, located in the upper-right corner of the page, lets you do the following:
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 |
---|---|
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 |
---|---|
In the upper-right corner of the page, search and filter the users table. You can filter by:
|
|
In the upper-right corner of the page, select User to create a user. |
|
Each row of the users table includes a menu of actions for the corresponding user. The user menu lets you do the following:
For more information, Snowflake provides detailed technical documentation about managing users. |
|
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 |
---|---|
The user details menu, located in the upper-right corner of the page, lets you do the following:
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 |
---|---|
The Roles page includes the following tabs:
|
|
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 |
---|---|
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. |
|
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. |
|
In the upper-right corner of the graph, zoom in and out, and center the graph on the focused role or user. |
|
When you select a role, Details about the role appear on the right side of the graph. Manage Grants provides the following actions:
|
|
The details menu, located in the upper-right corner of the details, lets you do the following:
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 about the role are located at the top of the page. |
|
The role details menu, located in the upper-right corner of the page, lets you do the following:
|
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 |
---|---|
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 |
---|---|
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. |
|
Each network policy on the page includes brief details and the current status (inactive or active) of the policy. |
|
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. |
|
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:
|
|
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 |
---|---|
In the upper-right corner of the page, search and filter the sessions table. You can filter by:
|
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 |
---|---|
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 |
---|---|
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 |
---|---|
In the upper-right corner of the page, search and filter the accounts table. You can filter by:
To learn more, Snowflake provides detailed technical documentation about editions, cloud platforms, and regions. |
|
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. |
|
Use the categories, located in the upper-left corner of the page, to filter the Partner Connect page. The page provides the following categories:
|
|
In the upper-right corner of the page, filter partners. You can filter by:
|
|
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. |