steampipe plugin install aws

Table: aws_rds_db_event_subscription - Query AWS RDS DB Event Subscriptions using SQL

The AWS RDS DB Event Subscription is a feature of Amazon Relational Database Service (RDS) that allows you to receive notifications when specific database events occur. These events can include failovers, backups, configurations changes, and more. By creating an event subscription, you can ensure that you are promptly informed about changes that could impact your database operations.

Table Usage Guide

The aws_rds_db_event_subscription table in Steampipe provides you with information about event subscriptions within Amazon RDS. This table allows you, as a DevOps engineer, to query event subscription-specific details, including the associated RDS DB instances, the types of events the subscription applies to, and the notification methods for those events. You can utilize this table to monitor the status of your RDS DB instances, manage event notifications, and ensure all event subscriptions are properly configured. The schema outlines the various attributes of the event subscription, including the subscription name, ARN, status, and associated tags.

Examples

Basic info

Explore the status and activation of your Amazon RDS event subscriptions. This can be helpful to ensure all necessary subscriptions are active and functioning as expected.

select
cust_subscription_id,
customer_aws_id,
arn,
status,
enabled
from
aws_rds_db_event_subscription;
select
cust_subscription_id,
customer_aws_id,
arn,
status,
enabled
from
aws_rds_db_event_subscription;

List enabled DB event subscription

Explore which database event subscriptions are currently active in your AWS RDS service. This can help you manage your database events more effectively by identifying which subscriptions are currently receiving and processing events.

select
cust_subscription_id,
enabled
from
aws_rds_db_event_subscription
where
enabled;
select
cust_subscription_id,
enabled
from
aws_rds_db_event_subscription
where
enabled = 1;

Schema for aws_rds_db_event_subscription

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
arntextThe Amazon Resource Name (ARN) for the event subscription.
cust_subscription_idtext=The RDS event notification subscription Id.
customer_aws_idtextThe AWS customer account associated with the RDS event notification subscription.
enabledbooleanA Boolean value indicating if the subscription is enabled. True indicates the subscription is enabled.
event_categories_listjsonbA list of event categories for the RDS event notification subscription.
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.
sns_topic_arntextThe topic ARN of the RDS event notification subscription.
source_ids_listjsonbA list of source IDs for the RDS event notification subscription.
source_typetextThe source type for the RDS event notification subscription.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statustextThe status of the RDS event notification subscription, it can be one of the following: creating | modifying | deleting | active | no-permission | topic-not-exist.
subscription_creation_timetimestamp with time zoneThe time the RDS event notification subscription was created.
titletextTitle of the resource.

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_event_subscription