2023/10/30 - Redshift Serverless - 5 new6 updated api methods
Changes Added support for custom domain names for Amazon Redshift Serverless workgroups. This feature enables customers to create a custom domain name and use ACM to generate fully secure connections to it.
Updates an Amazon Redshift Serverless certificate associated with a custom domain.
See also: AWS API Documentation
Request Syntax
client.update_custom_domain_association(
customDomainCertificateArn='string',
customDomainName='string',
workgroupName='string'
)
string
[REQUIRED]
The custom domain name’s certificate Amazon resource name (ARN). This is optional.
string
[REQUIRED]
The custom domain name associated with the workgroup.
string
[REQUIRED]
The name of the workgroup associated with the database.
dict
Response Syntax
{
'customDomainCertificateArn': 'string',
'customDomainCertificateExpiryTime': datetime(2015, 1, 1),
'customDomainName': 'string',
'workgroupName': 'string'
}
Response Structure
(dict) --
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.
workgroupName (string) --
The name of the workgroup associated with the database.
Deletes a custom domain association for Amazon Redshift Serverless.
See also: AWS API Documentation
Request Syntax
client.delete_custom_domain_association(
customDomainName='string',
workgroupName='string'
)
string
[REQUIRED]
The custom domain name associated with the workgroup.
string
[REQUIRED]
The name of the workgroup associated with the database.
dict
Response Syntax
{}
Response Structure
(dict) --
Creates a custom domain association for Amazon Redshift Serverless.
See also: AWS API Documentation
Request Syntax
client.create_custom_domain_association(
customDomainCertificateArn='string',
customDomainName='string',
workgroupName='string'
)
string
[REQUIRED]
The custom domain name’s certificate Amazon resource name (ARN).
string
[REQUIRED]
The custom domain name to associate with the workgroup.
string
[REQUIRED]
The name of the workgroup associated with the database.
dict
Response Syntax
{
'customDomainCertificateArn': 'string',
'customDomainCertificateExpiryTime': datetime(2015, 1, 1),
'customDomainName': 'string',
'workgroupName': 'string'
}
Response Structure
(dict) --
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 to associate with the workgroup.
workgroupName (string) --
The name of the workgroup associated with the database.
Gets information about a specific custom domain association.
See also: AWS API Documentation
Request Syntax
client.get_custom_domain_association(
customDomainName='string',
workgroupName='string'
)
string
[REQUIRED]
The custom domain name associated with the workgroup.
string
[REQUIRED]
The name of the workgroup associated with the database.
dict
Response Syntax
{
'customDomainCertificateArn': 'string',
'customDomainCertificateExpiryTime': datetime(2015, 1, 1),
'customDomainName': 'string',
'workgroupName': 'string'
}
Response Structure
(dict) --
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.
workgroupName (string) --
The name of the workgroup associated with the database.
Lists custom domain associations for Amazon Redshift Serverless.
See also: AWS API Documentation
Request Syntax
client.list_custom_domain_associations(
customDomainCertificateArn='string',
customDomainName='string',
maxResults=123,
nextToken='string'
)
string
The custom domain name’s certificate Amazon resource name (ARN).
string
The custom domain name associated with the workgroup.
integer
An optional parameter that specifies the maximum number of results to return. You can use nextToken to display the next page of results.
string
When nextToken is returned, there are more results available. The value of nextToken is a unique pagination token for each page. Make the call again using the returned token to retrieve the next page.
dict
Response Syntax
{
'associations': [
{
'customDomainCertificateArn': 'string',
'customDomainCertificateExpiryTime': datetime(2015, 1, 1),
'customDomainName': 'string',
'workgroupName': 'string'
},
],
'nextToken': 'string'
}
Response Structure
(dict) --
associations (list) --
A list of Association objects.
(dict) --
An object that represents the custom domain name association.
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.
workgroupName (string) --
The name of the workgroup associated with the database.
nextToken (string) --
When nextToken is returned, there are more results available. The value of nextToken is a unique pagination token for each page. Make the call again using the returned token to retrieve the next page.
{'workgroup': {'customDomainCertificateArn': 'string',
'customDomainCertificateExpiryTime': 'timestamp',
'customDomainName': 'string'}}
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,
namespaceName='string',
port=123,
publiclyAccessible=True|False,
securityGroupIds=[
'string',
],
subnetIds=[
'string',
],
tags=[
{
'key': 'string',
'value': 'string'
},
],
workgroupName='string'
)
integer
The base data warehouse capacity of the workgroup in Redshift Processing Units (RPUs).
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.
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.
string
[REQUIRED]
The name of the namespace to associate with the workgroup.
integer
The custom port to use when connecting to a workgroup. Valid port ranges are 5431-5455 and 8191-8215. The default is 5439.
boolean
A value that specifies whether the workgroup can be accessed from a public network.
list
An array of security group IDs to associate with the workgroup.
(string) --
list
An array of VPC subnet IDs to associate with the workgroup.
(string) --
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.
string
[REQUIRED]
The name of the created workgroup.
dict
Response Syntax
{
'workgroup': {
'baseCapacity': 123,
'configParameters': [
{
'parameterKey': 'string',
'parameterValue': 'string'
},
],
'creationDate': datetime(2015, 1, 1),
'customDomainCertificateArn': 'string',
'customDomainCertificateExpiryTime': datetime(2015, 1, 1),
'customDomainName': 'string',
'endpoint': {
'address': 'string',
'port': 123,
'vpcEndpoints': [
{
'networkInterfaces': [
{
'availabilityZone': 'string',
'networkInterfaceId': 'string',
'privateIpAddress': 'string',
'subnetId': 'string'
},
],
'vpcEndpointId': 'string',
'vpcId': 'string'
},
]
},
'enhancedVpcRouting': True|False,
'namespaceName': 'string',
'patchVersion': 'string',
'port': 123,
'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_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.
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.
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.
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.
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.
{'workgroup': {'customDomainCertificateArn': 'string',
'customDomainCertificateExpiryTime': 'timestamp',
'customDomainName': 'string'}}
Deletes a workgroup.
See also: AWS API Documentation
Request Syntax
client.delete_workgroup(
workgroupName='string'
)
string
[REQUIRED]
The name of the workgroup to be deleted.
dict
Response Syntax
{
'workgroup': {
'baseCapacity': 123,
'configParameters': [
{
'parameterKey': 'string',
'parameterValue': 'string'
},
],
'creationDate': datetime(2015, 1, 1),
'customDomainCertificateArn': 'string',
'customDomainCertificateExpiryTime': datetime(2015, 1, 1),
'customDomainName': 'string',
'endpoint': {
'address': 'string',
'port': 123,
'vpcEndpoints': [
{
'networkInterfaces': [
{
'availabilityZone': 'string',
'networkInterfaceId': 'string',
'privateIpAddress': 'string',
'subnetId': 'string'
},
],
'vpcEndpointId': 'string',
'vpcId': 'string'
},
]
},
'enhancedVpcRouting': True|False,
'namespaceName': 'string',
'patchVersion': 'string',
'port': 123,
'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_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.
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.
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.
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.
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.
{'customDomainName': 'string'}
Returns a database user name and temporary password with temporary authorization to log in to Amazon Redshift Serverless.
By default, the temporary credentials expire in 900 seconds. You can optionally specify a duration between 900 seconds (15 minutes) and 3600 seconds (60 minutes).
`` <p>The Identity and Access Management (IAM) user or role that runs GetCredentials must have an IAM policy attached that allows access to all necessary actions and resources.</p> <p>If the <code>DbName</code> parameter is specified, the IAM policy must allow access to the resource dbname for the specified database name.</p>``
See also: AWS API Documentation
Request Syntax
client.get_credentials(
customDomainName='string',
dbName='string',
durationSeconds=123,
workgroupName='string'
)
string
The custom domain name associated with the workgroup. The custom domain name or the workgroup name must be included in the request.
string
The name of the database to get temporary authorization to log on to.
Constraints:
Must be 1 to 64 alphanumeric characters or hyphens.
Must contain only uppercase or lowercase letters, numbers, underscore, plus sign, period (dot), at symbol (@), or hyphen.
The first character must be a letter.
Must not contain a colon ( : ) or slash ( / ).
Cannot be a reserved word. A list of reserved words can be found in Reserved Words in the Amazon Redshift Database Developer Guide
integer
The number of seconds until the returned temporary password expires. The minimum is 900 seconds, and the maximum is 3600 seconds.
string
The name of the workgroup associated with the database.
dict
Response Syntax
{
'dbPassword': 'string',
'dbUser': 'string',
'expiration': datetime(2015, 1, 1),
'nextRefreshTime': datetime(2015, 1, 1)
}
Response Structure
(dict) --
dbPassword (string) --
A temporary password that authorizes the user name returned by DbUser to log on to the database DbName.
dbUser (string) --
A database user name that is authorized to log on to the database DbName using the password DbPassword. If the specified DbUser exists in the database, the new user name has the same database privileges as the the user named in DbUser. By default, the user is added to PUBLIC.
expiration (datetime) --
The date and time the password in DbPassword expires.
nextRefreshTime (datetime) --
The date and time of when the DbUser and DbPassword authorization refreshes.
{'workgroup': {'customDomainCertificateArn': 'string',
'customDomainCertificateExpiryTime': 'timestamp',
'customDomainName': 'string'}}
Returns information about a specific workgroup.
See also: AWS API Documentation
Request Syntax
client.get_workgroup(
workgroupName='string'
)
string
[REQUIRED]
The name of the workgroup to return information for.
dict
Response Syntax
{
'workgroup': {
'baseCapacity': 123,
'configParameters': [
{
'parameterKey': 'string',
'parameterValue': 'string'
},
],
'creationDate': datetime(2015, 1, 1),
'customDomainCertificateArn': 'string',
'customDomainCertificateExpiryTime': datetime(2015, 1, 1),
'customDomainName': 'string',
'endpoint': {
'address': 'string',
'port': 123,
'vpcEndpoints': [
{
'networkInterfaces': [
{
'availabilityZone': 'string',
'networkInterfaceId': 'string',
'privateIpAddress': 'string',
'subnetId': 'string'
},
],
'vpcEndpointId': 'string',
'vpcId': 'string'
},
]
},
'enhancedVpcRouting': True|False,
'namespaceName': 'string',
'patchVersion': 'string',
'port': 123,
'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_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.
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.
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.
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.
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.
{'workgroups': {'customDomainCertificateArn': 'string',
'customDomainCertificateExpiryTime': 'timestamp',
'customDomainName': 'string'}}
Returns information about a list of specified workgroups.
See also: AWS API Documentation
Request Syntax
client.list_workgroups(
maxResults=123,
nextToken='string'
)
integer
An optional parameter that specifies the maximum number of results to return. You can use nextToken to display the next page of results.
string
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.
dict
Response Syntax
{
'nextToken': 'string',
'workgroups': [
{
'baseCapacity': 123,
'configParameters': [
{
'parameterKey': 'string',
'parameterValue': 'string'
},
],
'creationDate': datetime(2015, 1, 1),
'customDomainCertificateArn': 'string',
'customDomainCertificateExpiryTime': datetime(2015, 1, 1),
'customDomainName': 'string',
'endpoint': {
'address': 'string',
'port': 123,
'vpcEndpoints': [
{
'networkInterfaces': [
{
'availabilityZone': 'string',
'networkInterfaceId': 'string',
'privateIpAddress': 'string',
'subnetId': 'string'
},
],
'vpcEndpointId': 'string',
'vpcId': 'string'
},
]
},
'enhancedVpcRouting': True|False,
'namespaceName': 'string',
'patchVersion': 'string',
'port': 123,
'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_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.
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.
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.
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.
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.
{'workgroup': {'customDomainCertificateArn': 'string',
'customDomainCertificateExpiryTime': 'timestamp',
'customDomainName': 'string'}}
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,
port=123,
publiclyAccessible=True|False,
securityGroupIds=[
'string',
],
subnetIds=[
'string',
],
workgroupName='string'
)
integer
The new base data warehouse capacity in Redshift Processing Units (RPUs).
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.
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.
integer
The custom port to use when connecting to a workgroup. Valid port ranges are 5431-5455 and 8191-8215. The default is 5439.
boolean
A value that specifies whether the workgroup can be accessible from a public network.
list
An array of security group IDs to associate with the workgroup.
(string) --
list
An array of VPC subnet IDs to associate with the workgroup.
(string) --
string
[REQUIRED]
The name of the workgroup to update. You can't update the name of a workgroup once it is created.
dict
Response Syntax
{
'workgroup': {
'baseCapacity': 123,
'configParameters': [
{
'parameterKey': 'string',
'parameterValue': 'string'
},
],
'creationDate': datetime(2015, 1, 1),
'customDomainCertificateArn': 'string',
'customDomainCertificateExpiryTime': datetime(2015, 1, 1),
'customDomainName': 'string',
'endpoint': {
'address': 'string',
'port': 123,
'vpcEndpoints': [
{
'networkInterfaces': [
{
'availabilityZone': 'string',
'networkInterfaceId': 'string',
'privateIpAddress': 'string',
'subnetId': 'string'
},
],
'vpcEndpointId': 'string',
'vpcId': 'string'
},
]
},
'enhancedVpcRouting': True|False,
'namespaceName': 'string',
'patchVersion': 'string',
'port': 123,
'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_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.
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.
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.
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.
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.