Type object
Schema URL https://catalog.lintel.tools/schemas/schemastore/serverless-framework-configuration/_shared/latest--aws-athena-workgroup.json
Parent schema serverless-framework-configuration
Type: object

Properties

Name string | Aws_CF_FunctionString required

The workGroup name.

Description string | Aws_CF_FunctionString

The workgroup description.

Tags Tag[]
WorkGroupConfiguration object
9 nested properties
BytesScannedCutoffPerQuery integer

The upper data usage limit (cutoff) for the amount of bytes a single query in a workgroup is allowed to scan.

format=int64min=10000000
EnforceWorkGroupConfiguration boolean

If set to "true", the settings for the workgroup override client-side settings. If set to "false", client-side settings are used

PublishCloudWatchMetricsEnabled boolean

Indicates that the Amazon CloudWatch metrics are enabled for the workgroup.

RequesterPaysEnabled boolean

If set to true, allows members assigned to a workgroup to reference Amazon S3 Requester Pays buckets in queries. If set to false, workgroup members cannot query data from Requester Pays buckets, and queries that retrieve data from Requester Pays buckets cause an error.

ResultConfiguration object

The location in Amazon S3 where query results are stored and the encryption option, if any, used for query results. These are known as "client-side settings". If workgroup settings override client-side settings, then the query uses the workgroup settings.

4 nested properties
EncryptionConfiguration object

If query results are encrypted in Amazon S3, indicates the encryption option used (for example, SSE-KMS or CSE-KMS) and key information.

2 nested properties
EncryptionOption string | Aws_CF_FunctionString required

Indicates whether Amazon S3 server-side encryption with Amazon S3-managed keys (SSE-S3), server-side encryption with KMS-managed keys (SSE-KMS), or client-side encryption with KMS-managed keys (CSE-KMS) is used.

KmsKey string | Aws_CF_FunctionString

For SSE-KMS and CSE-KMS, this is the KMS key ARN or ID.

OutputLocation string | Aws_CF_FunctionString

The location in Amazon S3 where your query results are stored, such as s3://path/to/query/bucket/. To run the query, you must specify the query results location using one of the ways: either for individual queries using either this setting (client-side), or in the workgroup, using WorkGroupConfiguration

ExpectedBucketOwner string | Aws_CF_FunctionString

The AWS account ID of the owner of S3 bucket where query results are stored

AclConfiguration object

Indicates that an Amazon S3 canned ACL should be set to control ownership of stored query results

1 nested properties
S3AclOption string | Aws_CF_FunctionString required

The Amazon S3 canned ACL that Athena should specify when storing query results. Currently the only supported canned ACL is BUCKET_OWNER_FULL_CONTROL

EngineVersion object

The Athena engine version for running queries.

2 nested properties
SelectedEngineVersion string | Aws_CF_FunctionString

The engine version requested by the user. Possible values are determined by the output of ListEngineVersions, including Auto. The default is Auto.

EffectiveEngineVersion string | Aws_CF_FunctionString

Read only. The engine version on which the query runs. If the user requests a valid engine version other than Auto, the effective engine version is the same as the engine version that the user requested. If the user requests Auto, the effective engine version is chosen by Athena. When a request to update the engine version is made by a CreateWorkGroup or UpdateWorkGroup operation, the EffectiveEngineVersion field is ignored.

AdditionalConfiguration string | Aws_CF_FunctionString

Additional Configuration that are passed to Athena Spark Calculations running in this workgroup

ExecutionRole string | Aws_CF_FunctionString

Execution Role ARN required to run Athena Spark Calculations

CustomerContentEncryptionConfiguration object

Indicates the KMS key for encrypting notebook content.

1 nested properties
KmsKey string | Aws_CF_FunctionString required

For SSE-KMS and CSE-KMS, this is the KMS key ARN or ID.

WorkGroupConfigurationUpdates object

