reserved_node_exchange_status

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

Overview

Name	reserved_node_exchange_status
Type	Resource
Id	aws.redshift.reserved_node_exchange_status

Fields

The following fields are returned by SELECT queries:

describe_reserved_node_exchange_status

Name	Datatype	Description
request_time	string	A date and time that indicate when the reserved-node exchange was requested.
reserved_node_exchange_request_id	string	The identifier of the reserved-node exchange request.
source_reserved_node_count	integer	The source reserved-node count in the cluster.
source_reserved_node_id	string	The identifier of the source reserved node.
source_reserved_node_type	string	The source reserved-node type, for example ra3.4xlarge.
status	string	The status of the reserved-node exchange request. Statuses include in-progress and requested.
target_reserved_node_count	integer	The count of target reserved nodes in the cluster.
target_reserved_node_offering_id	string	The identifier of the target reserved node offering.
target_reserved_node_type	string	The node type of the target reserved node, for example ra3.4xlarge.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
describe_reserved_node_exchange_status	select	region	ReservedNodeId, ReservedNodeExchangeRequestId, MaxRecords, Marker	Returns exchange status details and associated metadata for a reserved-node exchange. Statuses include such values as in progress and requested.

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.

Name	Datatype	Description
region	string	AWS region (default: us-east-1)
Marker	string	An optional pagination token provided by a previous DescribeReservedNodeExchangeStatus request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by the MaxRecords parameter. You can retrieve the next set of response records by providing the returned marker value in the Marker parameter and retrying the request.
MaxRecords	integer	The maximum number of response records to return in each call. If the number of remaining response records exceeds the specified MaxRecords value, a value is returned in a Marker field of the response. You can retrieve the next set of records by retrying the command with the returned marker value.
ReservedNodeExchangeRequestId	string	The identifier of the reserved-node exchange request.
ReservedNodeId	string	The identifier of the source reserved node in a reserved-node exchange request.

SELECT examples

describe_reserved_node_exchange_status

Returns exchange status details and associated metadata for a reserved-node exchange. Statuses include such values as in progress and requested.

SELECT
request_time,
reserved_node_exchange_request_id,
source_reserved_node_count,
source_reserved_node_id,
source_reserved_node_type,
status,
target_reserved_node_count,
target_reserved_node_offering_id,
target_reserved_node_type
FROM aws.redshift.reserved_node_exchange_status
WHERE region = '{{ region }}' -- required
AND ReservedNodeId = '{{ ReservedNodeId }}'
AND ReservedNodeExchangeRequestId = '{{ ReservedNodeExchangeRequestId }}'
AND MaxRecords = '{{ MaxRecords }}'
AND Marker = '{{ Marker }}'
;