Skip to main content

capacity_reservations

Creates, updates, deletes or gets a capacity_reservation resource or lists capacity_reservations in a region

Overview

Namecapacity_reservations
TypeResource
DescriptionResource schema for AWS::Athena::CapacityReservation
Idawscc.athena.capacity_reservations

Fields

NameDatatypeDescription
arnstringThe Amazon Resource Name (ARN) of the specified capacity reservation
namestringThe reservation name.
statusstringThe status of the reservation.
target_dpusintegerThe number of DPUs to request to be allocated to the reservation.
allocated_dpusintegerThe number of DPUs Athena has provisioned and allocated for the reservation
capacity_assignment_configurationobjectAssignment configuration to assign workgroups to a reservation
creation_timestringThe date and time the reservation was created.
last_successful_allocation_timestringThe timestamp when the last successful allocated was made
tagsarrayAn array of key-value pairs to apply to this resource.
regionstringAWS region.

For more information, see AWS::Athena::CapacityReservation.

Methods

NameResourceAccessible byRequired Params
create_resourcecapacity_reservationsINSERTName, TargetDpus, region
delete_resourcecapacity_reservationsDELETEIdentifier, region
update_resourcecapacity_reservationsUPDATEIdentifier, PatchDocument, region
list_resourcescapacity_reservations_list_onlySELECTregion
get_resourcecapacity_reservationsSELECTIdentifier, region

SELECT examples

Gets all properties from an individual capacity_reservation.

SELECT
region,
arn,
name,
status,
target_dpus,
allocated_dpus,
capacity_assignment_configuration,
creation_time,
last_successful_allocation_time,
tags
FROM awscc.athena.capacity_reservations
WHERE
region = 'us-east-1' AND
Identifier = '{{ arn }}';

INSERT example

Use the following StackQL query and manifest file to create a new capacity_reservation resource, using stack-deploy.

/*+ create */
INSERT INTO awscc.athena.capacity_reservations (
Name,
TargetDpus,
region
)
SELECT
'{{ name }}',
'{{ target_dpus }}',
'{{ region }}';

UPDATE example

Use the following StackQL query and manifest file to update a capacity_reservation resource, using stack-deploy.

/*+ update */
UPDATE awscc.athena.capacity_reservations
SET PatchDocument = string('{{ {
"TargetDpus": target_dpus,
"CapacityAssignmentConfiguration": capacity_assignment_configuration,
"Tags": tags
} | generate_patch_document }}')
WHERE
region = '{{ region }}' AND
Identifier = '{{ arn }}';

DELETE example

/*+ delete */
DELETE FROM awscc.athena.capacity_reservations
WHERE
Identifier = '{{ arn }}' AND
region = 'us-east-1';

Permissions

To operate on the capacity_reservations resource, the following permissions are required:

athena:CreateCapacityReservation,
athena:PutCapacityAssignmentConfiguration,
athena:GetCapacityReservation,
athena:TagResource