The configuration information that will be updated for this workgroup, which includes the location in Amazon S3 where query results are stored, the encryption option, if any, used for query results, whether the Amazon CloudWatch Metrics are enabled for the workgroup, whether the workgroup settings override the client-side settings, and the data usage limit for the amount of bytes scanned per query, if it is specified.

11 nested properties
BytesScannedCutoffPerQuery integer

The upper data usage limit (cutoff) for the amount of bytes a single query in a workgroup is allowed to scan.

format=int64min=10000000
EnforceWorkGroupConfiguration boolean

If set to "true", the settings for the workgroup override client-side settings. If set to "false", client-side settings are used

PublishCloudWatchMetricsEnabled boolean

Indicates that the Amazon CloudWatch metrics are enabled for the workgroup.

RequesterPaysEnabled boolean

If set to true, allows members assigned to a workgroup to reference Amazon S3 Requester Pays buckets in queries. If set to false, workgroup members cannot query data from Requester Pays buckets, and queries that retrieve data from Requester Pays buckets cause an error.

ResultConfigurationUpdates object

The result configuration information about the queries in this workgroup that will be updated. Includes the updated results location and an updated option for encrypting query results.

8 nested properties
EncryptionConfiguration object

If query results are encrypted in Amazon S3, indicates the encryption option used (for example, SSE-KMS or CSE-KMS) and key information.

2 nested properties
EncryptionOption string | Aws_CF_FunctionString required

Indicates whether Amazon S3 server-side encryption with Amazon S3-managed keys (SSE-S3), server-side encryption with KMS-managed keys (SSE-KMS), or client-side encryption with KMS-managed keys (CSE-KMS) is used.

KmsKey string | Aws_CF_FunctionString

For SSE-KMS and CSE-KMS, this is the KMS key ARN or ID.

OutputLocation string | Aws_CF_FunctionString

The location in Amazon S3 where your query results are stored, such as s3://path/to/query/bucket/. To run the query, you must specify the query results location using one of the ways: either for individual queries using either this setting (client-side), or in the workgroup, using WorkGroupConfiguration

ExpectedBucketOwner string | Aws_CF_FunctionString

The AWS account ID of the owner of S3 bucket where query results are stored

AclConfiguration object

Indicates that an Amazon S3 canned ACL should be set to control ownership of stored query results

1 nested properties
S3AclOption string | Aws_CF_FunctionString required

The Amazon S3 canned ACL that Athena should specify when storing query results. Currently the only supported canned ACL is BUCKET_OWNER_FULL_CONTROL

RemoveEncryptionConfiguration boolean
RemoveOutputLocation boolean
RemoveExpectedBucketOwner boolean
RemoveAclConfiguration boolean
RemoveBytesScannedCutoffPerQuery boolean

Indicates that the data usage control limit per query is removed.

EngineVersion object

The Athena engine version for running queries.

2 nested properties
SelectedEngineVersion string | Aws_CF_FunctionString

The engine version requested by the user. Possible values are determined by the output of ListEngineVersions, including Auto. The default is Auto.

EffectiveEngineVersion string | Aws_CF_FunctionString

Read only. The engine version on which the query runs. If the user requests a valid engine version other than Auto, the effective engine version is the same as the engine version that the user requested. If the user requests Auto, the effective engine version is chosen by Athena. When a request to update the engine version is made by a CreateWorkGroup or UpdateWorkGroup operation, the EffectiveEngineVersion field is ignored.

AdditionalConfiguration string | Aws_CF_FunctionString

Additional Configuration that are passed to Athena Spark Calculations running in this workgroup

ExecutionRole string | Aws_CF_FunctionString

Execution Role ARN required to run Athena Spark Calculations

CustomerContentEncryptionConfiguration object

Indicates the KMS key for encrypting notebook content.

1 nested properties
KmsKey string | Aws_CF_FunctionString required

For SSE-KMS and CSE-KMS, this is the KMS key ARN or ID.

