Amazon Redshift

2018/03/12 - Amazon Redshift - 8 updated api methods

Changes  DescribeClusterSnapshotsMessage with ClusterExists flag returns snapshots of existing clusters. Else both existing and deleted cluster snapshots are returned

CreateClusterSubnetGroup (updated) Link ¶
Changes (response)
{'ClusterSubnetGroup': {'Subnets': {'SubnetAvailabilityZone': {'SupportedPlatforms': [{'Name': 'string'}]}}}}

Creates a new Amazon Redshift subnet group. You must provide a list of one or more subnets in your existing Amazon Virtual Private Cloud (Amazon VPC) when creating Amazon Redshift subnet group.

For information about subnet groups, go to Amazon Redshift Cluster Subnet Groups in the Amazon Redshift Cluster Management Guide .

See also: AWS API Documentation

Request Syntax

client.create_cluster_subnet_group(
    ClusterSubnetGroupName='string',
    Description='string',
    SubnetIds=[
        'string',
    ],
    Tags=[
        {
            'Key': 'string',
            'Value': 'string'
        },
    ]
)
type ClusterSubnetGroupName

string

param ClusterSubnetGroupName

[REQUIRED]

The name for the subnet group. Amazon Redshift stores the value as a lowercase string.

Constraints:

  • Must contain no more than 255 alphanumeric characters or hyphens.

  • Must not be "Default".

  • Must be unique for all subnet groups that are created by your AWS account.

Example: examplesubnetgroup

type Description

string

param Description

[REQUIRED]

A description for the subnet group.

type SubnetIds

list

param SubnetIds

[REQUIRED]

An array of VPC subnet IDs. A maximum of 20 subnets can be modified in a single request.

  • (string) --

type Tags

list

param Tags

A list of tag instances.

  • (dict) --

    A tag consisting of a name/value pair for a resource.

    • Key (string) --

      The key, or name, for the resource tag.

    • Value (string) --

      The value for the resource tag.

rtype

dict

returns

Response Syntax

{
    'ClusterSubnetGroup': {
        'ClusterSubnetGroupName': 'string',
        'Description': 'string',
        'VpcId': 'string',
        'SubnetGroupStatus': 'string',
        'Subnets': [
            {
                'SubnetIdentifier': 'string',
                'SubnetAvailabilityZone': {
                    'Name': 'string',
                    'SupportedPlatforms': [
                        {
                            'Name': 'string'
                        },
                    ]
                },
                'SubnetStatus': 'string'
            },
        ],
        'Tags': [
            {
                'Key': 'string',
                'Value': 'string'
            },
        ]
    }
}

Response Structure

  • (dict) --

    • ClusterSubnetGroup (dict) --

      Describes a subnet group.

      • ClusterSubnetGroupName (string) --

        The name of the cluster subnet group.

      • Description (string) --

        The description of the cluster subnet group.

      • VpcId (string) --

        The VPC ID of the cluster subnet group.

      • SubnetGroupStatus (string) --

        The status of the cluster subnet group. Possible values are Complete , Incomplete and Invalid .

      • Subnets (list) --

        A list of the VPC Subnet elements.

        • (dict) --

          Describes a subnet.

          • SubnetIdentifier (string) --

            The identifier of the subnet.

          • SubnetAvailabilityZone (dict) --

            Describes an availability zone.

            • Name (string) --

              The name of the availability zone.

            • SupportedPlatforms (list) --

              • (dict) --

                A list of supported platforms for orderable clusters.

                • Name (string) --

          • SubnetStatus (string) --

            The status of the subnet.

      • Tags (list) --

        The list of tags for the cluster subnet group.

        • (dict) --

          A tag consisting of a name/value pair for a resource.

          • Key (string) --

            The key, or name, for the resource tag.

          • Value (string) --

            The value for the resource tag.

DescribeClusterSnapshots (updated) Link ¶
Changes (request)
{'ClusterExists': 'boolean'}

Returns one or more snapshot objects, which contain metadata about your cluster snapshots. By default, this operation returns information about all snapshots of all clusters that are owned by you AWS customer account. No information is returned for snapshots owned by inactive AWS customer accounts.

If you specify both tag keys and tag values in the same request, Amazon Redshift returns all snapshots that match any combination of the specified keys and values. For example, if you have owner and environment for tag keys, and admin and test for tag values, all snapshots that have any combination of those values are returned. Only snapshots that you own are returned in the response; shared snapshots are not returned with the tag key and tag value request parameters.

