Skip to content
AWS for Query.Farm

aws.redshift.describe_resize

Example SQL Queries

SELECT * FROM
aws.redshift.describe_resize
WHERE
"cluster_identifier" = 'VALUE';

Description

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.

Table Definition

Column NameColumn Data Type
cluster_identifier Required Input Column

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.

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
avg_resize_rate_in_mega_bytes_per_second

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.

DOUBLE
data_transfer_progress_percent

The percent of data transferred from source cluster to target cluster.

DOUBLE
elapsed_time_in_seconds

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.

BIGINT
estimated_time_to_completion_in_seconds

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.

BIGINT
import_tables_completed

The names of tables that have been completely imported .

Valid Values: List of table names.

VARCHAR[]
Show child fields
import_tables_completed[]
import_tables_in_progress

The names of tables that are being currently imported.

Valid Values: List of table names.

VARCHAR[]
Show child fields
import_tables_in_progress[]
import_tables_not_started

The names of tables that have not been yet imported.

Valid Values: List of table names

VARCHAR[]
Show child fields
import_tables_not_started[]
message

An optional string to provide additional details about the resize action.

VARCHAR
progress_in_mega_bytes

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).

BIGINT
resize_type

An enum with possible values of ClassicResize and ElasticResize. These values describe the type of resize operation being performed. 

VARCHAR
status

The status of the resize operation.

Valid Values: NONE | IN_PROGRESS | FAILED | SUCCEEDED | CANCELLING 

VARCHAR
target_cluster_type

The cluster type after the resize operation is complete.

Valid Values: multi-node | single-node 

VARCHAR
target_encryption_type

The type of encryption for the cluster after the resize is complete.

Possible values are KMS and None. 

VARCHAR
target_node_type

The node type that the cluster will have after the resize operation is complete.

VARCHAR
target_number_of_nodes

The number of nodes that the cluster will have after the resize operation is complete.

BIGINT
total_resize_data_in_mega_bytes

The estimated total amount of data, in megabytes, on the cluster before the resize operation began.

BIGINT