Skip to main content

volumes

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

Overview

Namevolumes
TypeResource
Idaws.workspaces_instances.volumes

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
create_volumeinsertregion, AvailabilityZoneCreates a new volume for WorkSpace Instances.
associate_volumeupdateregion, WorkspaceInstanceId, VolumeId, DeviceAttaches a volume to a WorkSpace Instance.
disassociate_volumeupdateregion, WorkspaceInstanceId, VolumeIdDetaches a volume from a WorkSpace Instance.
delete_volumedeleteregionDeletes a specified volume.

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)

INSERT examples

Creates a new volume for WorkSpace Instances.

INSERT INTO aws.workspaces_instances.volumes (
AvailabilityZone,
ClientToken,
Encrypted,
Iops,
KmsKeyId,
SizeInGB,
SnapshotId,
TagSpecifications,
Throughput,
VolumeType,
region
)
SELECT
'{{ AvailabilityZone }}' /* required */,
'{{ ClientToken }}',
{{ Encrypted }},
{{ Iops }},
'{{ KmsKeyId }}',
{{ SizeInGB }},
'{{ SnapshotId }}',
'{{ TagSpecifications }}',
{{ Throughput }},
'{{ VolumeType }}',
'{{ region }}'
RETURNING
volume_id
;

UPDATE examples

Attaches a volume to a WorkSpace Instance.

UPDATE aws.workspaces_instances.volumes
SET
WorkspaceInstanceId = '{{ WorkspaceInstanceId }}',
VolumeId = '{{ VolumeId }}',
Device = '{{ Device }}'
WHERE
region = '{{ region }}' --required
AND WorkspaceInstanceId = '{{ WorkspaceInstanceId }}' --required
AND VolumeId = '{{ VolumeId }}' --required
AND Device = '{{ Device }}' --required;

DELETE examples

Deletes a specified volume.

DELETE FROM aws.workspaces_instances.volumes
WHERE region = '{{ region }}' --required
;