ALTER GROUP UNSET RESOURCE GROUP reference
Resource groups isolate competing query workloads inside a single QuestDB instance.
ALTER GROUP ... UNSET RESOURCE GROUP removes the ACL group's
resource group mapping, along with its
priority.
Syntax
ALTER GROUP groupName UNSET RESOURCE GROUP;
Description
Members stop inheriting the mapping from this group. Each one falls back to the
highest-priority mapping among its remaining ACL groups, or to DEFAULT. A
member with a direct mapping of its own is unaffected, because a direct mapping
always won anyway.
The priority is removed with the mapping; there is no way to clear one while keeping the other.
The statement requires the
RESOURCE GROUP ADMIN permission, and affects
queries that start after the change rather than one already running.
Unmapping is also the prerequisite for dropping a resource group:
DROP RESOURCE GROUP is refused
while any principal is still mapped to it.
Examples
ALTER GROUP analysts UNSET RESOURCE GROUP;
SHOW GROUPS then reports null in both columns:
SELECT name, resource_group, resource_group_priority FROM (SHOW GROUPS);
| name | resource_group | resource_group_priority |
|---|---|---|
| analysts | null | null |