RemoveCustomerContentEncryptionConfiguration boolean
State string | Aws_CF_FunctionString

The state of the workgroup: ENABLED or DISABLED.

RecursiveDeleteOption boolean

The option to delete the workgroup and its contents even if the workgroup contains any named queries.

Definitions

Tags Tag[]
Tag object
Key string | Aws_CF_FunctionString required
Value string | Aws_CF_FunctionString required
SelectedEngineVersion string | Aws_CF_FunctionString

The engine version requested by the user. Possible values are determined by the output of ListEngineVersions, including Auto. The default is Auto.

EffectiveEngineVersion string | Aws_CF_FunctionString

Read only. The engine version on which the query runs. If the user requests a valid engine version other than Auto, the effective engine version is the same as the engine version that the user requested. If the user requests Auto, the effective engine version is chosen by Athena. When a request to update the engine version is made by a CreateWorkGroup or UpdateWorkGroup operation, the EffectiveEngineVersion field is ignored.

EngineVersion object

The Athena engine version for running queries.

SelectedEngineVersion string | Aws_CF_FunctionString

The engine version requested by the user. Possible values are determined by the output of ListEngineVersions, including Auto. The default is Auto.

EffectiveEngineVersion string | Aws_CF_FunctionString

Read only. The engine version on which the query runs. If the user requests a valid engine version other than Auto, the effective engine version is the same as the engine version that the user requested. If the user requests Auto, the effective engine version is chosen by Athena. When a request to update the engine version is made by a CreateWorkGroup or UpdateWorkGroup operation, the EffectiveEngineVersion field is ignored.

BytesScannedCutoffPerQuery integer

The upper data usage limit (cutoff) for the amount of bytes a single query in a workgroup is allowed to scan.

EnforceWorkGroupConfiguration boolean

If set to "true", the settings for the workgroup override client-side settings. If set to "false", client-side settings are used

PublishCloudWatchMetricsEnabled boolean

Indicates that the Amazon CloudWatch metrics are enabled for the workgroup.

RequesterPaysEnabled boolean

If set to true, allows members assigned to a workgroup to reference Amazon S3 Requester Pays buckets in queries. If set to false, workgroup members cannot query data from Requester Pays buckets, and queries that retrieve data from Requester Pays buckets cause an error.

OutputLocation string | Aws_CF_FunctionString

The location in Amazon S3 where your query results are stored, such as s3://path/to/query/bucket/. To run the query, you must specify the query results location using one of the ways: either for individual queries using either this setting (client-side), or in the workgroup, using WorkGroupConfiguration

KmsKey string | Aws_CF_FunctionString

For SSE-KMS and CSE-KMS, this is the KMS key ARN or ID.

EncryptionOption string | Aws_CF_FunctionString

Indicates whether Amazon S3 server-side encryption with Amazon S3-managed keys (SSE-S3), server-side encryption with KMS-managed keys (SSE-KMS), or client-side encryption with KMS-managed keys (CSE-KMS) is used.

RemoveBytesScannedCutoffPerQuery boolean

Indicates that the data usage control limit per query is removed.

EncryptionConfiguration object

If query results are encrypted in Amazon S3, indicates the encryption option used (for example, SSE-KMS or CSE-KMS) and key information.

EncryptionOption string | Aws_CF_FunctionString required

Indicates whether Amazon S3 server-side encryption with Amazon S3-managed keys (SSE-S3), server-side encryption with KMS-managed keys (SSE-KMS), or client-side encryption with KMS-managed keys (CSE-KMS) is used.

KmsKey string | Aws_CF_FunctionString

For SSE-KMS and CSE-KMS, this is the KMS key ARN or ID.

RemoveEncryptionConfiguration boolean
AdditionalConfiguration string | Aws_CF_FunctionString

Additional Configuration that are passed to Athena Spark Calculations running in this workgroup

ExecutionRole string | Aws_CF_FunctionString

