Skip to content

/AWS1/CL_ATHACLCONFIGURATION

Indicates that an Amazon S3 canned ACL should be set to control ownership of stored query results, including data files inserted by Athena as the result of statements like CTAS or INSERT INTO. When Athena stores query results in Amazon S3, the canned ACL is set with the x-amz-acl request header. For more information about S3 Object Ownership, see Object Ownership settings in the Amazon S3 User Guide.

CONSTRUCTOR

IMPORTING

Required arguments:

iv_s3acloption TYPE /AWS1/ATHS3ACLOPTION /AWS1/ATHS3ACLOPTION

The Amazon S3 canned ACL that Athena should specify when storing query results, including data files inserted by Athena as the result of statements like CTAS or INSERT INTO. Currently the only supported canned ACL is BUCKET_OWNER_FULL_CONTROL. If a query runs in a workgroup and the workgroup overrides client-side settings, then the Amazon S3 canned ACL specified in the workgroup's settings is used for all queries that run in the workgroup. For more information about Amazon S3 canned ACLs, see Canned ACL in the Amazon S3 User Guide.


Queryable Attributes

S3AclOption

The Amazon S3 canned ACL that Athena should specify when storing query results, including data files inserted by Athena as the result of statements like CTAS or INSERT INTO. Currently the only supported canned ACL is BUCKET_OWNER_FULL_CONTROL. If a query runs in a workgroup and the workgroup overrides client-side settings, then the Amazon S3 canned ACL specified in the workgroup's settings is used for all queries that run in the workgroup. For more information about Amazon S3 canned ACLs, see Canned ACL in the Amazon S3 User Guide.

Accessible with the following methods

Method Description
GET_S3ACLOPTION() Getter for S3ACLOPTION, with configurable default
ASK_S3ACLOPTION() Getter for S3ACLOPTION w/ exceptions if field has no value
HAS_S3ACLOPTION() Determine if S3ACLOPTION has a value