Skip to main content

users_by_permission_groups

Creates, updates, deletes, gets or lists a users_by_permission_groups resource.

Overview

Nameusers_by_permission_groups
TypeResource
Idaws.finspace_data.users_by_permission_groups

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
next_tokenstringA token that indicates where a results page should begin.
usersarrayLists details of all users in a specific permission group.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
list_users_by_permission_groupselectpermission_group_id, maxResults, regionnextTokenLists details of all the users in a specific permission group.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
maxResultsintegerThe maximum number of results per page.
permission_group_idstringThe unique identifier for the permission group.
regionstringAWS region (default: us-east-1)
nextTokenstringA token that indicates where a results page should begin.

SELECT examples

Lists details of all the users in a specific permission group.

SELECT
next_token,
users
FROM aws.finspace_data.users_by_permission_groups
WHERE permission_group_id = '{{ permission_group_id }}' -- required
AND maxResults = '{{ maxResults }}' -- required
AND region = '{{ region }}' -- required
AND nextToken = '{{ nextToken }}'
;