Redshift Serverless

2024/10/30 - Redshift Serverless - 5 updated api methods

Changes  Adds and updates API members for the Redshift Serverless AI-driven scaling and optimization feature using the price-performance target setting.

CreateWorkgroup (updated) Link ¶
Changes (request, response)
Request
{'pricePerformanceTarget': {'level': 'integer', 'status': 'ENABLED | DISABLED'}}
Response
{'workgroup': {'pricePerformanceTarget': {'level': 'integer',
                                          'status': 'ENABLED | DISABLED'}}}

Creates an workgroup in Amazon Redshift Serverless.

See also: AWS API Documentation

Request Syntax

client.create_workgroup(
    baseCapacity=123,
    configParameters=[
        {
            'parameterKey': 'string',
            'parameterValue': 'string'
        },
    ],
    enhancedVpcRouting=True|False,
    ipAddressType='string',
    maxCapacity=123,
    namespaceName='string',
    port=123,
    pricePerformanceTarget={
        'level': 123,
        'status': 'ENABLED'|'DISABLED'
    },
    publiclyAccessible=True|False,
    securityGroupIds=[
        'string',
    ],
    subnetIds=[
        'string',
    ],
    tags=[
        {
            'key': 'string',
            'value': 'string'
        },
    ],
    workgroupName='string'
)
type baseCapacity

integer

param baseCapacity

The base data warehouse capacity of the workgroup in Redshift Processing Units (RPUs).

type configParameters

list

param configParameters

An array of parameters to set for advanced control over a database. The options are auto_mv , datestyle , enable_case_sensitive_identifier , enable_user_activity_logging , query_group , search_path , require_ssl , use_fips_ssl , and query monitoring metrics that let you define performance boundaries. For more information about query monitoring rules and available metrics, see Query monitoring metrics for Amazon Redshift Serverless.

  • (dict) --

    An array of key-value pairs to set for advanced control over Amazon Redshift Serverless.

    • parameterKey (string) --

      The key of the parameter. The options are auto_mv , datestyle , enable_case_sensitive_identifier , enable_user_activity_logging , query_group , search_path , require_ssl , use_fips_ssl , and query monitoring metrics that let you define performance boundaries. For more information about query monitoring rules and available metrics, see Query monitoring metrics for Amazon Redshift Serverless.

    • parameterValue (string) --

      The value of the parameter to set.

type enhancedVpcRouting

boolean

param enhancedVpcRouting

The value that specifies whether to turn on enhanced virtual private cloud (VPC) routing, which forces Amazon Redshift Serverless to route traffic through your VPC instead of over the internet.

type ipAddressType

string

param ipAddressType

The IP address type that the workgroup supports. Possible values are ipv4 and dualstack .

type maxCapacity

integer

param maxCapacity

The maximum data-warehouse capacity Amazon Redshift Serverless uses to serve queries. The max capacity is specified in RPUs.

type namespaceName

string

param namespaceName

[REQUIRED]

The name of the namespace to associate with the workgroup.

type port

integer

param port

The custom port to use when connecting to a workgroup. Valid port ranges are 5431-5455 and 8191-8215. The default is 5439.

type pricePerformanceTarget

dict

param pricePerformanceTarget

An object that represents the price performance target settings for the workgroup.

  • level (integer) --

    The target price performance level for the workgroup. Valid values include 1, 25, 50, 75, and 100. These correspond to the price performance levels LOW_COST, ECONOMICAL, BALANCED, RESOURCEFUL, and HIGH_PERFORMANCE.

  • status (string) --

    Whether the price performance target is enabled for the workgroup.

type publiclyAccessible

boolean

param publiclyAccessible

A value that specifies whether the workgroup can be accessed from a public network.

type securityGroupIds

list

param securityGroupIds

An array of security group IDs to associate with the workgroup.

  • (string) --

type subnetIds

list

param subnetIds

An array of VPC subnet IDs to associate with the workgroup.

  • (string) --

type tags

list

param tags

A array of tag instances.

  • (dict) --

    A map of key-value pairs.

    • key (string) -- [REQUIRED]

      The key to use in the tag.

    • value (string) -- [REQUIRED]

      The value of the tag.

type workgroupName

string

param workgroupName

[REQUIRED]

The name of the created workgroup.

rtype

dict

returns

Response Syntax

{
    'workgroup': {
        'baseCapacity': 123,
        'configParameters': [
            {
                'parameterKey': 'string',
                'parameterValue': 'string'
            },
        ],
        'creationDate': datetime(2015, 1, 1),
        'crossAccountVpcs': [
            'string',
        ],
        'customDomainCertificateArn': 'string',
        'customDomainCertificateExpiryTime': datetime(2015, 1, 1),
        'customDomainName': 'string',
        'endpoint': {
            'address': 'string',
            'port': 123,
            'vpcEndpoints': [
                {
                    'networkInterfaces': [
                        {
                            'availabilityZone': 'string',
                            'ipv6Address': 'string',
                            'networkInterfaceId': 'string',
                            'privateIpAddress': 'string',
                            'subnetId': 'string'
                        },
                    ],
                    'vpcEndpointId': 'string',
                    'vpcId': 'string'
                },
            ]
        },
        'enhancedVpcRouting': True|False,
        'ipAddressType': 'string',
        'maxCapacity': 123,
        'namespaceName': 'string',
        'patchVersion': 'string',
        'port': 123,
        'pricePerformanceTarget': {
            'level': 123,
            'status': 'ENABLED'|'DISABLED'
        },
        'publiclyAccessible': True|False,
        'securityGroupIds': [
            'string',
        ],
        'status': 'CREATING'|'AVAILABLE'|'MODIFYING'|'DELETING',
        'subnetIds': [
            'string',
        ],
        'workgroupArn': 'string',
        'workgroupId': 'string',
        'workgroupName': 'string',
        'workgroupVersion': 'string'
    }
}

