This system table lists all the consumer groups known to the system. All users have access to the table.
| Column Name | Description |
|---|---|
| CONSUMER_GROUP_NAME | Name of the consumer group |
| CONSUMER_GROUP_ID | ID of the consumer group |
| CPU_WEIGHT | CPU Weight of the consumer group |
| PRECEDENCE | Precedence attribute of a consumer group used for tie-breaking |
| GROUP_TEMP_DB_RAM_LIMIT | Limit for Temp DB RAM usage by all sessions in the consumer group in MB |
| USER_TEMP_DB_RAM_LIMIT | Limit for Temp DB RAM usage by all sessions of a user in the consumer group in MB |
| SESSION_TEMP_DB_RAM_LIMIT | Limit for Temp DB RAM usage by each session in MB |
| CREATED | Timestamp when the consumer group was created |
| CONSUMER_GROUP_COMMENT | Comment on the consumer group |
| QUERY_TIMEOUT | Duration (in seconds) a statement may run before it is terminated |
| IDLE_TIMEOUT | Duration (in seconds) a session is terminated due to inactivity |