reservation_offerings

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

Overview

Name	reservation_offerings
Type	Resource
Id	aws.redshift_serverless.reservation_offerings

Fields

The following fields are returned by SELECT queries:

get_reservation_offering

Name	Datatype	Description
currency_code	string	The currency code for the offering.
duration	integer	The duration, in seconds, for which the reservation reserves the RPUs.
hourly_charge	number (double)	The rate you are charged for each hour the reservation is active.
offering_id	string	The offering identifier.
offering_type	string	Determines the payment schedule for the reservation. (ALL_UPFRONT, NO_UPFRONT)
upfront_charge	number (double)	The up-front price you are charged for the reservation.

list_reservation_offerings

Name	Datatype	Description
currency_code	string	The currency code for the offering.
duration	integer	The duration, in seconds, for which the reservation reserves the RPUs.
hourly_charge	number (double)	The rate you are charged for each hour the reservation is active.
offering_id	string	The offering identifier.
offering_type	string	Determines the payment schedule for the reservation. (ALL_UPFRONT, NO_UPFRONT)
upfront_charge	number (double)	The up-front price you are charged for the reservation.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_reservation_offering	select	region		Returns the reservation offering. The offering determines the payment schedule for the reservation.
list_reservation_offerings	select	region		Returns the current reservation offerings in your account.

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)

SELECT examples

get_reservation_offering

Returns the reservation offering. The offering determines the payment schedule for the reservation.

SELECT
currency_code,
duration,
hourly_charge,
offering_id,
offering_type,
upfront_charge
FROM aws.redshift_serverless.reservation_offerings
WHERE region = '{{ region }}' -- required
;

list_reservation_offerings

Returns the current reservation offerings in your account.

SELECT
currency_code,
duration,
hourly_charge,
offering_id,
offering_type,
upfront_charge
FROM aws.redshift_serverless.reservation_offerings
WHERE region = '{{ region }}' -- required
;