Response Structure

  • (dict) --

    • workgroup (dict) --

      The created workgroup object.

      • baseCapacity (integer) --

        The base data warehouse capacity of the workgroup in Redshift Processing Units (RPUs).

      • configParameters (list) --

        An array of parameters to set for advanced control over a database. The options are auto_mv , datestyle , enable_case_sensitive_identifier , enable_user_activity_logging , query_group , search_path , require_ssl , use_fips_ssl , and query monitoring metrics that let you define performance boundaries. For more information about query monitoring rules and available metrics, see Query monitoring metrics for Amazon Redshift Serverless.

        • (dict) --

          An array of key-value pairs to set for advanced control over Amazon Redshift Serverless.

          • parameterKey (string) --

            The key of the parameter. The options are auto_mv , datestyle , enable_case_sensitive_identifier , enable_user_activity_logging , query_group , search_path , require_ssl , use_fips_ssl , and query monitoring metrics that let you define performance boundaries. For more information about query monitoring rules and available metrics, see Query monitoring metrics for Amazon Redshift Serverless.

          • parameterValue (string) --

            The value of the parameter to set.

      • creationDate (datetime) --

        The creation date of the workgroup.

      • crossAccountVpcs (list) --

        A list of VPCs. Each entry is the unique identifier of a virtual private cloud with access to Amazon Redshift Serverless. If all of the VPCs for the grantee are allowed, it shows an asterisk.

        • (string) --

      • customDomainCertificateArn (string) --

        The custom domain name’s certificate Amazon resource name (ARN).

      • customDomainCertificateExpiryTime (datetime) --

        The expiration time for the certificate.

      • customDomainName (string) --

        The custom domain name associated with the workgroup.

      • endpoint (dict) --

        The endpoint that is created from the workgroup.

        • address (string) --

          The DNS address of the VPC endpoint.

        • port (integer) --

          The port that Amazon Redshift Serverless listens on.

        • vpcEndpoints (list) --

          An array of VpcEndpoint objects.

          • (dict) --

            The connection endpoint for connecting to Amazon Redshift Serverless through the proxy.

            • networkInterfaces (list) --

              One or more network interfaces of the endpoint. Also known as an interface endpoint.

              • (dict) --

                Contains information about a network interface in an Amazon Redshift Serverless managed VPC endpoint.

                • availabilityZone (string) --

                  The availability Zone.

                • ipv6Address (string) --

                  The IPv6 address of the network interface within the subnet.

                • networkInterfaceId (string) --

                  The unique identifier of the network interface.

                • privateIpAddress (string) --

                  The IPv4 address of the network interface within the subnet.

                • subnetId (string) --

                  The unique identifier of the subnet.

            • vpcEndpointId (string) --

              The connection endpoint ID for connecting to Amazon Redshift Serverless.

            • vpcId (string) --

              The VPC identifier that the endpoint is associated with.

      • enhancedVpcRouting (boolean) --

        The value that specifies whether to enable enhanced virtual private cloud (VPC) routing, which forces Amazon Redshift Serverless to route traffic through your VPC.

      • ipAddressType (string) --

        The IP address type that the workgroup supports. Possible values are ipv4 and dualstack .

      • maxCapacity (integer) --

        The maximum data-warehouse capacity Amazon Redshift Serverless uses to serve queries. The max capacity is specified in RPUs.

      • namespaceName (string) --

        The namespace the workgroup is associated with.

      • patchVersion (string) --

        The patch version of your Amazon Redshift Serverless workgroup. For more information about patch versions, see Cluster versions for Amazon Redshift.

      • port (integer) --

        The custom port to use when connecting to a workgroup. Valid port ranges are 5431-5455 and 8191-8215. The default is 5439.

      • pricePerformanceTarget (dict) --

        An object that represents the price performance target settings for the workgroup.

        • level (integer) --

          The target price performance level for the workgroup. Valid values include 1, 25, 50, 75, and 100. These correspond to the price performance levels LOW_COST, ECONOMICAL, BALANCED, RESOURCEFUL, and HIGH_PERFORMANCE.

        • status (string) --

          Whether the price performance target is enabled for the workgroup.

      • publiclyAccessible (boolean) --

        A value that specifies whether the workgroup can be accessible from a public network.

      • securityGroupIds (list) --

        An array of security group IDs to associate with the workgroup.

        • (string) --

      • status (string) --

        The status of the workgroup.

      • subnetIds (list) --

        An array of subnet IDs the workgroup is associated with.

        • (string) --

      • workgroupArn (string) --

        The Amazon Resource Name (ARN) that links to the workgroup.

      • workgroupId (string) --

        The unique identifier of the workgroup.

      • workgroupName (string) --

        The name of the workgroup.

      • workgroupVersion (string) --

        The Amazon Redshift Serverless version of your workgroup. For more information about Amazon Redshift Serverless versions, see Cluster versions for Amazon Redshift.

