Resource Group

Overview

A resource group defines resource quotas for users, preventing any single user from consuming all cluster resources. Administrators can create resource groups with limits on connections, concurrent queries, query timeouts, and accessible graphs, then bind users to these groups.

Users not bound to any resource group have no resource limits applied (backward compatible).

Showing Resource Groups

To show all resource groups:

GQL
SHOW RESOURCE GROUP

To show a specific resource group:

GQL
SHOW RESOURCE GROUP limited_group

Each resource group provides the following metadata:

Creating a Resource Group

To create a resource group with all options:

GQL
CREATE RESOURCE GROUP limited_group
  SET max_connections = 10,
      max_concurrent_queries = 5,
      max_query_timeout = 30,
      max_graphs = 3

To create a resource group with partial options (unspecified options default to 0, meaning unlimited):

GQL
CREATE RESOURCE GROUP basic_group SET max_connections = 10

Altering a Resource Group

To modify specific options of a resource group (other options remain unchanged):

GQL
ALTER RESOURCE GROUP limited_group SET max_concurrent_queries = 10

To reset a limit to unlimited:

GQL
ALTER RESOURCE GROUP limited_group SET max_connections = 0

Dropping a Resource Group

All users must be unbound from the resource group before it can be dropped.

GQL
DROP RESOURCE GROUP limited_group

To suppress errors if the resource group does not exist:

GQL
DROP RESOURCE GROUP IF EXISTS limited_group

Binding Users

To bind a user to a resource group:

GQL
ALTER USER analyst SET RESOURCE GROUP limited_group

To unbind a user from its resource group:

GQL
ALTER USER analyst REMOVE RESOURCE GROUP

Resource Limits

A value of 0 for any limit means no restriction.

Required Privileges