If both tag keys and values are omitted from the request, snapshots are returned regardless of whether they have tag keys or values associated with them.

See also: AWS API Documentation

Request Syntax

client.describe_cluster_snapshots(
    ClusterIdentifier='string',
    SnapshotIdentifier='string',
    SnapshotType='string',
    StartTime=datetime(2015, 1, 1),
    EndTime=datetime(2015, 1, 1),
    MaxRecords=123,
    Marker='string',
    OwnerAccount='string',
    TagKeys=[
        'string',
    ],
    TagValues=[
        'string',
    ],
    ClusterExists=True|False
)
type ClusterIdentifier

string

param ClusterIdentifier

The identifier of the cluster for which information about snapshots is requested.

type SnapshotIdentifier

string

param SnapshotIdentifier

The snapshot identifier of the snapshot about which to return information.

type SnapshotType

string

param SnapshotType

The type of snapshots for which you are requesting information. By default, snapshots of all types are returned.

Valid Values: automated | manual

type StartTime

datetime

param StartTime

A value that requests only snapshots created at or after the specified time. The time value is specified in ISO 8601 format. For more information about ISO 8601, go to the ISO8601 Wikipedia page.

Example: 2012-07-16T18:00:00Z

type EndTime

datetime

param EndTime

A time value that requests only snapshots created at or before the specified time. The time value is specified in ISO 8601 format. For more information about ISO 8601, go to the ISO8601 Wikipedia page.

Example: 2012-07-16T18:00:00Z

type MaxRecords

integer

param MaxRecords

The maximum number of response records to return in each call. If the number of remaining response records exceeds the specified MaxRecords value, a value is returned in a marker field of the response. You can retrieve the next set of records by retrying the command with the returned marker value.

Default: 100

Constraints: minimum 20, maximum 100.

type Marker

string

param Marker

An optional parameter that specifies the starting point to return a set of response records. When the results of a DescribeClusterSnapshots request exceed the value specified in MaxRecords , AWS returns a value in the Marker field of the response. You can retrieve the next set of response records by providing the returned marker value in the Marker parameter and retrying the request.

type OwnerAccount

string

param OwnerAccount

The AWS customer account used to create or copy the snapshot. Use this field to filter the results to snapshots owned by a particular account. To describe snapshots you own, either specify your AWS customer account, or do not specify the parameter.

type TagKeys

list

param TagKeys

A tag key or keys for which you want to return all matching cluster snapshots that are associated with the specified key or keys. For example, suppose that you have snapshots that are tagged with keys called owner and environment . If you specify both of these tag keys in the request, Amazon Redshift returns a response with the snapshots that have either or both of these tag keys associated with them.

  • (string) --

type TagValues

list

param TagValues

A tag value or values for which you want to return all matching cluster snapshots that are associated with the specified tag value or values. For example, suppose that you have snapshots that are tagged with values called admin and test . If you specify both of these tag values in the request, Amazon Redshift returns a response with the snapshots that have either or both of these tag values associated with them.

  • (string) --

type ClusterExists

boolean

param ClusterExists

A value that indicates whether to return snapshots only for an existing cluster. Table-level restore can be performed only using a snapshot of an existing cluster, that is, a cluster that has not been deleted. If ClusterExists is set to true , ClusterIdentifier is required.

rtype

dict

returns

Response Syntax

{
    'Marker': 'string',
    'Snapshots': [
        {
            'SnapshotIdentifier': 'string',
            'ClusterIdentifier': 'string',
            'SnapshotCreateTime': datetime(2015, 1, 1),
            'Status': 'string',
            'Port': 123,
            'AvailabilityZone': 'string',
            'ClusterCreateTime': datetime(2015, 1, 1),
            'MasterUsername': 'string',
            'ClusterVersion': 'string',
            'SnapshotType': 'string',
            'NodeType': 'string',
            'NumberOfNodes': 123,
            'DBName': 'string',
            'VpcId': 'string',
            'Encrypted': True|False,
            'KmsKeyId': 'string',
            'EncryptedWithHSM': True|False,
            'AccountsWithRestoreAccess': [
                {
                    'AccountId': 'string',
                    'AccountAlias': 'string'
                },
            ],
            'OwnerAccount': 'string',
            'TotalBackupSizeInMegaBytes': 123.0,
            'ActualIncrementalBackupSizeInMegaBytes': 123.0,
            'BackupProgressInMegaBytes': 123.0,
            'CurrentBackupRateInMegaBytesPerSecond': 123.0,
            'EstimatedSecondsToCompletion': 123,
            'ElapsedTimeInSeconds': 123,
            'SourceRegion': 'string',
            'Tags': [
                {
                    'Key': 'string',
                    'Value': 'string'
                },
            ],
            'RestorableNodeTypes': [
                'string',
            ],
            'EnhancedVpcRouting': True|False
        },
    ]
}

