Table: aws_sns_topic_subscription

The AWS SNS Subscription resource subscribes an endpoint to an SNS topic.

Examples

List of subscriptions which are not configured with dead letter queue

select
  title,
  redrive_policy
from
  aws_sns_topic_subscription
where
  redrive_policy is null;

List of subscriptions which are not configured to filter messages

select
  title,
  filter_policy
from
  aws_sns_topic_subscription
where
  filter_policy is null;

Subscription count by topic arn

select
  title,
  count(subscription_arn) as subscription_count
from
  aws_sns_topic_subscription
group by
  title;

Query examples

.inspect aws_sns_topic_subscription

AWS SNS Topic Subscription

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.
confirmation_was_authenticated	boolean	Reflects authentication status of the subscription.
delivery_policy	jsonb	The JSON of the subscription's delivery policy.
effective_delivery_policy	jsonb	The JSON of the effective delivery policy that takes into account the topic delivery policy and account system defaults.
endpoint	text	The subscription's endpoint (format depends on the protocol).
filter_policy	jsonb	The filter policy JSON that is assigned to the subscription.
owner	text	The AWS account ID of the subscription's owner.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
pending_confirmation	boolean	Reflects the confirmation status of the subscription. True if the subscription hasn't been confirmed.
protocol	text	The subscription's protocol.
raw_message_delivery	boolean	true if raw message delivery is enabled for the subscription.
redrive_policy	jsonb	When specified, sends undeliverable messages to the specified Amazon SQS dead-letter queue. Messages that can't be delivered due to client errors (for example, when the subscribed endpoint is unreachable) or server errors (for example, when the service that powers the subscribed endpoint becomes unavailable) are held in the dead-letter queue for further analysis or reprocessing.
region	text	The AWS Region in which the resource is located.
subscription_arn	text	Amazon Resource Name of the subscription.
title	text	Title of the resource.
topic_arn	text	The topic ARN that the subscription is associated with.

turbot/aws

Table: aws_sns_topic_subscription

Examples

List of subscriptions which are not configured with dead letter queue

List of subscriptions which are not configured to filter messages

Subscription count by topic arn

Query examples

.inspect aws_sns_topic_subscription

Steampipe

Resources

Community