Table: aws_rds_db_option_group

An option group can specify features, called options, that are available for a particular Amazon RDS DB instance. Options can have settings that specify how the option works. When a DB instance associated with an option group, the specified options and option settings are enabled for that DB instance.

Examples

Basic parameter group info

select
  name,
  description,
  engine_name,
  major_engine_version,
  vpc_id
from
  aws_rds_db_option_group;

List of option groups which can be applied to both VPC and non-VPC instances

select
  name,
  description,
  engine_name,
  allows_vpc_and_non_vpc_instance_memberships
from
  aws_rds_db_option_group
where
  allows_vpc_and_non_vpc_instance_memberships;

Option details of each option group

select
  name,
  option ->> 'OptionName' as option_name,
  option -> 'Permanent' as Permanent,
  option -> 'Persistent' as Persistent,
  option -> 'VpcSecurityGroupMemberships' as vpc_security_group_membership,
  option -> 'Port' as Port
from
  aws_rds_db_option_group
  cross join jsonb_array_elements(options) as option;

Control examples

.inspect aws_rds_db_option_group

AWS RDS DB Option Group

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.
allows_vpc_and_non_vpc_instance_memberships	boolean	Specifies whether this option group can be applied to both VPC and non-VPC instances.
arn	text	The Amazon Resource Name (ARN) for the option group.
description	text	Provides a description of the option group.
engine_name	text	Indicates the name of the engine that this option group can be applied to.
major_engine_version	text	Indicates the major engine version associated with this option group.
name	text	The friendly name to identify the option group.
options	jsonb	Indicates what options are available in the option group.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text	The AWS Region in which the resource is located.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags attached to the option group.
title	text	Title of the resource.
vpc_id	text	Indicates the ID of the VPC, option group can be applied.

turbot/aws