Redshift Serverless Workgroup

Docs > DDSQL Reference > Data Directory > Redshift Serverless Workgroup

Redshift Serverless Workgroup in AWS is a compute environment that runs serverless Amazon Redshift queries without needing to manage clusters. It provides isolated resources for running analytics workloads, automatically scaling capacity based on demand. Workgroups define the compute and networking configuration, including VPC, subnets, and security settings, making it easier to run data warehousing tasks with flexible performance and cost efficiency.

aws.redshiftserverless_workgroup

Fields

ID	Type	Data Type	Description
_key	core	string
account_id	core	string
base_capacity	core	int64	The base data warehouse capacity of the workgroup in Redshift Processing Units (RPUs).
config_parameters	core	json	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.
creation_date	core	timestamp	The creation date of the workgroup.
cross_account_vpcs	core	array<string>	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.
custom_domain_certificate_arn	core	string	The custom domain name’s certificate Amazon resource name (ARN).
custom_domain_certificate_expiry_time	core	timestamp	The expiration time for the certificate.
custom_domain_name	core	string	The custom domain name associated with the workgroup.
endpoint	core	json	The endpoint that is created from the workgroup.
enhanced_vpc_routing	core	bool	The value that specifies whether to enable enhanced virtual private cloud (VPC) routing, which forces Amazon Redshift Serverless to route traffic through your VPC.
ip_address_type	core	string	The IP address type that the workgroup supports. Possible values are ipv4 and dualstack.
max_capacity	core	int64	The maximum data-warehouse capacity Amazon Redshift Serverless uses to serve queries. The max capacity is specified in RPUs.
namespace_name	core	string	The namespace the workgroup is associated with.
patch_version	core	string	The patch version of your Amazon Redshift Serverless workgroup. For more information about patch versions, see Cluster versions for Amazon Redshift.
pending_track_name	core	string	The name for the track that you want to assign to the workgroup. When the track changes, the workgroup is switched to the latest workgroup release available for the track. At this point, the track name is applied.
port	core	int64	The custom port to use when connecting to a workgroup. Valid port ranges are 5431-5455 and 8191-8215. The default is 5439.
price_performance_target	core	json	An object that represents the price performance target settings for the workgroup.
publicly_accessible	core	bool	A value that specifies whether the workgroup can be accessible from a public network.
security_group_ids	core	array<string>	An array of security group IDs to associate with the workgroup.
status	core	string	The status of the workgroup.
subnet_ids	core	array<string>	An array of subnet IDs the workgroup is associated with.
tags	core	hstore
track_name	core	string	The name of the track for the workgroup.
workgroup_arn	core	string	The Amazon Resource Name (ARN) that links to the workgroup.
workgroup_id	core	string	The unique identifier of the workgroup.
workgroup_name	core	string	The name of the workgroup.
workgroup_version	core	string	The Amazon Redshift Serverless version of your workgroup. For more information about Amazon Redshift Serverless versions, seeCluster versions for Amazon Redshift.