Response Structure

  • (dict) --

    Contains the output from the DescribeClusterSnapshots action.

    • Marker (string) --

      A value that indicates the starting point for the next set of response records in a subsequent request. If a value is returned in a response, you can retrieve the next set of records by providing this returned marker value in the Marker parameter and retrying the command. If the Marker field is empty, all response records have been retrieved for the request.

    • Snapshots (list) --

      A list of Snapshot instances.

      • (dict) --

        Describes a snapshot.

        • SnapshotIdentifier (string) --

          The snapshot identifier that is provided in the request.

        • ClusterIdentifier (string) --

          The identifier of the cluster for which the snapshot was taken.

        • SnapshotCreateTime (datetime) --

          The time (UTC) when Amazon Redshift began the snapshot. A snapshot contains a copy of the cluster data as of this exact time.

        • Status (string) --

          The snapshot status. The value of the status depends on the API operation used.

          • CreateClusterSnapshot and CopyClusterSnapshot returns status as "creating".

          • DescribeClusterSnapshots returns status as "creating", "available", "final snapshot", or "failed".

          • DeleteClusterSnapshot returns status as "deleted".

        • Port (integer) --

          The port that the cluster is listening on.

        • AvailabilityZone (string) --

          The Availability Zone in which the cluster was created.

        • ClusterCreateTime (datetime) --

          The time (UTC) when the cluster was originally created.

        • MasterUsername (string) --

          The master user name for the cluster.

        • ClusterVersion (string) --

          The version ID of the Amazon Redshift engine that is running on the cluster.

        • SnapshotType (string) --

          The snapshot type. Snapshots created using CreateClusterSnapshot and CopyClusterSnapshot will be of type "manual".

        • NodeType (string) --

          The node type of the nodes in the cluster.

        • NumberOfNodes (integer) --

          The number of nodes in the cluster.

        • DBName (string) --

          The name of the database that was created when the cluster was created.

        • VpcId (string) --

          The VPC identifier of the cluster if the snapshot is from a cluster in a VPC. Otherwise, this field is not in the output.

        • Encrypted (boolean) --

          If true , the data in the snapshot is encrypted at rest.

        • KmsKeyId (string) --

          The AWS Key Management Service (KMS) key ID of the encryption key that was used to encrypt data in the cluster from which the snapshot was taken.

        • EncryptedWithHSM (boolean) --

          A boolean that indicates whether the snapshot data is encrypted using the HSM keys of the source cluster. true indicates that the data is encrypted using HSM keys.

        • AccountsWithRestoreAccess (list) --

          A list of the AWS customer accounts authorized to restore the snapshot. Returns null if no accounts are authorized. Visible only to the snapshot owner.

          • (dict) --

            Describes an AWS customer account authorized to restore a snapshot.

            • AccountId (string) --

              The identifier of an AWS customer account authorized to restore a snapshot.

            • AccountAlias (string) --

              The identifier of an AWS support account authorized to restore a snapshot. For AWS support, the identifier is amazon-redshift-support .

        • OwnerAccount (string) --

          For manual snapshots, the AWS customer account used to create or copy the snapshot. For automatic snapshots, the owner of the cluster. The owner can perform all snapshot actions, such as sharing a manual snapshot.

        • TotalBackupSizeInMegaBytes (float) --

          The size of the complete set of backup data that would be used to restore the cluster.

        • ActualIncrementalBackupSizeInMegaBytes (float) --

          The size of the incremental backup.

        • BackupProgressInMegaBytes (float) --

          The number of megabytes that have been transferred to the snapshot backup.

        • CurrentBackupRateInMegaBytesPerSecond (float) --

          The number of megabytes per second being transferred to the snapshot backup. Returns 0 for a completed backup.

        • EstimatedSecondsToCompletion (integer) --

          The estimate of the time remaining before the snapshot backup will complete. Returns 0 for a completed backup.

        • ElapsedTimeInSeconds (integer) --

          The amount of time an in-progress snapshot backup has been running, or the amount of time it took a completed backup to finish.

        • SourceRegion (string) --

          The source region from which the snapshot was copied.

        • Tags (list) --

          The list of tags for the cluster snapshot.

          • (dict) --

            A tag consisting of a name/value pair for a resource.

            • Key (string) --

              The key, or name, for the resource tag.

            • Value (string) --

              The value for the resource tag.

        • RestorableNodeTypes (list) --

          The list of node types that this cluster snapshot is able to restore into.

          • (string) --

        • EnhancedVpcRouting (boolean) --

          An option that specifies whether to create the cluster with enhanced VPC routing enabled. To create a cluster that uses enhanced VPC routing, the cluster must be in a VPC. For more information, see Enhanced VPC Routing in the Amazon Redshift Cluster Management Guide.

          If this option is true , enhanced VPC routing is enabled.

          Default: false