DeleteWorkgroup (updated) Link ¶
Changes (response)
{'workgroup': {'pricePerformanceTarget': {'level': 'integer',
                                          'status': 'ENABLED | DISABLED'}}}

Deletes a workgroup.

See also: AWS API Documentation

Request Syntax

client.delete_workgroup(
    workgroupName='string'
)
type workgroupName

string

param workgroupName

[REQUIRED]

The name of the workgroup to be deleted.

rtype

dict

returns

Response Syntax

{
    'workgroup': {
        'baseCapacity': 123,
        'configParameters': [
            {
                'parameterKey': 'string',
                'parameterValue': 'string'
            },
        ],
        'creationDate': datetime(2015, 1, 1),
        'crossAccountVpcs': [
            'string',
        ],
        'customDomainCertificateArn': 'string',
        'customDomainCertificateExpiryTime': datetime(2015, 1, 1),
        'customDomainName': 'string',
        'endpoint': {
            'address': 'string',
            'port': 123,
            'vpcEndpoints': [
                {
                    'networkInterfaces': [
                        {
                            'availabilityZone': 'string',
                            'ipv6Address': 'string',
                            'networkInterfaceId': 'string',
                            'privateIpAddress': 'string',
                            'subnetId': 'string'
                        },
                    ],
                    'vpcEndpointId': 'string',
                    'vpcId': 'string'
                },
            ]
        },
        'enhancedVpcRouting': True|False,
        'ipAddressType': 'string',
        'maxCapacity': 123,
        'namespaceName': 'string',
        'patchVersion': 'string',
        'port': 123,
        'pricePerformanceTarget': {
            'level': 123,
            'status': 'ENABLED'|'DISABLED'
        },
        'publiclyAccessible': True|False,
        'securityGroupIds': [
            'string',
        ],
        'status': 'CREATING'|'AVAILABLE'|'MODIFYING'|'DELETING',
        'subnetIds': [
            'string',
        ],
        'workgroupArn': 'string',
        'workgroupId': 'string',
        'workgroupName': 'string',
        'workgroupVersion': 'string'
    }
}

Response Structure

  • (dict) --

    • workgroup (dict) --

      The deleted workgroup object.

      • baseCapacity (integer) --

        The base data warehouse capacity of the workgroup in Redshift Processing Units (RPUs).

      • configParameters (list) --

        An array of parameters to set for advanced control over a database. The options are auto_mv , datestyle , enable_case_sensitive_identifier , enable_user_activity_logging , query_group , search_path , require_ssl , use_fips_ssl , and query monitoring metrics that let you define performance boundaries. For more information about query monitoring rules and available metrics, see Query monitoring metrics for Amazon Redshift Serverless.

        • (dict) --

          An array of key-value pairs to set for advanced control over Amazon Redshift Serverless.

          • parameterKey (string) --

            The key of the parameter. The options are auto_mv , datestyle , enable_case_sensitive_identifier , enable_user_activity_logging , query_group , search_path , require_ssl , use_fips_ssl , and query monitoring metrics that let you define performance boundaries. For more information about query monitoring rules and available metrics, see Query monitoring metrics for Amazon Redshift Serverless.

          • parameterValue (string) --

            The value of the parameter to set.

      • creationDate (datetime) --

        The creation date of the workgroup.

      • crossAccountVpcs (list) --

        A list of VPCs. Each entry is the unique identifier of a virtual private cloud with access to Amazon Redshift Serverless. If all of the VPCs for the grantee are allowed, it shows an asterisk.

        • (string) --

      • customDomainCertificateArn (string) --

        The custom domain name’s certificate Amazon resource name (ARN).

      • customDomainCertificateExpiryTime (datetime) --

        The expiration time for the certificate.

      • customDomainName (string) --

        The custom domain name associated with the workgroup.

      • endpoint (dict) --

        The endpoint that is created from the workgroup.

        • address (string) --

          The DNS address of the VPC endpoint.

        • port (integer) --

          The port that Amazon Redshift Serverless listens on.

        • vpcEndpoints (list) --

          An array of VpcEndpoint objects.

          • (dict) --

            The connection endpoint for connecting to Amazon Redshift Serverless through the proxy.

            • networkInterfaces (list) --

              One or more network interfaces of the endpoint. Also known as an interface endpoint.

              • (dict) --

                Contains information about a network interface in an Amazon Redshift Serverless managed VPC endpoint.

                • availabilityZone (string) --

                  The availability Zone.

                • ipv6Address (string) --

                  The IPv6 address of the network interface within the subnet.

                • networkInterfaceId (string) --

                  The unique identifier of the network interface.

                • privateIpAddress (string) --

                  The IPv4 address of the network interface within the subnet.

                • subnetId (string) --

                  The unique identifier of the subnet.

            • vpcEndpointId (string) --

              The connection endpoint ID for connecting to Amazon Redshift Serverless.

            • vpcId (string) --

              The VPC identifier that the endpoint is associated with.

      • enhancedVpcRouting (boolean) --

        The value that specifies whether to enable enhanced virtual private cloud (VPC) routing, which forces Amazon Redshift Serverless to route traffic through your VPC.

      • ipAddressType (string) --

        The IP address type that the workgroup supports. Possible values are ipv4 and dualstack .

      • maxCapacity (integer) --

        The maximum data-warehouse capacity Amazon Redshift Serverless uses to serve queries. The max capacity is specified in RPUs.

      • namespaceName (string) --

        The namespace the workgroup is associated with.

      • patchVersion (string) --

        The patch version of your Amazon Redshift Serverless workgroup. For more information about patch versions, see Cluster versions for Amazon Redshift.

      • port (integer) --

        The custom port to use when connecting to a workgroup. Valid port ranges are 5431-5455 and 8191-8215. The default is 5439.

      • pricePerformanceTarget (dict) --

        An object that represents the price performance target settings for the workgroup.

        • level (integer) --

          The target price performance level for the workgroup. Valid values include 1, 25, 50, 75, and 100. These correspond to the price performance levels LOW_COST, ECONOMICAL, BALANCED, RESOURCEFUL, and HIGH_PERFORMANCE.

        • status (string) --

          Whether the price performance target is enabled for the workgroup.

      • publiclyAccessible (boolean) --

        A value that specifies whether the workgroup can be accessible from a public network.

      • securityGroupIds (list) --

        An array of security group IDs to associate with the workgroup.

        • (string) --

      • status (string) --

        The status of the workgroup.

      • subnetIds (list) --

        An array of subnet IDs the workgroup is associated with.

        • (string) --

      • workgroupArn (string) --

        The Amazon Resource Name (ARN) that links to the workgroup.

      • workgroupId (string) --

        The unique identifier of the workgroup.

      • workgroupName (string) --

        The name of the workgroup.

      • workgroupVersion (string) --

        The Amazon Redshift Serverless version of your workgroup. For more information about Amazon Redshift Serverless versions, see Cluster versions for Amazon Redshift.

