Table: keycloak_group
Obtaining groups from the Keycloak realm.
Examples
List all groups
select *from keycloak_group;
Get a specific group by name
select *from keycloak_groupwhere name = 'my-group';
Get a specific group by id
select *from keycloak_groupwhere id = 'eb5342ee-c1bd-4ed2-b84f-fa7880539ccf';
List a subset of groups which have a name containing '7'
select *from keycloak_groupwhere name like '%7%';
Schema for keycloak_group
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
id | text | Unique identifier for the group | |
name | text | Name of the group | |
path | text | Path of the group |