reserved_node_exchange_offerings

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

Overview

Name	reserved_node_exchange_offerings
Type	Resource
Id	aws.redshift.reserved_node_exchange_offerings

Fields

The following fields are returned by SELECT queries:

get_reserved_node_exchange_offerings

Name	Datatype	Description
currency_code	string	The currency code for the compute nodes offering.
duration	integer	The duration, in seconds, for which the offering will reserve the node.
fixed_price	number	The upfront fixed charge you will pay to purchase the specific reserved node offering.
node_type	string	The node type offered by the reserved node offering.
offering_type	string	The anticipated utilization of the reserved node, as defined in the reserved node offering.
recurring_charges	string	The charge to your account regardless of whether you are creating any clusters using the node offering. Recurring charges are only in effect for heavy-utilization reserved nodes.
reserved_node_offering_id	string	The offering identifier.
reserved_node_offering_type	string
usage_price	number	The rate you are charged for each hour the cluster that is using the offering is running.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_reserved_node_exchange_offerings	select	ReservedNodeId, region	MaxRecords, Marker	Returns an array of DC2 ReservedNodeOfferings that matches the payment type, term, and usage price of the given DC1 reserved node.

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
ReservedNodeId	string	A string representing the node identifier for the DC1 Reserved Node to be exchanged.
region	string	AWS region (default: us-east-1)
Marker	string	A value that indicates the starting point for the next set of ReservedNodeOfferings.
MaxRecords	integer	An integer setting the maximum number of ReservedNodeOfferings to retrieve.

SELECT examples

get_reserved_node_exchange_offerings

Returns an array of DC2 ReservedNodeOfferings that matches the payment type, term, and usage price of the given DC1 reserved node.

SELECT
currency_code,
duration,
fixed_price,
node_type,
offering_type,
recurring_charges,
reserved_node_offering_id,
reserved_node_offering_type,
usage_price
FROM aws.redshift.reserved_node_exchange_offerings
WHERE ReservedNodeId = '{{ ReservedNodeId }}' -- required
AND region = '{{ region }}' -- required
AND MaxRecords = '{{ MaxRecords }}'
AND Marker = '{{ Marker }}'
;