GetWorkgroup (updated) Link ¶
Changes (response)
{'workgroup': {'pricePerformanceTarget': {'level': 'integer',
                                          'status': 'ENABLED | DISABLED'}}}

Returns information about a specific workgroup.

See also: AWS API Documentation

Request Syntax

client.get_workgroup(
    workgroupName='string'
)
type workgroupName

string

param workgroupName

[REQUIRED]

The name of the workgroup to return information for.

rtype

dict

returns

Response Syntax

{
    'workgroup': {
        'baseCapacity': 123,
        'configParameters': [
            {
                'parameterKey': 'string',
                'parameterValue': 'string'
            },
        ],
        'creationDate': datetime(2015, 1, 1),
        'crossAccountVpcs': [
            'string',
        ],
        'customDomainCertificateArn': 'string',
        'customDomainCertificateExpiryTime': datetime(2015, 1, 1),
        'customDomainName': 'string',
        'endpoint': {
            'address': 'string',
            'port': 123,
            'vpcEndpoints': [
                {
                    'networkInterfaces': [
                        {
                            'availabilityZone': 'string',
                            'ipv6Address': 'string',
                            'networkInterfaceId': 'string',
                            'privateIpAddress': 'string',
                            'subnetId': 'string'
                        },
                    ],
                    'vpcEndpointId': 'string',
                    'vpcId': 'string'
                },
            ]
        },
        'enhancedVpcRouting': True|False,
        'ipAddressType': 'string',
        'maxCapacity': 123,
        'namespaceName': 'string',
        'patchVersion': 'string',
        'port': 123,
        'pricePerformanceTarget': {
            'level': 123,
            'status': 'ENABLED'|'DISABLED'
        },
        'publiclyAccessible': True|False,
        'securityGroupIds': [
            'string',
        ],
        'status': 'CREATING'|'AVAILABLE'|'MODIFYING'|'DELETING',
        'subnetIds': [
            'string',
        ],
        'workgroupArn': 'string',
        'workgroupId': 'string',
        'workgroupName': 'string',
        'workgroupVersion': 'string'
    }
}