Execution Role ARN required to run Athena Spark Calculations

RemoveOutputLocation boolean
ExpectedBucketOwner string | Aws_CF_FunctionString

The AWS account ID of the owner of S3 bucket where query results are stored

RemoveExpectedBucketOwner boolean
S3AclOption string | Aws_CF_FunctionString

The Amazon S3 canned ACL that Athena should specify when storing query results. Currently the only supported canned ACL is BUCKET_OWNER_FULL_CONTROL

AclConfiguration object

Indicates that an Amazon S3 canned ACL should be set to control ownership of stored query results

S3AclOption string | Aws_CF_FunctionString required

The Amazon S3 canned ACL that Athena should specify when storing query results. Currently the only supported canned ACL is BUCKET_OWNER_FULL_CONTROL

RemoveAclConfiguration boolean
CustomerContentEncryptionConfiguration object

Indicates the KMS key for encrypting notebook content.

KmsKey string | Aws_CF_FunctionString required

For SSE-KMS and CSE-KMS, this is the KMS key ARN or ID.

RemoveCustomerContentEncryptionConfiguration boolean
ResultConfiguration object

The location in Amazon S3 where query results are stored and the encryption option, if any, used for query results. These are known as "client-side settings". If workgroup settings override client-side settings, then the query uses the workgroup settings.

EncryptionConfiguration object

If query results are encrypted in Amazon S3, indicates the encryption option used (for example, SSE-KMS or CSE-KMS) and key information.

2 nested properties
EncryptionOption string | Aws_CF_FunctionString required

Indicates whether Amazon S3 server-side encryption with Amazon S3-managed keys (SSE-S3), server-side encryption with KMS-managed keys (SSE-KMS), or client-side encryption with KMS-managed keys (CSE-KMS) is used.

KmsKey string | Aws_CF_FunctionString

For SSE-KMS and CSE-KMS, this is the KMS key ARN or ID.

OutputLocation string | Aws_CF_FunctionString

The location in Amazon S3 where your query results are stored, such as s3://path/to/query/bucket/. To run the query, you must specify the query results location using one of the ways: either for individual queries using either this setting (client-side), or in the workgroup, using WorkGroupConfiguration

ExpectedBucketOwner string | Aws_CF_FunctionString

The AWS account ID of the owner of S3 bucket where query results are stored

AclConfiguration object

Indicates that an Amazon S3 canned ACL should be set to control ownership of stored query results

1 nested properties
S3AclOption string | Aws_CF_FunctionString required

The Amazon S3 canned ACL that Athena should specify when storing query results. Currently the only supported canned ACL is BUCKET_OWNER_FULL_CONTROL

ResultConfigurationUpdates object

The result configuration information about the queries in this workgroup that will be updated. Includes the updated results location and an updated option for encrypting query results.

EncryptionConfiguration object

If query results are encrypted in Amazon S3, indicates the encryption option used (for example, SSE-KMS or CSE-KMS) and key information.

2 nested properties
EncryptionOption string | Aws_CF_FunctionString required

Indicates whether Amazon S3 server-side encryption with Amazon S3-managed keys (SSE-S3), server-side encryption with KMS-managed keys (SSE-KMS), or client-side encryption with KMS-managed keys (CSE-KMS) is used.

KmsKey string | Aws_CF_FunctionString

For SSE-KMS and CSE-KMS, this is the KMS key ARN or ID.

OutputLocation string | Aws_CF_FunctionString

The location in Amazon S3 where your query results are stored, such as s3://path/to/query/bucket/. To run the query, you must specify the query results location using one of the ways: either for individual queries using either this setting (client-side), or in the workgroup, using WorkGroupConfiguration

ExpectedBucketOwner string | Aws_CF_FunctionString

The AWS account ID of the owner of S3 bucket where query results are stored

AclConfiguration object

Indicates that an Amazon S3 canned ACL should be set to control ownership of stored query results

