Skip to main content

s3_access_policies

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

Overview

Names3_access_policies
TypeResource
Idaws.omics.s3_access_policies

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
s_3_access_point_arnstringThe S3 access point ARN that has the access policy. (pattern: <code>arn:[^:]:s3:[^:]:[^:]:accesspoint/.</code>)
s_3_access_policystringThe current resource policy that controls S3 access on the store.
store_idstringThe Amazon Web Services-generated Sequence Store or Reference Store ID. (pattern: <code>[0-9]+</code>)
store_typestringThe type of store associated with the access point. (SEQUENCE_STORE, REFERENCE_STORE)
update_timestring (date-time)The time when the policy was last updated.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
get_s3_access_policyselects3_access_point_arn, regionRetrieves details about an access policy on a given store.
put_s3_access_policyreplaces3_access_point_arn, region, s3AccessPolicyAdds an access policy to the specified store.
delete_s3_access_policydeletes3_access_point_arn, regionDeletes an access policy for the specified store.

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)
s3_access_point_arnstringThe S3 access point ARN that has the access policy.

SELECT examples

Retrieves details about an access policy on a given store.

SELECT
s_3_access_point_arn,
s_3_access_policy,
store_id,
store_type,
update_time
FROM aws.omics.s3_access_policies
WHERE s3_access_point_arn = '{{ s3_access_point_arn }}' -- required
AND region = '{{ region }}' -- required
;

REPLACE examples

Adds an access policy to the specified store.

REPLACE aws.omics.s3_access_policies
SET
s3AccessPolicy = '{{ s3AccessPolicy }}'
WHERE
s3_access_point_arn = '{{ s3_access_point_arn }}' --required
AND region = '{{ region }}' --required
AND s3AccessPolicy = '{{ s3AccessPolicy }}' --required
RETURNING
s_3_access_point_arn,
store_id,
store_type;

DELETE examples

Deletes an access policy for the specified store.

DELETE FROM aws.omics.s3_access_policies
WHERE s3_access_point_arn = '{{ s3_access_point_arn }}' --required
AND region = '{{ region }}' --required
;