Response Structure

  • (dict) --

    • workgroup (dict) --

      The returned workgroup object.

      • baseCapacity (integer) --

        The base data warehouse capacity of the workgroup in Redshift Processing Units (RPUs).

      • configParameters (list) --

        An array of parameters to set for advanced control over a database. The options are auto_mv , datestyle , enable_case_sensitive_identifier , enable_user_activity_logging , query_group , search_path , require_ssl , use_fips_ssl , and query monitoring metrics that let you define performance boundaries. For more information about query monitoring rules and available metrics, see Query monitoring metrics for Amazon Redshift Serverless.

        • (dict) --

          An array of key-value pairs to set for advanced control over Amazon Redshift Serverless.

          • parameterKey (string) --

            The key of the parameter. The options are auto_mv , datestyle , enable_case_sensitive_identifier , enable_user_activity_logging , query_group , search_path , require_ssl , use_fips_ssl , and query monitoring metrics that let you define performance boundaries. For more information about query monitoring rules and available metrics, see Query monitoring metrics for Amazon Redshift Serverless.

          • parameterValue (string) --

            The value of the parameter to set.

      • creationDate (datetime) --

        The creation date of the workgroup.

      • crossAccountVpcs (list) --

        A list of VPCs. Each entry is the unique identifier of a virtual private cloud with access to Amazon Redshift Serverless. If all of the VPCs for the grantee are allowed, it shows an asterisk.

        • (string) --

      • customDomainCertificateArn (string) --

        The custom domain name’s certificate Amazon resource name (ARN).

      • customDomainCertificateExpiryTime (datetime) --

        The expiration time for the certificate.

      • customDomainName (string) --

        The custom domain name associated with the workgroup.

      • endpoint (dict) --

        The endpoint that is created from the workgroup.

        • address (string) --

          The DNS address of the VPC endpoint.

        • port (integer) --

          The port that Amazon Redshift Serverless listens on.

        • vpcEndpoints (list) --

          An array of VpcEndpoint objects.

          • (dict) --

            The connection endpoint for connecting to Amazon Redshift Serverless through the proxy.

            • networkInterfaces (list) --

              One or more network interfaces of the endpoint. Also known as an interface endpoint.

              • (dict) --

                Contains information about a network interface in an Amazon Redshift Serverless managed VPC endpoint.

                • availabilityZone (string) --

                  The availability Zone.

                • ipv6Address (string) --

                  The IPv6 address of the network interface within the subnet.

                • networkInterfaceId (string) --

                  The unique identifier of the network interface.

                • privateIpAddress (string) --

                  The IPv4 address of the network interface within the subnet.

                • subnetId (string) --

                  The unique identifier of the subnet.

            • vpcEndpointId (string) --

              The connection endpoint ID for connecting to Amazon Redshift Serverless.

            • vpcId (string) --

              The VPC identifier that the endpoint is associated with.

      • enhancedVpcRouting (boolean) --

        The value that specifies whether to enable enhanced virtual private cloud (VPC) routing, which forces Amazon Redshift Serverless to route traffic through your VPC.

      • ipAddressType (string) --

        The IP address type that the workgroup supports. Possible values are ipv4 and dualstack .

      • maxCapacity (integer) --

        The maximum data-warehouse capacity Amazon Redshift Serverless uses to serve queries. The max capacity is specified in RPUs.

      • namespaceName (string) --

        The namespace the workgroup is associated with.

      • patchVersion (string) --

        The patch version of your Amazon Redshift Serverless workgroup. For more information about patch versions, see Cluster versions for Amazon Redshift.

      • port (integer) --

        The custom port to use when connecting to a workgroup. Valid port ranges are 5431-5455 and 8191-8215. The default is 5439.

      • pricePerformanceTarget (dict) --

        An object that represents the price performance target settings for the workgroup.

        • level (integer) --

          The target price performance level for the workgroup. Valid values include 1, 25, 50, 75, and 100. These correspond to the price performance levels LOW_COST, ECONOMICAL, BALANCED, RESOURCEFUL, and HIGH_PERFORMANCE.

        • status (string) --

          Whether the price performance target is enabled for the workgroup.

      • publiclyAccessible (boolean) --

        A value that specifies whether the workgroup can be accessible from a public network.

      • securityGroupIds (list) --

        An array of security group IDs to associate with the workgroup.

        • (string) --

      • status (string) --

        The status of the workgroup.

      • subnetIds (list) --

        An array of subnet IDs the workgroup is associated with.

        • (string) --

      • workgroupArn (string) --

        The Amazon Resource Name (ARN) that links to the workgroup.

      • workgroupId (string) --

        The unique identifier of the workgroup.

      • workgroupName (string) --

        The name of the workgroup.

      • workgroupVersion (string) --

        The Amazon Redshift Serverless version of your workgroup. For more information about Amazon Redshift Serverless versions, see Cluster versions for Amazon Redshift.

ListWorkgroups (updated) Link ¶
Changes (response)
{'workgroups': {'pricePerformanceTarget': {'level': 'integer',
                                           'status': 'ENABLED | DISABLED'}}}

Returns information about a list of specified workgroups.

See also: AWS API Documentation

Request Syntax

client.list_workgroups(
    maxResults=123,
    nextToken='string',
    ownerAccount='string'
)
type maxResults

integer

param maxResults

An optional parameter that specifies the maximum number of results to return. You can use nextToken to display the next page of results.

type nextToken

string

param nextToken

If your initial ListWorkgroups operation returns a nextToken , you can include the returned nextToken in following ListNamespaces operations, which returns results in the next page.

type ownerAccount

string

param ownerAccount

The owner Amazon Web Services account for the Amazon Redshift Serverless workgroup.

rtype

dict

returns

Response Syntax

{
    'nextToken': 'string',
    'workgroups': [
        {
            'baseCapacity': 123,
            'configParameters': [
                {
                    'parameterKey': 'string',
                    'parameterValue': 'string'
                },
            ],
            'creationDate': datetime(2015, 1, 1),
            'crossAccountVpcs': [
                'string',
            ],
            'customDomainCertificateArn': 'string',
            'customDomainCertificateExpiryTime': datetime(2015, 1, 1),
            'customDomainName': 'string',
            'endpoint': {
                'address': 'string',
                'port': 123,
                'vpcEndpoints': [
                    {
                        'networkInterfaces': [
                            {
                                'availabilityZone': 'string',
                                'ipv6Address': 'string',
                                'networkInterfaceId': 'string',
                                'privateIpAddress': 'string',
                                'subnetId': 'string'
                            },
                        ],
                        'vpcEndpointId': 'string',
                        'vpcId': 'string'
                    },
                ]
            },
            'enhancedVpcRouting': True|False,
            'ipAddressType': 'string',
            'maxCapacity': 123,
            'namespaceName': 'string',
            'patchVersion': 'string',
            'port': 123,
            'pricePerformanceTarget': {
                'level': 123,
                'status': 'ENABLED'|'DISABLED'
            },
            'publiclyAccessible': True|False,
            'securityGroupIds': [
                'string',
            ],
            'status': 'CREATING'|'AVAILABLE'|'MODIFYING'|'DELETING',
            'subnetIds': [
                'string',
            ],
            'workgroupArn': 'string',
            'workgroupId': 'string',
            'workgroupName': 'string',
            'workgroupVersion': 'string'
        },
    ]
}

