resizes

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

Overview

Name	resizes
Type	Resource
Id	aws.redshift.resizes

Fields

The following fields are returned by SELECT queries:

describe_resize

Name	Datatype	Description
avg_resize_rate_in_mega_bytes_per_second	number	The average rate of the resize operation over the last few minutes, measured in megabytes per second. After the resize operation completes, this value shows the average rate of the entire resize operation.
data_transfer_progress_percent	number	The percent of data transferred from source cluster to target cluster.
elapsed_time_in_seconds	integer	The amount of seconds that have elapsed since the resize operation began. After the resize operation completes, this value shows the total actual time, in seconds, for the resize operation.
estimated_time_to_completion_in_seconds	integer	The estimated time remaining, in seconds, until the resize operation is complete. This value is calculated based on the average resize rate and the estimated amount of data remaining to be processed. Once the resize operation is complete, this value will be 0.
import_tables_completed	array	The names of tables that have been completely imported . Valid Values: List of table names.
import_tables_in_progress	array	The names of tables that are being currently imported. Valid Values: List of table names.
import_tables_not_started	array	The names of tables that have not been yet imported. Valid Values: List of table names
message	string	An optional string to provide additional details about the resize action.
progress_in_mega_bytes	integer	While the resize operation is in progress, this value shows the current amount of data, in megabytes, that has been processed so far. When the resize operation is complete, this value shows the total amount of data, in megabytes, on the cluster, which may be more or less than TotalResizeDataInMegaBytes (the estimated total amount of data before resize).
resize_type	string	An enum with possible values of ClassicResize and ElasticResize. These values describe the type of resize operation being performed.
status	string	The status of the resize operation. Valid Values: NONE | IN_PROGRESS | FAILED | SUCCEEDED | CANCELLING
target_cluster_type	string	The cluster type after the resize operation is complete. Valid Values: multi-node | single-node
target_encryption_type	string	The type of encryption for the cluster after the resize is complete. Possible values are KMS and None.
target_node_type	string	The node type that the cluster will have after the resize operation is complete.
target_number_of_nodes	integer	The number of nodes that the cluster will have after the resize operation is complete.
total_resize_data_in_mega_bytes	integer	The estimated total amount of data, in megabytes, on the cluster before the resize operation began.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
describe_resize	select	ClusterIdentifier, region		Returns information about the last resize operation for the specified cluster. If no resize operation has ever been initiated for the specified cluster, a HTTP 404 error is returned. If a resize operation was initiated and completed, the status of the resize remains as SUCCEEDED until the next resize. A resize operation can be requested using ModifyCluster and specifying a different number or type of nodes for the cluster.

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
ClusterIdentifier	string	The unique identifier of a cluster whose resize progress you are requesting. This parameter is case-sensitive. By default, resize operations for all clusters defined for an Amazon Web Services account are returned.
region	string	AWS region (default: us-east-1)

SELECT examples

describe_resize

Returns information about the last resize operation for the specified cluster. If no resize operation has ever been initiated for the specified cluster, a HTTP 404 error is returned. If a resize operation was initiated and completed, the status of the resize remains as SUCCEEDED until the next resize. A resize operation can be requested using ModifyCluster and specifying a different number or type of nodes for the cluster.

SELECT
avg_resize_rate_in_mega_bytes_per_second,
data_transfer_progress_percent,
elapsed_time_in_seconds,
estimated_time_to_completion_in_seconds,
import_tables_completed,
import_tables_in_progress,
import_tables_not_started,
message,
progress_in_mega_bytes,
resize_type,
status,
target_cluster_type,
target_encryption_type,
target_node_type,
target_number_of_nodes,
total_resize_data_in_mega_bytes
FROM aws.redshift.resizes
WHERE ClusterIdentifier = '{{ ClusterIdentifier }}' -- required
AND region = '{{ region }}' -- required
;