DescribeClusterSubnetGroups (updated) Link ¶
Changes (response)
{'ClusterSubnetGroups': {'Subnets': {'SubnetAvailabilityZone': {'SupportedPlatforms': [{'Name': 'string'}]}}}}

Returns one or more cluster subnet group objects, which contain metadata about your cluster subnet groups. By default, this operation returns information about all cluster subnet groups that are defined in you AWS account.

If you specify both tag keys and tag values in the same request, Amazon Redshift returns all subnet groups that match any combination of the specified keys and values. For example, if you have owner and environment for tag keys, and admin and test for tag values, all subnet groups that have any combination of those values are returned.

If both tag keys and values are omitted from the request, subnet groups are returned regardless of whether they have tag keys or values associated with them.

See also: AWS API Documentation

Request Syntax

client.describe_cluster_subnet_groups(
    ClusterSubnetGroupName='string',
    MaxRecords=123,
    Marker='string',
    TagKeys=[
        'string',
    ],
    TagValues=[
        'string',
    ]
)
type ClusterSubnetGroupName

string

param ClusterSubnetGroupName

The name of the cluster subnet group for which information is requested.

type MaxRecords

integer

param MaxRecords

The maximum number of response records to return in each call. If the number of remaining response records exceeds the specified MaxRecords value, a value is returned in a marker field of the response. You can retrieve the next set of records by retrying the command with the returned marker value.

Default: 100

Constraints: minimum 20, maximum 100.

type Marker

string

param Marker

An optional parameter that specifies the starting point to return a set of response records. When the results of a DescribeClusterSubnetGroups request exceed the value specified in MaxRecords , AWS returns a value in the Marker field of the response. You can retrieve the next set of response records by providing the returned marker value in the Marker parameter and retrying the request.

type TagKeys

list

param TagKeys

A tag key or keys for which you want to return all matching cluster subnet groups that are associated with the specified key or keys. For example, suppose that you have subnet groups that are tagged with keys called owner and environment . If you specify both of these tag keys in the request, Amazon Redshift returns a response with the subnet groups that have either or both of these tag keys associated with them.

  • (string) --

type TagValues

list

param TagValues

A tag value or values for which you want to return all matching cluster subnet groups that are associated with the specified tag value or values. For example, suppose that you have subnet groups that are tagged with values called admin and test . If you specify both of these tag values in the request, Amazon Redshift returns a response with the subnet groups that have either or both of these tag values associated with them.

  • (string) --

rtype

dict

returns

Response Syntax

{
    'Marker': 'string',
    'ClusterSubnetGroups': [
        {
            'ClusterSubnetGroupName': 'string',
            'Description': 'string',
            'VpcId': 'string',
            'SubnetGroupStatus': 'string',
            'Subnets': [
                {
                    'SubnetIdentifier': 'string',
                    'SubnetAvailabilityZone': {
                        'Name': 'string',
                        'SupportedPlatforms': [
                            {
                                'Name': 'string'
                            },
                        ]
                    },
                    'SubnetStatus': 'string'
                },
            ],
            'Tags': [
                {
                    'Key': 'string',
                    'Value': 'string'
                },
            ]
        },
    ]
}