Response Structure

  • (dict) --

    • nextToken (string) --

      If nextToken is returned, there are more results available. The value of nextToken is a unique pagination token for each page. To retrieve the next page, make the call again using the returned token.

    • workgroups (list) --

      The returned array of workgroups.

      • (dict) --

        The collection of computing resources from which an endpoint is created.

        • baseCapacity (integer) --

          The base data warehouse capacity of the workgroup in Redshift Processing Units (RPUs).

        • configParameters (list) --

          An array of parameters to set for advanced control over a database. The options are auto_mv , datestyle , enable_case_sensitive_identifier , enable_user_activity_logging , query_group , search_path , require_ssl , use_fips_ssl , and query monitoring metrics that let you define performance boundaries. For more information about query monitoring rules and available metrics, see Query monitoring metrics for Amazon Redshift Serverless.

          • (dict) --

            An array of key-value pairs to set for advanced control over Amazon Redshift Serverless.

            • parameterKey (string) --

              The key of the parameter. The options are auto_mv , datestyle , enable_case_sensitive_identifier , enable_user_activity_logging , query_group , search_path , require_ssl , use_fips_ssl , and query monitoring metrics that let you define performance boundaries. For more information about query monitoring rules and available metrics, see Query monitoring metrics for Amazon Redshift Serverless.

            • parameterValue (string) --

              The value of the parameter to set.

        • creationDate (datetime) --

          The creation date of the workgroup.

        • crossAccountVpcs (list) --

          A list of VPCs. Each entry is the unique identifier of a virtual private cloud with access to Amazon Redshift Serverless. If all of the VPCs for the grantee are allowed, it shows an asterisk.

          • (string) --

        • customDomainCertificateArn (string) --

          The custom domain name’s certificate Amazon resource name (ARN).

        • customDomainCertificateExpiryTime (datetime) --

          The expiration time for the certificate.

        • customDomainName (string) --

          The custom domain name associated with the workgroup.

        • endpoint (dict) --

          The endpoint that is created from the workgroup.

          • address (string) --

            The DNS address of the VPC endpoint.

          • port (integer) --

            The port that Amazon Redshift Serverless listens on.

          • vpcEndpoints (list) --

            An array of VpcEndpoint objects.

            • (dict) --

              The connection endpoint for connecting to Amazon Redshift Serverless through the proxy.

              • networkInterfaces (list) --

                One or more network interfaces of the endpoint. Also known as an interface endpoint.

                • (dict) --

                  Contains information about a network interface in an Amazon Redshift Serverless managed VPC endpoint.

                  • availabilityZone (string) --

                    The availability Zone.

                  • ipv6Address (string) --

                    The IPv6 address of the network interface within the subnet.

                  • networkInterfaceId (string) --

                    The unique identifier of the network interface.

                  • privateIpAddress (string) --

                    The IPv4 address of the network interface within the subnet.

                  • subnetId (string) --

                    The unique identifier of the subnet.

              • vpcEndpointId (string) --

                The connection endpoint ID for connecting to Amazon Redshift Serverless.

              • vpcId (string) --

                The VPC identifier that the endpoint is associated with.

        • enhancedVpcRouting (boolean) --

          The value that specifies whether to enable enhanced virtual private cloud (VPC) routing, which forces Amazon Redshift Serverless to route traffic through your VPC.

        • ipAddressType (string) --

          The IP address type that the workgroup supports. Possible values are ipv4 and dualstack .

        • maxCapacity (integer) --

          The maximum data-warehouse capacity Amazon Redshift Serverless uses to serve queries. The max capacity is specified in RPUs.

        • namespaceName (string) --

          The namespace the workgroup is associated with.

        • patchVersion (string) --

          The patch version of your Amazon Redshift Serverless workgroup. For more information about patch versions, see Cluster versions for Amazon Redshift.

        • port (integer) --

          The custom port to use when connecting to a workgroup. Valid port ranges are 5431-5455 and 8191-8215. The default is 5439.

        • pricePerformanceTarget (dict) --

          An object that represents the price performance target settings for the workgroup.

          • level (integer) --

            The target price performance level for the workgroup. Valid values include 1, 25, 50, 75, and 100. These correspond to the price performance levels LOW_COST, ECONOMICAL, BALANCED, RESOURCEFUL, and HIGH_PERFORMANCE.

          • status (string) --

            Whether the price performance target is enabled for the workgroup.

        • publiclyAccessible (boolean) --

          A value that specifies whether the workgroup can be accessible from a public network.

        • securityGroupIds (list) --

          An array of security group IDs to associate with the workgroup.

          • (string) --

        • status (string) --

          The status of the workgroup.

        • subnetIds (list) --

          An array of subnet IDs the workgroup is associated with.

          • (string) --

        • workgroupArn (string) --

          The Amazon Resource Name (ARN) that links to the workgroup.

        • workgroupId (string) --

          The unique identifier of the workgroup.

        • workgroupName (string) --

          The name of the workgroup.

        • workgroupVersion (string) --

          The Amazon Redshift Serverless version of your workgroup. For more information about Amazon Redshift Serverless versions, see Cluster versions for Amazon Redshift.

