steampipe plugin install aws

Table: aws_rds_db_option_group - Query AWS RDS DB Option Groups using SQL

The AWS RDS DB Option Groups service allows you to manage and configure additional features for your Amazon RDS databases. These groups are used to specify and manage the configuration options that are available for your DB instances. By using SQL, you can query these option groups to easily manage and organize your database configurations.

Table Usage Guide

The aws_rds_db_option_group table in Steampipe provides you with information about the option groups within Amazon Relational Database Service (RDS). This table allows you, as a database administrator or developer, to query option group-specific details, including the options and parameters associated with the group, the engine name, and the major engine version. You can utilize this table to gather insights on option groups, such as identifying the configurations of specific databases, verifying the parameters of option groups, and more. The schema outlines the various attributes of the RDS DB Option Group for you, including the name, ARN, description, and associated tags.

Examples

Basic parameter group info

Analyze the settings to understand the basic information about your AWS RDS database option groups, such as the engine used and the version. This can help in managing and optimizing your database configurations.

select
name,
description,
engine_name,
major_engine_version,
vpc_id
from
aws_rds_db_option_group;
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

Discover the segments that can be applied to both VPC and non-VPC instances in AWS RDS. This can be beneficial in understanding the flexibility and adaptability of your database configurations.

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;
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 = 1;

Option details of each option group

Explore the various options within each option group in an AWS RDS database. This can help in understanding the settings of each option, including its permanence, persistence, associated security group memberships, and port, aiding in effective database management and security.

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;
select
name,
json_extract(option.value, '$.OptionName') as option_name,
json_extract(option.value, '$.Permanent') as Permanent,
json_extract(option.value, '$.Persistent') as Persistent,
json_extract(option.value, '$.VpcSecurityGroupMemberships') as vpc_security_group_membership,
json_extract(option.value, '$.Port') as Port
from
aws_rds_db_option_group,
json_each(options) as option;

Schema for aws_rds_db_option_group

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextThe AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
allows_vpc_and_non_vpc_instance_membershipsbooleanSpecifies whether this option group can be applied to both VPC and non-VPC instances.
arntextThe Amazon Resource Name (ARN) for the option group.
descriptiontextProvides a description of the option group.
engine_nametext=Indicates the name of the engine that this option group can be applied to.
major_engine_versiontext=Indicates the major engine version associated with this option group.
nametext=The friendly name to identify the option group.
optionsjsonbIndicates what options are available in the option group.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
tagsjsonbA map of tags for the resource.
tags_srcjsonbA list of tags attached to the option group.
titletextTitle of the resource.
vpc_idtextIndicates the ID of the VPC, option group can be applied.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_rds_db_option_group