Response Structure

  • (dict) --

    Contains the output from the DescribeClusterSubnetGroups action.

    • Marker (string) --

      A value that indicates the starting point for the next set of response records in a subsequent request. If a value is returned in a response, you can retrieve the next set of records by providing this returned marker value in the Marker parameter and retrying the command. If the Marker field is empty, all response records have been retrieved for the request.

    • ClusterSubnetGroups (list) --

      A list of ClusterSubnetGroup instances.

      • (dict) --

        Describes a subnet group.

        • ClusterSubnetGroupName (string) --

          The name of the cluster subnet group.

        • Description (string) --

          The description of the cluster subnet group.

        • VpcId (string) --

          The VPC ID of the cluster subnet group.

        • SubnetGroupStatus (string) --

          The status of the cluster subnet group. Possible values are Complete , Incomplete and Invalid .

        • Subnets (list) --

          A list of the VPC Subnet elements.

          • (dict) --

            Describes a subnet.

            • SubnetIdentifier (string) --

              The identifier of the subnet.

            • SubnetAvailabilityZone (dict) --

              Describes an availability zone.

              • Name (string) --

                The name of the availability zone.

              • SupportedPlatforms (list) --

                • (dict) --

                  A list of supported platforms for orderable clusters.

                  • Name (string) --

            • SubnetStatus (string) --

              The status of the subnet.

        • Tags (list) --

          The list of tags for the cluster subnet group.

          • (dict) --

            A tag consisting of a name/value pair for a resource.

            • Key (string) --

              The key, or name, for the resource tag.

            • Value (string) --

              The value for the resource tag.

DescribeOrderableClusterOptions (updated) Link ¶
Changes (response)
{'OrderableClusterOptions': {'AvailabilityZones': {'SupportedPlatforms': [{'Name': 'string'}]}}}

Returns a list of orderable cluster options. Before you create a new cluster you can use this operation to find what options are available, such as the EC2 Availability Zones (AZ) in the specific AWS region that you can specify, and the node types you can request. The node types differ by available storage, memory, CPU and price. With the cost involved you might want to obtain a list of cluster options in the specific region and specify values when creating a cluster. For more information about managing clusters, go to Amazon Redshift Clusters in the Amazon Redshift Cluster Management Guide .

See also: AWS API Documentation

Request Syntax

client.describe_orderable_cluster_options(
    ClusterVersion='string',
    NodeType='string',
    MaxRecords=123,
    Marker='string'
)
type ClusterVersion

string

param ClusterVersion

The version filter value. Specify this parameter to show only the available offerings matching the specified version.

Default: All versions.

Constraints: Must be one of the version returned from DescribeClusterVersions .

type NodeType

string

param NodeType

The node type filter value. Specify this parameter to show only the available offerings matching the specified node type.

type MaxRecords

integer

param MaxRecords

The maximum number of response records to return in each call. If the number of remaining response records exceeds the specified MaxRecords value, a value is returned in a marker field of the response. You can retrieve the next set of records by retrying the command with the returned marker value.

Default: 100

Constraints: minimum 20, maximum 100.

type Marker

string

param Marker

An optional parameter that specifies the starting point to return a set of response records. When the results of a DescribeOrderableClusterOptions request exceed the value specified in MaxRecords , AWS returns a value in the Marker field of the response. You can retrieve the next set of response records by providing the returned marker value in the Marker parameter and retrying the request.

rtype

dict

returns

Response Syntax

{
    'OrderableClusterOptions': [
        {
            'ClusterVersion': 'string',
            'ClusterType': 'string',
            'NodeType': 'string',
            'AvailabilityZones': [
                {
                    'Name': 'string',
                    'SupportedPlatforms': [
                        {
                            'Name': 'string'
                        },
                    ]
                },
            ]
        },
    ],
    'Marker': 'string'
}

Response Structure

  • (dict) --

    Contains the output from the DescribeOrderableClusterOptions action.

    • OrderableClusterOptions (list) --

      An OrderableClusterOption structure containing information about orderable options for the cluster.

      • (dict) --

        Describes an orderable cluster option.

        • ClusterVersion (string) --

          The version of the orderable cluster.

        • ClusterType (string) --

          The cluster type, for example multi-node .

        • NodeType (string) --

          The node type for the orderable cluster.

        • AvailabilityZones (list) --

          A list of availability zones for the orderable cluster.

          • (dict) --

            Describes an availability zone.

            • Name (string) --

              The name of the availability zone.

            • SupportedPlatforms (list) --

              • (dict) --

                A list of supported platforms for orderable clusters.

                • Name (string) --

    • Marker (string) --

      A value that indicates the starting point for the next set of response records in a subsequent request. If a value is returned in a response, you can retrieve the next set of records by providing this returned marker value in the Marker parameter and retrying the command. If the Marker field is empty, all response records have been retrieved for the request.

