Managing Resource Monitors¶
The Monitor page in the new web interface allows users to take the following actions on virtual resource monitors:
View resource monitors and explore resource monitor details. The page only displays details for the resource monitors that the role has sufficient privileges to view.
Create or modify resource monitors.
Resume or suspend resource monitors.
Manage access control for resource monitors:
View the privileges that have been granted on resource monitors to roles. Group the listing by role or privilege.
Grant or revoke privileges on resource monitors.
In this Topic:
Exploring Resource Monitors¶
In the table of resource monitors on the page, click on the name of a resource monitor. The resource monitor details page opens.
Creating Resource Monitors¶
Click the + Resource Monitor button in the top-right corner of the page. The New Resource Monitor dialog opens.
Complete the fields in the dialog:
Unique identifier for the resource monitor.
The identifier must start with an alphabetic character and cannot contain spaces or special characters unless the entire identifier string is enclosed in double quotes (e.g.
Identifiers enclosed in double quotes are also case-sensitive.
Number of credits allocated to the resource monitor per frequency interval.
When total usage for all warehouses assigned to the monitor reaches this number for the current frequency interval, the resource monitor is considered to be at 100% of quota.
Type of resource monitor:
The account-level resource monitor controls credit usage for all warehouses in your account; whereas a warehouse-level resource monitor controls credit usage for one or more specified warehouses.
Warehouse-level resource monitors only. One or more warehouses whose credit usage is controlled by the resource monitor.
The date and time when the resource monitor starts monitoring credit usage for the assigned warehouses.
One or more triggers for the resource monitor.
Click the Create Resource Monitor button. The new resource monitor is created.
Modifying Resource Monitor Properties¶
Click the actions (…) button in the row for a resource monitor » Edit. The Edit Resource Monitor dialog opens.
Edit any of the properties. For descriptions of the properties, see Creating Resource Monitors (in this topic).
Dropping the Resource Monitor¶
Click the actions (…) button in the row for a resource monitor » Drop. The Drop Resource Monitor dialog opens.
Confirm the action.
Managing Access Control on Resource Monitors¶
Navigate to the resource monitor you want to grant privileges on.
Scroll to the Privileges area of the page. The Privileges area lists the privilege grants by role. To group the list by privilege, choose this option from the menu at the top of the Privileges area.
When the listing of privilege grants is grouped by privilege, the symbol beside a role indicates that the privilege was inherited from a child role in a role hierarchy. Hover your pointer over the role to view the child role from which the privilege was inherited.
Administrators of resource monitors can perform either of the following actions to manage the privileges granted on resource monitors:
Grant additional privileges on resource monitors to other roles. This action is identical to granting privileges using GRANT <privileges> … TO ROLE.
Revoke existing privileges on resource monitors from roles. This action is identical to revoking privileges using REVOKE <privileges> … FROM ROLE.
Either action requires one of the following roles:
The owner of a resource monitor (e.g. the role with the OWNERSHIP privilege on the resource monitor).
A role with the global MANAGE GRANTS privilege.
Granting Privileges on Resource Monitors to Other Roles¶
To grant privileges on resource monitors:
From the Privileges area on the details page for a resource monitor, click the + Privileges button. The Grant new privileges dialog opens.
Select a role from the dropdown menu.
Select a privilege from the dropdown menu. The dialog displays the privilege below the dropdown menus. To give the selected role the ability to grant the privilege to other roles, click the Grant option box.
Repeat the previous step for any additional privileges you want to grant to the same role.
Click the Grant Privileges button. The dialog closes. The privileges you selected are added to the role.
Revoking Privileges on Resource Monitors From Other Roles¶
To revoke privileges on resource monitors:
From the Privileges area on the details page for a resource monitor, click on the row for a role. The Edit privileges for <role_name> dialog opens. The dialog lists the privileges currently granted on the resource monitor to the selected role.
Xbutton to the right of a privilege. The privilege is removed from the dialog.
Repeat the previous step for any additional privileges you want to revoke from the same role.
Click the Update Privileges button. The dialog closes. The privileges you removed are revoked from the role.