Skip to main content

lake_formation_opt_ins

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

Overview

Namelake_formation_opt_ins
TypeResource
Idaws.lakeformation.lake_formation_opt_ins

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
lake_formation_opt_ins_info_listarrayA list of principal-resource pairs that have Lake Formation permissins enforced.
next_tokenstringA continuation token, if this is not the first call to retrieve this list.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
list_lake_formation_opt_insselectregionRetrieve the current list of resources and principals that are opt in to enforce Lake Formation permissions.
create_lake_formation_opt_ininsertregion, Principal, ResourceEnforce Lake Formation permissions for the given databases, tables, and principals.
delete_lake_formation_opt_indeleteregionRemove the Lake Formation permissions enforcement of the given databases, tables, and principals.

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
regionstringAWS region (default: us-east-1)

SELECT examples

Retrieve the current list of resources and principals that are opt in to enforce Lake Formation permissions.

SELECT
lake_formation_opt_ins_info_list,
next_token
FROM aws.lakeformation.lake_formation_opt_ins
WHERE region = '{{ region }}' -- required
;

INSERT examples

Enforce Lake Formation permissions for the given databases, tables, and principals.

INSERT INTO aws.lakeformation.lake_formation_opt_ins (
Principal,
Resource,
Condition,
region
)
SELECT
'{{ Principal }}' /* required */,
'{{ Resource }}' /* required */,
'{{ Condition }}',
'{{ region }}'
;

DELETE examples

Remove the Lake Formation permissions enforcement of the given databases, tables, and principals.

DELETE FROM aws.lakeformation.lake_formation_opt_ins
WHERE region = '{{ region }}' --required
;