create_workgroup

create_workgroup(**kwargs)

Creates an workgroup in Amazon Redshift Serverless.

See also: AWS API Documentation

Request Syntax

response = client.create_workgroup(
    baseCapacity=123,
    configParameters=[
        {
            'parameterKey': 'string',
            'parameterValue': 'string'
        },
    ],
    enhancedVpcRouting=True|False,
    namespaceName='string',
    port=123,
    publiclyAccessible=True|False,
    securityGroupIds=[
        'string',
    ],
    subnetIds=[
        'string',
    ],
    tags=[
        {
            'key': 'string',
            'value': 'string'
        },
    ],
    workgroupName='string'
)
Parameters
  • 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_sensitivity_identifier , enable_user_activity_logging , query_group , search_path , 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_sensitivity_identifier , enable_user_activity_logging , query_group , search_path , 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.

  • enhancedVpcRouting (boolean) -- 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.
  • namespaceName (string) --

    [REQUIRED]

    The name of the namespace to associate with the workgroup.

  • 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.
  • publiclyAccessible (boolean) -- A value that specifies whether the workgroup can be accessed from a public network.
  • securityGroupIds (list) --

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

    • (string) --
  • subnetIds (list) --

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

    • (string) --
  • tags (list) --

    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.

  • workgroupName (string) --

    [REQUIRED]

    The name of the created workgroup.

Return type

dict

Returns

Response Syntax

{
    'workgroup': {
        'baseCapacity': 123,
        'configParameters': [
            {
                'parameterKey': 'string',
                'parameterValue': 'string'
            },
        ],
        'creationDate': datetime(2015, 1, 1),
        'endpoint': {
            'address': 'string',
            'port': 123,
            'vpcEndpoints': [
                {
                    'networkInterfaces': [
                        {
                            'availabilityZone': 'string',
                            'networkInterfaceId': 'string',
                            'privateIpAddress': 'string',
                            'subnetId': 'string'
                        },
                    ],
                    'vpcEndpointId': 'string',
                    'vpcId': 'string'
                },
            ]
        },
        'enhancedVpcRouting': True|False,
        'namespaceName': 'string',
        'port': 123,
        'publiclyAccessible': True|False,
        'securityGroupIds': [
            'string',
        ],
        'status': 'CREATING'|'AVAILABLE'|'MODIFYING'|'DELETING',
        'subnetIds': [
            'string',
        ],
        'workgroupArn': 'string',
        'workgroupId': 'string',
        'workgroupName': '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_sensitivity_identifier , enable_user_activity_logging , query_group , , search_path , 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_sensitivity_identifier , enable_user_activity_logging , query_group , search_path , 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.

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

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

      • namespaceName (string) --

        The namespace the workgroup is associated with.

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

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

Exceptions

  • RedshiftServerless.Client.exceptions.InternalServerException
  • RedshiftServerless.Client.exceptions.InsufficientCapacityException
  • RedshiftServerless.Client.exceptions.ResourceNotFoundException
  • RedshiftServerless.Client.exceptions.ConflictException
  • RedshiftServerless.Client.exceptions.ValidationException
  • RedshiftServerless.Client.exceptions.TooManyTagsException