UpdateWorkgroup (updated) Link ¶
Changes (request, response)
Request
{'pricePerformanceTarget': {'level': 'integer', 'status': 'ENABLED | DISABLED'}}
Response
{'workgroup': {'pricePerformanceTarget': {'level': 'integer',
                                          'status': 'ENABLED | DISABLED'}}}

Updates a workgroup with the specified configuration settings. You can't update multiple parameters in one request. For example, you can update baseCapacity or port in a single request, but you can't update both in the same request.

See also: AWS API Documentation

Request Syntax

client.update_workgroup(
    baseCapacity=123,
    configParameters=[
        {
            'parameterKey': 'string',
            'parameterValue': 'string'
        },
    ],
    enhancedVpcRouting=True|False,
    ipAddressType='string',
    maxCapacity=123,
    port=123,
    pricePerformanceTarget={
        'level': 123,
        'status': 'ENABLED'|'DISABLED'
    },
    publiclyAccessible=True|False,
    securityGroupIds=[
        'string',
    ],
    subnetIds=[
        'string',
    ],
    workgroupName='string'
)
type baseCapacity

integer

param baseCapacity

The new base data warehouse capacity in Redshift Processing Units (RPUs).

type configParameters

list

param configParameters

An array of parameters to set for advanced control over a database. The options are auto_mv , datestyle , enable_case_sensitive_identifier , enable_user_activity_logging , query_group , search_path , require_ssl , use_fips_ssl , and query monitoring metrics that let you define performance boundaries. For more information about query monitoring rules and available metrics, see Query monitoring metrics for Amazon Redshift Serverless.

  • (dict) --

    An array of key-value pairs to set for advanced control over Amazon Redshift Serverless.

    • parameterKey (string) --

      The key of the parameter. The options are auto_mv , datestyle , enable_case_sensitive_identifier , enable_user_activity_logging , query_group , search_path , require_ssl , use_fips_ssl , and query monitoring metrics that let you define performance boundaries. For more information about query monitoring rules and available metrics, see Query monitoring metrics for Amazon Redshift Serverless.

    • parameterValue (string) --

      The value of the parameter to set.

type enhancedVpcRouting

boolean

param enhancedVpcRouting

The value that specifies whether to turn on enhanced virtual private cloud (VPC) routing, which forces Amazon Redshift Serverless to route traffic through your VPC.

type ipAddressType

string

param ipAddressType

The IP address type that the workgroup supports. Possible values are ipv4 and dualstack .

type maxCapacity

integer

param maxCapacity

The maximum data-warehouse capacity Amazon Redshift Serverless uses to serve queries. The max capacity is specified in RPUs.

type port

integer

param port

The custom port to use when connecting to a workgroup. Valid port ranges are 5431-5455 and 8191-8215. The default is 5439.

type pricePerformanceTarget

dict

param pricePerformanceTarget

An object that represents the price performance target settings for the workgroup.

  • level (integer) --

    The target price performance level for the workgroup. Valid values include 1, 25, 50, 75, and 100. These correspond to the price performance levels LOW_COST, ECONOMICAL, BALANCED, RESOURCEFUL, and HIGH_PERFORMANCE.

  • status (string) --

    Whether the price performance target is enabled for the workgroup.

type publiclyAccessible

boolean

param publiclyAccessible

A value that specifies whether the workgroup can be accessible from a public network.

type securityGroupIds

list

param securityGroupIds

An array of security group IDs to associate with the workgroup.

  • (string) --

type subnetIds

list

param subnetIds

An array of VPC subnet IDs to associate with the workgroup.

  • (string) --

type workgroupName

string

param workgroupName

[REQUIRED]

The name of the workgroup to update. You can't update the name of a workgroup once it is created.

rtype

dict

returns

Response Syntax

{
    'workgroup': {
        'baseCapacity': 123,
        'configParameters': [
            {
                'parameterKey': 'string',
                'parameterValue': 'string'
            },
        ],
        'creationDate': datetime(2015, 1, 1),
        'crossAccountVpcs': [
            'string',
        ],
        'customDomainCertificateArn': 'string',
        'customDomainCertificateExpiryTime': datetime(2015, 1, 1),
        'customDomainName': 'string',
        'endpoint': {
            'address': 'string',
            'port': 123,
            'vpcEndpoints': [
                {
                    'networkInterfaces': [
                        {
                            'availabilityZone': 'string',
                            'ipv6Address': 'string',
                            'networkInterfaceId': 'string',
                            'privateIpAddress': 'string',
                            'subnetId': 'string'
                        },
                    ],
                    'vpcEndpointId': 'string',
                    'vpcId': 'string'
                },
            ]
        },
        'enhancedVpcRouting': True|False,
        'ipAddressType': 'string',
        'maxCapacity': 123,
        'namespaceName': 'string',
        'patchVersion': 'string',
        'port': 123,
        'pricePerformanceTarget': {
            'level': 123,
            'status': 'ENABLED'|'DISABLED'
        },
        'publiclyAccessible': True|False,
        'securityGroupIds': [
            'string',
        ],
        'status': 'CREATING'|'AVAILABLE'|'MODIFYING'|'DELETING',
        'subnetIds': [
            'string',
        ],
        'workgroupArn': 'string',
        'workgroupId': 'string',
        'workgroupName': 'string',
        'workgroupVersion': 'string'
    }
}

