steampipe plugin install awssteampipe plugin install aws

Table: aws_redshiftserverless_workgroup

Amazon Redshift Serverless workgroups are collections of compute resources. The compute-related workgroup groups together compute resources like RPUs, VPC subnet groups, and security groups. Properties for the workgroup include network and security settings. Other resources that are grouped under workgroups include access and usage limits.

Examples

Basic info

select
  workgroup_name,
  workgroup_arn,
  workgroup_id,
  base_capacity,
  creation_date,
  region,
  status
from
  aws_redshiftserverless_workgroup;

List unavailable workgroups

select
  workgroup_name,
  workgroup_arn,
  workgroup_id,
  base_capacity,
  creation_date,
  region,
  status
from
  aws_redshiftserverless_workgroup
where
  status <> 'AVAILABLE';

List publicly accessible workgroups

select
  workgroup_name,
  workgroup_arn,
  workgroup_id,
  base_capacity,
  creation_date,
  region,
  status
from
  aws_redshiftserverless_workgroup
where
  publicly_accessible;

Get total base capacity utilized by available workgroups

select
  sum(base_capacity) total_base_capacity
from
  aws_redshiftserverless_workgroup
where
  status = 'AVAILABLE';

Get endpoint details of each workgroups

select
  workgroup_arn,
  endpoint ->> 'Address' as endpoint_address,
  endpoint ->> 'Port' as endpoint_port,
  endpoint -> 'VpcEndpoints' as endpoint_vpc_details
from
  aws_redshiftserverless_workgroup;

List config parameters associated with each workgroup

select
  workgroup_arn,
  p ->> 'ParameterKey' as parameter_key,
  p ->> 'ParameterValue' as parameter_value
from
  aws_redshiftserverless_workgroup,
  jsonb_array_elements(config_parameters) p;

.inspect aws_redshiftserverless_workgroup

AWS Redshift Serverless Workgroup

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
base_capacity	bigint	The base data warehouse capacity of the workgroup in Redshift Processing Units (RPUs).
config_parameters	jsonb	An array of parameters to set for finer control over a database.
creation_date	timestamp with time zone	The creation date of the workgroup.
endpoint	jsonb	The endpoint that is created from the workgroup.
enhanced_vpc_routing	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.
namespace_name	text	The namespace the workgroup is associated with.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
publicly_accessible	boolean	A value that specifies whether the workgroup can be accessible from a public network.
region	text	The AWS Region in which the resource is located.
security_group_ids	jsonb	An array of security group IDs to associate with the workgroup.
status	text	The status of the workgroup.
subnet_ids	jsonb	An array of subnet IDs the workgroup is associated with.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	The list of tags for the workgroup.
title	text	Title of the resource.
workgroup_arn	text	The Amazon Resource Name (ARN) that links to the workgroup.
workgroup_id	text	The unique identifier of the workgroup.
workgroup_name	text	The name of the workgroup.

turbot/aws