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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
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.
arn	text		The Amazon Resource Name (ARN) for the event subscription.
cust_subscription_id	text	=	The RDS event notification subscription Id.
customer_aws_id	text		The AWS customer account associated with the RDS event notification subscription.
enabled	boolean		A Boolean value indicating if the subscription is enabled. True indicates the subscription is enabled.
event_categories_list	jsonb		A list of event categories for the RDS event notification subscription.
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.
sns_topic_arn	text		The topic ARN of the RDS event notification subscription.
source_ids_list	jsonb		A list of source IDs for the RDS event notification subscription.
source_type	text		The source type for the RDS event notification subscription.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The 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_time	timestamp with time zone		The time the RDS event notification subscription was created.
title	text		Title 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