| Column Name | Column Data Type |
|---|
action_type Required Input Column
The action type of the reserved-node configuration. The action type can be an exchange initiated from either a snapshot or a resize. | VARCHAR |
cluster_identifier Input Column
The identifier for the cluster that is the source for a reserved-node exchange. | VARCHAR |
snapshot_identifier Input Column
The identifier for the snapshot that is the source for the reserved-node exchange. | VARCHAR |
_aws_profile Input Column
The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role. | STRUCT(
"type" VARCHAR,
"name" VARCHAR,
"account_id" VARCHAR,
"via_profile_name" VARCHAR,
"assumed_role_arn" VARCHAR,
"organization" STRUCT(
"account_name" VARCHAR,
"id" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[],
"master_account" STRUCT(
"id" VARCHAR,
"email" VARCHAR
),
"parents" STRUCT(
"type" VARCHAR,
"id" VARCHAR,
"name" VARCHAR,
"tags" STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[]
)[]
)
) |
Show child fields- _aws_profile.account_id
The AWS account id - _aws_profile.assumed_role_arn
The ARN of the assumed role - _aws_profile.name
The unique name of the profile. - _aws_profile.organization
Information about this profile's membership in the AWS organization. Show child fields- _aws_profile.organization.account_name
The name of account speciifed by the organization - _aws_profile.organization.id
The organization id - _aws_profile.organization.master_account
Show child fields- _aws_profile.organization.master_account.email
The organization master account email address - _aws_profile.organization.master_account.id
The organization master account id
- _aws_profile.organization.parents[]
Show child fields- _aws_profile.organization.parents[].id
The id of the parent - _aws_profile.organization.parents[].name
The name of the parent - _aws_profile.organization.parents[].tags[]
Show child fields- _aws_profile.organization.parents[].tags[].key
- _aws_profile.organization.parents[].tags[].value
- _aws_profile.organization.parents[].type
The type of parent can be an organization unit or a root
- _aws_profile.organization.tags[]
Show child fields- _aws_profile.organization.tags[].key
- _aws_profile.organization.tags[].value
- _aws_profile.type
The type of profile, either 'credentials' or 'assumed_role' - _aws_profile.via_profile_name
This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.
|
_aws_region Input Column
The AWS region to use. | VARCHAR |
source_reserved_node
Describes a reserved node. You can call the DescribeReservedNodeOfferings API to obtain the available reserved node offerings. | STRUCT(
"reserved_node_id" VARCHAR,
"reserved_node_offering_id" VARCHAR,
"node_type" VARCHAR,
"start_time" TIMESTAMP_S,
"duration" BIGINT,
"fixed_price" DOUBLE,
"usage_price" DOUBLE,
"currency_code" VARCHAR,
"node_count" BIGINT,
"state" VARCHAR,
"offering_type" VARCHAR,
"recurring_charges" STRUCT(
"recurring_charge_amount" DOUBLE,
"recurring_charge_frequency" VARCHAR
)[],
"reserved_node_offering_type" VARCHAR
) |
Show child fields- source_reserved_node.currency_code
The currency code for the reserved cluster. - source_reserved_node.duration
The duration of the node reservation in seconds. - source_reserved_node.fixed_price
The fixed cost Amazon Redshift charges you for this reserved node. - source_reserved_node.node_count
The number of reserved compute nodes. - source_reserved_node.node_type
The node type of the reserved node. - source_reserved_node.offering_type
The anticipated utilization of the reserved node, as defined in the reserved node offering. - source_reserved_node.recurring_charges[]
Show child fields- source_reserved_node.recurring_charges[].recurring_charge_amount
The amount charged per the period of time specified by the recurring charge frequency. - source_reserved_node.recurring_charges[].recurring_charge_frequency
The frequency at which the recurring charge amount is applied.
- source_reserved_node.reserved_node_id
The unique identifier for the reservation. - source_reserved_node.reserved_node_offering_id
The identifier for the reserved node offering. - source_reserved_node.reserved_node_offering_type
- source_reserved_node.start_time
The time the reservation started. You purchase a reserved node offering for a duration. This is the start time of that duration. - source_reserved_node.state
The state of the reserved compute node. Possible Values: -
pending-payment-This reserved node has recently been purchased, and the sale has been approved, but payment has not yet been confirmed. -
active-This reserved node is owned by the caller and is available for use. -
payment-failed-Payment failed for the purchase attempt. -
retired-The reserved node is no longer available. -
exchanging-The owner is exchanging the reserved node for another reserved node. - source_reserved_node.usage_price
The hourly rate Amazon Redshift charges you for this reserved node.
|
target_reserved_node_count
The target reserved-node count. | BIGINT |
target_reserved_node_offering
Describes a reserved node offering. | STRUCT(
"reserved_node_offering_id" VARCHAR,
"node_type" VARCHAR,
"duration" BIGINT,
"fixed_price" DOUBLE,
"usage_price" DOUBLE,
"currency_code" VARCHAR,
"offering_type" VARCHAR,
"recurring_charges" STRUCT(
"recurring_charge_amount" DOUBLE,
"recurring_charge_frequency" VARCHAR
)[],
"reserved_node_offering_type" VARCHAR
) |
Show child fields- target_reserved_node_offering.currency_code
The currency code for the compute nodes offering. - target_reserved_node_offering.duration
The duration, in seconds, for which the offering will reserve the node. - target_reserved_node_offering.fixed_price
The upfront fixed charge you will pay to purchase the specific reserved node offering. - target_reserved_node_offering.node_type
The node type offered by the reserved node offering. - target_reserved_node_offering.offering_type
The anticipated utilization of the reserved node, as defined in the reserved node offering. - target_reserved_node_offering.recurring_charges[]
Show child fields- target_reserved_node_offering.recurring_charges[].recurring_charge_amount
The amount charged per the period of time specified by the recurring charge frequency. - target_reserved_node_offering.recurring_charges[].recurring_charge_frequency
The frequency at which the recurring charge amount is applied.
- target_reserved_node_offering.reserved_node_offering_id
The offering identifier. - target_reserved_node_offering.reserved_node_offering_type
- target_reserved_node_offering.usage_price
The rate you are charged for each hour the cluster that is using the offering is running.
|