User groups.

Table Specific Information

Required Scopes

To query this table, Scope must include okta.groups.read. To edit this table, it must include okta.groups.manage.

Select

The driver uses the Okta API to process WHERE clause conditions built with the following columns and operators.

• Id supports the '=' and 'LIKE (starts with)' operators
• Created supports the '>', '>=', '=', '<=', and '<' operators
• LastUpdated supports the '>', '>=', '=', '<=', and '<' operators
• LastMembershipUpdated supports the '>', '>=', '=', '<=', and '<' operators
• Type supports the '=' and 'LIKE (starts with)' operators
• ProfileName supports the '=' and 'LIKE (starts with)' operators
• ProfileDescription supports the '=' and 'LIKE (starts with)' operators

All other filters are processed client-side within the driver.

For example, the following queries are processed server-side:

SELECT * FROM Groups WHERE Id = '00g1emaKYZTWRYYRRTSK'

SELECT * FROM Groups WHERE LastUpdated > '2024-08-01'

Insert

A sample Insert is given below.

INSERT INTO Groups (ProfileName, ProfileDescription) VALUES ('InsertedGroup1', 'My group')

Update

Only the ProfileName and ProfileDescription can be updated. Note that you only can modify profiles for groups of the OKTA_GROUP type.

A sample Update is given below.

UPDATE Groups SET ProfileName = 'UpdatedGroup' WHERE Id = '00gkveusprX916AYw5d7'

Delete

Only groups of type OKTA_GROUP and APP_GROUP can be deleted. Note that you can't remove groups of type APP_GROUP if they are used in a group push mapping.

A sample Delete is given below.

DELETE FROM Groups WHERE Id = '00gkveusprX916AYw5d7'

Columns

Name	Type	ReadOnly	Description
Id [KEY]	String	True	Id of the group
Created	Datetime	True	When the group was created
LastUpdated	Datetime	True	When the group's profile was last updated
LastMembershipUpdated	Datetime	True	When the group's memberships were last updated
ObjectClass	String	True	Determines the group's profile
Type	String	True	Determines how the profile and memberships are managed
ProfileName	String	False	The group's profile name
ProfileDescription	String	False	The group's profile description