managed_workgroups

Creates, updates, deletes, gets or lists a managed_workgroups resource.

Overview

Name	managed_workgroups
Type	Resource
Id	aws.redshift_serverless.managed_workgroups

Fields

The following fields are returned by SELECT queries:

list_managed_workgroups

Name	Datatype	Description
creation_date	string (date-time)	The creation date of the managed workgroup.
managed_workgroup_id	string	The unique identifier of the managed workgroup.
managed_workgroup_name	string	The name of the managed workgroup. (pattern: <code>^[a-zA-Z0-9_:-]+$</code>)
source_arn	string	The Amazon Resource Name (ARN) for the managed workgroup in the Glue Data Catalog. (pattern: <code>^arn:aws[a-z-]:glue:[a-z0-9-]+:\d+:(database|catalog)[a-z0-9-:](?:/[A-Za-z0-9-_]{1,255})*$</code>)
status	string	The status of the managed workgroup. (CREATING, DELETING, MODIFYING, AVAILABLE, NOT_AVAILABLE)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_managed_workgroups	select	region		Returns information about a list of specified managed workgroups in your account.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
region	string	AWS region (default: us-east-1)

SELECT examples

list_managed_workgroups

Returns information about a list of specified managed workgroups in your account.

SELECT
creation_date,
managed_workgroup_id,
managed_workgroup_name,
source_arn,
status
FROM aws.redshift_serverless.managed_workgroups
WHERE region = '{{ region }}' -- required
;