DescribeReservedNodeOfferings (updated) Link ¶
Changes (response)
{'ReservedNodeOfferings': {'ReservedNodeOfferingType': 'Regular | Upgradable'}}

Returns a list of the available reserved node offerings by Amazon Redshift with their descriptions including the node type, the fixed and recurring costs of reserving the node and duration the node will be reserved for you. These descriptions help you determine which reserve node offering you want to purchase. You then use the unique offering ID in you call to PurchaseReservedNodeOffering to reserve one or more nodes for your Amazon Redshift cluster.

For more information about reserved node offerings, go to Purchasing Reserved Nodes in the Amazon Redshift Cluster Management Guide .

See also: AWS API Documentation

Request Syntax

client.describe_reserved_node_offerings(
    ReservedNodeOfferingId='string',
    MaxRecords=123,
    Marker='string'
)
type ReservedNodeOfferingId

string

param ReservedNodeOfferingId

The unique identifier for the offering.

type MaxRecords

integer

param MaxRecords

The maximum number of response records to return in each call. If the number of remaining response records exceeds the specified MaxRecords value, a value is returned in a marker field of the response. You can retrieve the next set of records by retrying the command with the returned marker value.

Default: 100

Constraints: minimum 20, maximum 100.

type Marker

string

param Marker

An optional parameter that specifies the starting point to return a set of response records. When the results of a DescribeReservedNodeOfferings request exceed the value specified in MaxRecords , AWS returns a value in the Marker field of the response. You can retrieve the next set of response records by providing the returned marker value in the Marker parameter and retrying the request.

rtype

dict

returns

Response Syntax

{
    'Marker': 'string',
    'ReservedNodeOfferings': [
        {
            'ReservedNodeOfferingId': 'string',
            'NodeType': 'string',
            'Duration': 123,
            'FixedPrice': 123.0,
            'UsagePrice': 123.0,
            'CurrencyCode': 'string',
            'OfferingType': 'string',
            'RecurringCharges': [
                {
                    'RecurringChargeAmount': 123.0,
                    'RecurringChargeFrequency': 'string'
                },
            ],
            'ReservedNodeOfferingType': 'Regular'|'Upgradable'
        },
    ]
}

Response Structure

  • (dict) --

    • Marker (string) --

      A value that indicates the starting point for the next set of response records in a subsequent request. If a value is returned in a response, you can retrieve the next set of records by providing this returned marker value in the Marker parameter and retrying the command. If the Marker field is empty, all response records have been retrieved for the request.

    • ReservedNodeOfferings (list) --

      A list of ReservedNodeOffering objects.

      • (dict) --

        Describes a reserved node offering.

        • ReservedNodeOfferingId (string) --

          The offering identifier.

        • NodeType (string) --

          The node type offered by the reserved node offering.

        • Duration (integer) --

          The duration, in seconds, for which the offering will reserve the node.

        • FixedPrice (float) --

          The upfront fixed charge you will pay to purchase the specific reserved node offering.

        • UsagePrice (float) --

          The rate you are charged for each hour the cluster that is using the offering is running.

        • CurrencyCode (string) --

          The currency code for the compute nodes offering.

        • OfferingType (string) --

          The anticipated utilization of the reserved node, as defined in the reserved node offering.

        • RecurringCharges (list) --

          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.

          • (dict) --

            Describes a recurring charge.

            • RecurringChargeAmount (float) --

              The amount charged per the period of time specified by the recurring charge frequency.

            • RecurringChargeFrequency (string) --

              The frequency at which the recurring charge amount is applied.

        • ReservedNodeOfferingType (string) --

DescribeReservedNodes (updated) Link ¶
Changes (response)
{'ReservedNodes': {'ReservedNodeOfferingType': 'Regular | Upgradable'}}

Returns the descriptions of the reserved nodes.

See also: AWS API Documentation

Request Syntax

client.describe_reserved_nodes(
    ReservedNodeId='string',
    MaxRecords=123,
    Marker='string'
)
type ReservedNodeId

string

param ReservedNodeId

Identifier for the node reservation.

type MaxRecords

integer

param MaxRecords

The maximum number of response records to return in each call. If the number of remaining response records exceeds the specified MaxRecords value, a value is returned in a marker field of the response. You can retrieve the next set of records by retrying the command with the returned marker value.

