Skip to main content

permission_groups_by_users

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

Overview

Namepermission_groups_by_users
TypeResource
Idaws.finspace_data.permission_groups_by_users

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
next_tokenstringA token that indicates where a results page should begin.
permission_groupsarrayA list of returned permission groups.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
list_permission_groups_by_userselectuser_id, maxResults, regionnextTokenLists all the permission groups that are associated with a specific user.

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.
regionstringAWS region (default: us-east-1)
user_idstringThe unique identifier for the user.
nextTokenstringA token that indicates where a results page should begin.

SELECT examples

Lists all the permission groups that are associated with a specific user.

SELECT
next_token,
permission_groups
FROM aws.finspace_data.permission_groups_by_users
WHERE user_id = '{{ user_id }}' -- required
AND maxResults = '{{ maxResults }}' -- required
AND region = '{{ region }}' -- required
AND nextToken = '{{ nextToken }}'
;