1 nested properties
S3AclOption string | Aws_CF_FunctionString required

The Amazon S3 canned ACL that Athena should specify when storing query results. Currently the only supported canned ACL is BUCKET_OWNER_FULL_CONTROL

RemoveEncryptionConfiguration boolean
RemoveOutputLocation boolean
RemoveExpectedBucketOwner boolean
RemoveAclConfiguration boolean
WorkGroupConfiguration object
BytesScannedCutoffPerQuery integer

The upper data usage limit (cutoff) for the amount of bytes a single query in a workgroup is allowed to scan.

format=int64min=10000000
EnforceWorkGroupConfiguration boolean

If set to "true", the settings for the workgroup override client-side settings. If set to "false", client-side settings are used

PublishCloudWatchMetricsEnabled boolean

Indicates that the Amazon CloudWatch metrics are enabled for the workgroup.

RequesterPaysEnabled boolean

If set to true, allows members assigned to a workgroup to reference Amazon S3 Requester Pays buckets in queries. If set to false, workgroup members cannot query data from Requester Pays buckets, and queries that retrieve data from Requester Pays buckets cause an error.

ResultConfiguration object

The location in Amazon S3 where query results are stored and the encryption option, if any, used for query results. These are known as "client-side settings". If workgroup settings override client-side settings, then the query uses the workgroup settings.

4 nested properties
EncryptionConfiguration object

If query results are encrypted in Amazon S3, indicates the encryption option used (for example, SSE-KMS or CSE-KMS) and key information.

2 nested properties
EncryptionOption string | Aws_CF_FunctionString required

Indicates whether Amazon S3 server-side encryption with Amazon S3-managed keys (SSE-S3), server-side encryption with KMS-managed keys (SSE-KMS), or client-side encryption with KMS-managed keys (CSE-KMS) is used.

KmsKey string | Aws_CF_FunctionString

For SSE-KMS and CSE-KMS, this is the KMS key ARN or ID.

OutputLocation string | Aws_CF_FunctionString

The location in Amazon S3 where your query results are stored, such as s3://path/to/query/bucket/. To run the query, you must specify the query results location using one of the ways: either for individual queries using either this setting (client-side), or in the workgroup, using WorkGroupConfiguration

ExpectedBucketOwner string | Aws_CF_FunctionString

The AWS account ID of the owner of S3 bucket where query results are stored

AclConfiguration object

Indicates that an Amazon S3 canned ACL should be set to control ownership of stored query results

1 nested properties
S3AclOption string | Aws_CF_FunctionString required

The Amazon S3 canned ACL that Athena should specify when storing query results. Currently the only supported canned ACL is BUCKET_OWNER_FULL_CONTROL

EngineVersion object

The Athena engine version for running queries.

2 nested properties
SelectedEngineVersion string | Aws_CF_FunctionString

The engine version requested by the user. Possible values are determined by the output of ListEngineVersions, including Auto. The default is Auto.

EffectiveEngineVersion string | Aws_CF_FunctionString

Read only. The engine version on which the query runs. If the user requests a valid engine version other than Auto, the effective engine version is the same as the engine version that the user requested. If the user requests Auto, the effective engine version is chosen by Athena. When a request to update the engine version is made by a CreateWorkGroup or UpdateWorkGroup operation, the EffectiveEngineVersion field is ignored.

AdditionalConfiguration string | Aws_CF_FunctionString

Additional Configuration that are passed to Athena Spark Calculations running in this workgroup

ExecutionRole string | Aws_CF_FunctionString

Execution Role ARN required to run Athena Spark Calculations

CustomerContentEncryptionConfiguration object

Indicates the KMS key for encrypting notebook content.

1 nested properties
KmsKey string | Aws_CF_FunctionString required

For SSE-KMS and CSE-KMS, this is the KMS key ARN or ID.

WorkGroupConfigurationUpdates object