Default: 100

Constraints: minimum 20, maximum 100.

type Marker

string

param Marker

An optional parameter that specifies the starting point to return a set of response records. When the results of a DescribeReservedNodes request exceed the value specified in MaxRecords , AWS returns a value in the Marker field of the response. You can retrieve the next set of response records by providing the returned marker value in the Marker parameter and retrying the request.

rtype

dict

returns

Response Syntax

{
    'Marker': 'string',
    'ReservedNodes': [
        {
            'ReservedNodeId': 'string',
            'ReservedNodeOfferingId': 'string',
            'NodeType': 'string',
            'StartTime': datetime(2015, 1, 1),
            'Duration': 123,
            'FixedPrice': 123.0,
            'UsagePrice': 123.0,
            'CurrencyCode': 'string',
            'NodeCount': 123,
            'State': 'string',
            'OfferingType': 'string',
            'RecurringCharges': [
                {
                    'RecurringChargeAmount': 123.0,
                    'RecurringChargeFrequency': 'string'
                },
            ],
            'ReservedNodeOfferingType': 'Regular'|'Upgradable'
        },
    ]
}

Response Structure

  • (dict) --

    • Marker (string) --

      A value that indicates the starting point for the next set of response records in a subsequent request. If a value is returned in a response, you can retrieve the next set of records by providing this returned marker value in the Marker parameter and retrying the command. If the Marker field is empty, all response records have been retrieved for the request.

    • ReservedNodes (list) --

      The list of ReservedNode objects.

      • (dict) --

        Describes a reserved node. You can call the DescribeReservedNodeOfferings API to obtain the available reserved node offerings.

        • ReservedNodeId (string) --

          The unique identifier for the reservation.

        • ReservedNodeOfferingId (string) --

          The identifier for the reserved node offering.

        • NodeType (string) --

          The node type of the reserved node.

        • StartTime (datetime) --

          The time the reservation started. You purchase a reserved node offering for a duration. This is the start time of that duration.

        • Duration (integer) --

          The duration of the node reservation in seconds.

        • FixedPrice (float) --

          The fixed cost Amazon Redshift charges you for this reserved node.

        • UsagePrice (float) --

          The hourly rate Amazon Redshift charges you for this reserved node.

        • CurrencyCode (string) --

          The currency code for the reserved cluster.

        • NodeCount (integer) --

          The number of reserved compute nodes.

        • State (string) --

          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.

        • OfferingType (string) --

          The anticipated utilization of the reserved node, as defined in the reserved node offering.

        • RecurringCharges (list) --

          The recurring charges for the reserved node.

          • (dict) --

            Describes a recurring charge.

            • RecurringChargeAmount (float) --

              The amount charged per the period of time specified by the recurring charge frequency.

            • RecurringChargeFrequency (string) --

              The frequency at which the recurring charge amount is applied.

        • ReservedNodeOfferingType (string) --

ModifyClusterSubnetGroup (updated) Link ¶
Changes (response)
{'ClusterSubnetGroup': {'Subnets': {'SubnetAvailabilityZone': {'SupportedPlatforms': [{'Name': 'string'}]}}}}

Modifies a cluster subnet group to include the specified list of VPC subnets. The operation replaces the existing list of subnets with the new list of subnets.

See also: AWS API Documentation

Request Syntax

client.modify_cluster_subnet_group(
    ClusterSubnetGroupName='string',
    Description='string',
    SubnetIds=[
        'string',
    ]
)
type ClusterSubnetGroupName

string

param ClusterSubnetGroupName

[REQUIRED]

The name of the subnet group to be modified.

type Description

string

param Description

A text description of the subnet group to be modified.

type SubnetIds

list

param SubnetIds

[REQUIRED]

An array of VPC subnet IDs. A maximum of 20 subnets can be modified in a single request.

  • (string) --

rtype

dict

returns

Response Syntax

{
    'ClusterSubnetGroup': {
        'ClusterSubnetGroupName': 'string',
        'Description': 'string',
        'VpcId': 'string',
        'SubnetGroupStatus': 'string',
        'Subnets': [
            {
                'SubnetIdentifier': 'string',
                'SubnetAvailabilityZone': {
                    'Name': 'string',
                    'SupportedPlatforms': [
                        {
                            'Name': 'string'
                        },
                    ]
                },
                'SubnetStatus': 'string'
            },
        ],
        'Tags': [
            {
                'Key': 'string',
                'Value': 'string'
            },
        ]
    }
}