Response Structure

  • (dict) --

    • workgroup (dict) --

      The updated workgroup object.

      • baseCapacity (integer) --

        The base data warehouse capacity of the workgroup in Redshift Processing Units (RPUs).

      • configParameters (list) --

        An array of parameters to set for advanced control over a database. The options are auto_mv , datestyle , enable_case_sensitive_identifier , enable_user_activity_logging , query_group , search_path , require_ssl , use_fips_ssl , and query monitoring metrics that let you define performance boundaries. For more information about query monitoring rules and available metrics, see Query monitoring metrics for Amazon Redshift Serverless.

        • (dict) --

          An array of key-value pairs to set for advanced control over Amazon Redshift Serverless.

          • parameterKey (string) --

            The key of the parameter. The options are auto_mv , datestyle , enable_case_sensitive_identifier , enable_user_activity_logging , query_group , search_path , require_ssl , use_fips_ssl , and query monitoring metrics that let you define performance boundaries. For more information about query monitoring rules and available metrics, see Query monitoring metrics for Amazon Redshift Serverless.

          • parameterValue (string) --

            The value of the parameter to set.

      • creationDate (datetime) --

        The creation date of the workgroup.

      • crossAccountVpcs (list) --

        A list of VPCs. Each entry is the unique identifier of a virtual private cloud with access to Amazon Redshift Serverless. If all of the VPCs for the grantee are allowed, it shows an asterisk.

        • (string) --

      • customDomainCertificateArn (string) --

        The custom domain name’s certificate Amazon resource name (ARN).

      • customDomainCertificateExpiryTime (datetime) --

        The expiration time for the certificate.

      • customDomainName (string) --

        The custom domain name associated with the workgroup.

      • endpoint (dict) --

        The endpoint that is created from the workgroup.

        • address (string) --

          The DNS address of the VPC endpoint.

        • port (integer) --

          The port that Amazon Redshift Serverless listens on.

        • vpcEndpoints (list) --

          An array of VpcEndpoint objects.

          • (dict) --

            The connection endpoint for connecting to Amazon Redshift Serverless through the proxy.

            • networkInterfaces (list) --

              One or more network interfaces of the endpoint. Also known as an interface endpoint.

              • (dict) --

                Contains information about a network interface in an Amazon Redshift Serverless managed VPC endpoint.

                • availabilityZone (string) --

                  The availability Zone.

                • ipv6Address (string) --

                  The IPv6 address of the network interface within the subnet.

                • networkInterfaceId (string) --

                  The unique identifier of the network interface.

                • privateIpAddress (string) --

                  The IPv4 address of the network interface within the subnet.

                • subnetId (string) --

                  The unique identifier of the subnet.

            • vpcEndpointId (string) --

              The connection endpoint ID for connecting to Amazon Redshift Serverless.

            • vpcId (string) --

              The VPC identifier that the endpoint is associated with.

      • enhancedVpcRouting (boolean) --

        The value that specifies whether to enable enhanced virtual private cloud (VPC) routing, which forces Amazon Redshift Serverless to route traffic through your VPC.

      • ipAddressType (string) --

        The IP address type that the workgroup supports. Possible values are ipv4 and dualstack .

      • maxCapacity (integer) --

        The maximum data-warehouse capacity Amazon Redshift Serverless uses to serve queries. The max capacity is specified in RPUs.

      • namespaceName (string) --

        The namespace the workgroup is associated with.

      • patchVersion (string) --

        The patch version of your Amazon Redshift Serverless workgroup. For more information about patch versions, see Cluster versions for Amazon Redshift.

      • port (integer) --

        The custom port to use when connecting to a workgroup. Valid port ranges are 5431-5455 and 8191-8215. The default is 5439.

      • pricePerformanceTarget (dict) --

        An object that represents the price performance target settings for the workgroup.

        • level (integer) --

          The target price performance level for the workgroup. Valid values include 1, 25, 50, 75, and 100. These correspond to the price performance levels LOW_COST, ECONOMICAL, BALANCED, RESOURCEFUL, and HIGH_PERFORMANCE.

        • status (string) --

          Whether the price performance target is enabled for the workgroup.

      • publiclyAccessible (boolean) --

        A value that specifies whether the workgroup can be accessible from a public network.

      • securityGroupIds (list) --

        An array of security group IDs to associate with the workgroup.

        • (string) --

      • status (string) --

        The status of the workgroup.

      • subnetIds (list) --

        An array of subnet IDs the workgroup is associated with.

        • (string) --

      • workgroupArn (string) --

        The Amazon Resource Name (ARN) that links to the workgroup.

      • workgroupId (string) --

        The unique identifier of the workgroup.

      • workgroupName (string) --

        The name of the workgroup.

      • workgroupVersion (string) --

        The Amazon Redshift Serverless version of your workgroup. For more information about Amazon Redshift Serverless versions, see Cluster versions for Amazon Redshift.