The configuration information that will be updated for this workgroup, which includes the location in Amazon S3 where query results are stored, the encryption option, if any, used for query results, whether the Amazon CloudWatch Metrics are enabled for the workgroup, whether the workgroup settings override the client-side settings, and the data usage limit for the amount of bytes scanned per query, if it is specified.

BytesScannedCutoffPerQuery integer

The upper data usage limit (cutoff) for the amount of bytes a single query in a workgroup is allowed to scan.

format=int64min=10000000
EnforceWorkGroupConfiguration boolean

If set to "true", the settings for the workgroup override client-side settings. If set to "false", client-side settings are used

PublishCloudWatchMetricsEnabled boolean

Indicates that the Amazon CloudWatch metrics are enabled for the workgroup.

RequesterPaysEnabled boolean

If set to true, allows members assigned to a workgroup to reference Amazon S3 Requester Pays buckets in queries. If set to false, workgroup members cannot query data from Requester Pays buckets, and queries that retrieve data from Requester Pays buckets cause an error.

ResultConfigurationUpdates object

The result configuration information about the queries in this workgroup that will be updated. Includes the updated results location and an updated option for encrypting query results.

8 nested properties
EncryptionConfiguration object

If query results are encrypted in Amazon S3, indicates the encryption option used (for example, SSE-KMS or CSE-KMS) and key information.

2 nested properties
EncryptionOption string | Aws_CF_FunctionString required

Indicates whether Amazon S3 server-side encryption with Amazon S3-managed keys (SSE-S3), server-side encryption with KMS-managed keys (SSE-KMS), or client-side encryption with KMS-managed keys (CSE-KMS) is used.

KmsKey string | Aws_CF_FunctionString

For SSE-KMS and CSE-KMS, this is the KMS key ARN or ID.

OutputLocation string | Aws_CF_FunctionString

The location in Amazon S3 where your query results are stored, such as s3://path/to/query/bucket/. To run the query, you must specify the query results location using one of the ways: either for individual queries using either this setting (client-side), or in the workgroup, using WorkGroupConfiguration

ExpectedBucketOwner string | Aws_CF_FunctionString

The AWS account ID of the owner of S3 bucket where query results are stored

AclConfiguration object

Indicates that an Amazon S3 canned ACL should be set to control ownership of stored query results

1 nested properties
S3AclOption string | Aws_CF_FunctionString required

The Amazon S3 canned ACL that Athena should specify when storing query results. Currently the only supported canned ACL is BUCKET_OWNER_FULL_CONTROL

RemoveEncryptionConfiguration boolean
RemoveOutputLocation boolean
RemoveExpectedBucketOwner boolean
RemoveAclConfiguration boolean
RemoveBytesScannedCutoffPerQuery boolean

Indicates that the data usage control limit per query is removed.

EngineVersion object

The Athena engine version for running queries.

2 nested properties
SelectedEngineVersion string | Aws_CF_FunctionString

The engine version requested by the user. Possible values are determined by the output of ListEngineVersions, including Auto. The default is Auto.

EffectiveEngineVersion string | Aws_CF_FunctionString

Read only. The engine version on which the query runs. If the user requests a valid engine version other than Auto, the effective engine version is the same as the engine version that the user requested. If the user requests Auto, the effective engine version is chosen by Athena. When a request to update the engine version is made by a CreateWorkGroup or UpdateWorkGroup operation, the EffectiveEngineVersion field is ignored.

AdditionalConfiguration string | Aws_CF_FunctionString

Additional Configuration that are passed to Athena Spark Calculations running in this workgroup

ExecutionRole string | Aws_CF_FunctionString

Execution Role ARN required to run Athena Spark Calculations

CustomerContentEncryptionConfiguration object

Indicates the KMS key for encrypting notebook content.

1 nested properties
KmsKey string | Aws_CF_FunctionString required

For SSE-KMS and CSE-KMS, this is the KMS key ARN or ID.

RemoveCustomerContentEncryptionConfiguration boolean