Response Structure

  • (dict) --

    • ClusterSubnetGroup (dict) --

      Describes a subnet group.

      • ClusterSubnetGroupName (string) --

        The name of the cluster subnet group.

      • Description (string) --

        The description of the cluster subnet group.

      • VpcId (string) --

        The VPC ID of the cluster subnet group.

      • SubnetGroupStatus (string) --

        The status of the cluster subnet group. Possible values are Complete , Incomplete and Invalid .

      • Subnets (list) --

        A list of the VPC Subnet elements.

        • (dict) --

          Describes a subnet.

          • SubnetIdentifier (string) --

            The identifier of the subnet.

          • SubnetAvailabilityZone (dict) --

            Describes an availability zone.

            • Name (string) --

              The name of the availability zone.

            • SupportedPlatforms (list) --

              • (dict) --

                A list of supported platforms for orderable clusters.

                • Name (string) --

          • SubnetStatus (string) --

            The status of the subnet.

      • Tags (list) --

        The list of tags for the cluster subnet group.

        • (dict) --

          A tag consisting of a name/value pair for a resource.

          • Key (string) --

            The key, or name, for the resource tag.

          • Value (string) --

            The value for the resource tag.

PurchaseReservedNodeOffering (updated) Link ¶
Changes (response)
{'ReservedNode': {'ReservedNodeOfferingType': 'Regular | Upgradable'}}

Allows you to purchase reserved nodes. Amazon Redshift offers a predefined set of reserved node offerings. You can purchase one or more of the offerings. You can call the DescribeReservedNodeOfferings API to obtain the available reserved node offerings. You can call this API by providing a specific reserved node offering and the number of nodes you want to reserve.

For more information about reserved node offerings, go to Purchasing Reserved Nodes in the Amazon Redshift Cluster Management Guide .

See also: AWS API Documentation

Request Syntax

client.purchase_reserved_node_offering(
    ReservedNodeOfferingId='string',
    NodeCount=123
)
type ReservedNodeOfferingId

string

param ReservedNodeOfferingId

[REQUIRED]

The unique identifier of the reserved node offering you want to purchase.

type NodeCount

integer

param NodeCount

The number of reserved nodes that you want to purchase.

Default: 1

rtype

dict

returns

Response Syntax

{
    'ReservedNode': {
        'ReservedNodeId': 'string',
        'ReservedNodeOfferingId': 'string',
        'NodeType': 'string',
        'StartTime': datetime(2015, 1, 1),
        'Duration': 123,
        'FixedPrice': 123.0,
        'UsagePrice': 123.0,
        'CurrencyCode': 'string',
        'NodeCount': 123,
        'State': 'string',
        'OfferingType': 'string',
        'RecurringCharges': [
            {
                'RecurringChargeAmount': 123.0,
                'RecurringChargeFrequency': 'string'
            },
        ],
        'ReservedNodeOfferingType': 'Regular'|'Upgradable'
    }
}

Response Structure

  • (dict) --

    • ReservedNode (dict) --

      Describes a reserved node. You can call the DescribeReservedNodeOfferings API to obtain the available reserved node offerings.

      • ReservedNodeId (string) --

        The unique identifier for the reservation.

      • ReservedNodeOfferingId (string) --

        The identifier for the reserved node offering.

      • NodeType (string) --

        The node type of the reserved node.

      • StartTime (datetime) --

        The time the reservation started. You purchase a reserved node offering for a duration. This is the start time of that duration.

      • Duration (integer) --

        The duration of the node reservation in seconds.

      • FixedPrice (float) --

        The fixed cost Amazon Redshift charges you for this reserved node.

      • UsagePrice (float) --

        The hourly rate Amazon Redshift charges you for this reserved node.

      • CurrencyCode (string) --

        The currency code for the reserved cluster.

      • NodeCount (integer) --

        The number of reserved compute nodes.

      • State (string) --

        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.

      • OfferingType (string) --

        The anticipated utilization of the reserved node, as defined in the reserved node offering.

      • RecurringCharges (list) --

        The recurring charges for the reserved node.

        • (dict) --

          Describes a recurring charge.

          • RecurringChargeAmount (float) --

            The amount charged per the period of time specified by the recurring charge frequency.

          • RecurringChargeFrequency (string) --

            The frequency at which the recurring charge amount is applied.

      • ReservedNodeOfferingType (string) --