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

Navigation:

Monitor

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

Navigation:

Monitor

  1. Click the + Resource Monitor button in the top-right corner of the page. The New Resource Monitor dialog opens.

  2. Complete the fields in the dialog:

    Property

    Description

    Name

    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. "My object").

    Identifiers enclosed in double quotes are also case-sensitive.

    Credit Quota

    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.

    Monitor Type

    Type of resource monitor: ACCOUNT or WAREHOUSE.

    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

    Warehouse-level resource monitors only. One or more warehouses whose credit usage is controlled by the resource monitor.

    Schedule

    The date and time when the resource monitor starts monitoring credit usage for the assigned warehouses.

    Actions

    One or more triggers for the resource monitor.

  3. Click the Create Resource Monitor button. The new resource monitor is created.

Modifying Resource Monitor Properties

Navigation:

Monitor

  1. Click the actions () button in the row for a resource monitor » Edit. The Edit Resource Monitor dialog opens.

  2. Edit any of the properties. For descriptions of the properties, see Creating Resource Monitors (in this topic).

Dropping the Resource Monitor

Navigation:

Monitor

  1. Click the actions () button in the row for a resource monitor » Drop. The Drop Resource Monitor dialog opens.

  2. Confirm the action.

Managing Access Control on Resource Monitors

Navigation:

Monitor

  1. Navigate to the resource monitor you want to grant privileges on.

  2. 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 Inherited privileges 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:

    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:

  1. From the Privileges area on the details page for a resource monitor, click the + Privileges button. The Grant new privileges dialog opens.

  2. Select a role from the dropdown menu.

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

  4. Repeat the previous step for any additional privileges you want to grant to the same role.

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

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

  2. Click the X button to the right of a privilege. The privilege is removed from the dialog.

  3. Repeat the previous step for any additional privileges you want to revoke from the same role.

  4. Click the Update Privileges button. The dialog closes. The privileges you removed are revoked from the role.