reserved_node_exchange_configuration_options

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

Overview

Name	reserved_node_exchange_configuration_options
Type	Resource
Id	aws.redshift.reserved_node_exchange_configuration_options

Fields

The following fields are returned by SELECT queries:

get_reserved_node_exchange_configuration_options

Name	Datatype	Description
source_reserved_node	string	Describes a reserved node. You can call the DescribeReservedNodeOfferings API to obtain the available reserved node offerings.
target_reserved_node_count	integer	The target reserved-node count.
target_reserved_node_offering	string	Describes a reserved node offering.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_reserved_node_exchange_configuration_options	select	ActionType, region	ClusterIdentifier, SnapshotIdentifier, MaxRecords, Marker	Gets the configuration options for the reserved-node exchange. These options include information about the source reserved node and target reserved node offering. Details include the node type, the price, the node count, and the offering type.

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
ActionType	string	The action type of the reserved-node configuration. The action type can be an exchange initiated from either a snapshot or a resize.
region	string	AWS region (default: us-east-1)
ClusterIdentifier	string	The identifier for the cluster that is the source for a reserved-node exchange.
Marker	string	An optional pagination token provided by a previous GetReservedNodeExchangeConfigurationOptions 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.
SnapshotIdentifier	string	The identifier for the snapshot that is the source for the reserved-node exchange.

SELECT examples

get_reserved_node_exchange_configuration_options

Gets the configuration options for the reserved-node exchange. These options include information about the source reserved node and target reserved node offering. Details include the node type, the price, the node count, and the offering type.

SELECT
source_reserved_node,
target_reserved_node_count,
target_reserved_node_offering
FROM aws.redshift.reserved_node_exchange_configuration_options
WHERE ActionType = '{{ ActionType }}' -- required
AND region = '{{ region }}' -- required
AND ClusterIdentifier = '{{ ClusterIdentifier }}'
AND SnapshotIdentifier = '{{ SnapshotIdentifier }}'
AND MaxRecords = '{{ MaxRecords }}'
AND Marker = '{{ Marker }}'
;