steampipe plugin install aws

Table: aws_sns_topic - Query AWS SNS Topics using SQL

The AWS Simple Notification Service (SNS) Topics is a web service that coordinates and manages the delivery or sending of messages to subscribing endpoints or clients. It provides a simple, cost-effective method to asynchronously distribute messages to a large number of endpoints, making it a fundamental part of the AWS messaging infrastructure. SNS Topics offer flexibility in terms of message delivery, allowing you to fan out messages to a large number of subscribers, including distributed systems and services, and mobile devices.

Table Usage Guide

The aws_sns_topic table in Steampipe provides you with information about each topic in Amazon Simple Notification Service (SNS). This table allows you as a DevOps engineer to query topic-specific details, including the topic name, owner, ARN, and other associated metadata. You can utilize this table to gather insights on SNS topics, such as topic subscription details, policy attributes, and more. The schema outlines for you the various attributes of the SNS topic, including the topic ARN, owner, subscription count, and associated tags.

Examples

List of unencrypted SNS topic

Identify instances where Simple Notification Service (SNS) topics in AWS are not encrypted, which could potentially expose sensitive data. This information is crucial for improving security measures and ensuring data privacy.

select
title,
kms_master_key_id
from
aws_sns_topic
where
kms_master_key_id is null;
select
title,
kms_master_key_id
from
aws_sns_topic
where
kms_master_key_id is null;

List of SNS topics which are not using Customer Managed Keys(CMK)

Identify instances where Simple Notification Service (SNS) topics are not secured with Customer Managed Keys (CMK). This is useful to ensure all your SNS topics have the added security layer of using your own encryption keys.

select
title,
kms_master_key_id
from
aws_sns_topic
where
kms_master_key_id = 'alias/aws/sns';
select
title,
kms_master_key_id
from
aws_sns_topic
where
kms_master_key_id = 'alias/aws/sns';

List of SNS topics without owner tag key

Discover the segments that have SNS topics without an assigned owner. This could be useful in managing and organizing your AWS resources more efficiently.

select
title,
tags
from
aws_sns_topic
where
not tags :: JSONB ? 'owner';
select
title,
tags
from
aws_sns_topic
where
json_extract(tags, '$.owner') is null;

List of SNS topics policy statements that grant anonymous access

Identify instances where anonymous access is granted in SNS topics policy statements. This is useful to uncover potential security risks, as unrestricted access might lead to unauthorized use or data breaches.

select
title,
p as principal,
a as action,
s ->> 'Effect' as effect,
s -> 'Condition' as conditions
from
aws_sns_topic,
jsonb_array_elements(policy_std -> 'Statement') as s,
jsonb_array_elements_text(s -> 'Principal' -> 'AWS') as p,
jsonb_array_elements_text(s -> 'Action') as a
where
p = '*'
and s ->> 'Effect' = 'Allow';
select
title,
json_extract(p.value, '$') as principal,
json_extract(a.value, '$') as action,
json_extract(s.value, '$.Effect') as effect,
json_extract(s.value, '$.Condition') as conditions
from
aws_sns_topic,
json_each(json_extract(policy_std, '$.Statement')) as s,
json_each(json_extract(s.value, '$.Principal.AWS')) as p,
json_each(json_extract(s.value, '$.Action')) as a
where
json_extract(p.value, '$') = '*'
and json_extract(s.value, '$.Effect') = 'Allow';

Topic policy statements that grant full access to the resource

Determine the areas in which topic policy statements are granting full access to the resource. This can help in assessing the security implications and managing access control effectively.

select
title,
p as principal,
a as action,
s ->> 'Effect' as effect,
s -> 'Condition' as conditions
from
aws_sns_topic,
jsonb_array_elements(policy_std -> 'Statement') as s,
jsonb_array_elements_text(s -> 'Principal' -> 'AWS') as p,
jsonb_array_elements_text(s -> 'Action') as a
where
s ->> 'Effect' = 'Allow'
and a in ('*', 'sns:*');
select
title,
json_extract(p.value, '$') as principal,
json_extract(a.value, '$') as action,
json_extract(s.value, '$.Effect') as effect,
json_extract(s.value, '$.Condition') as conditions
from
aws_sns_topic,
json_each(json_extract(policy_std, '$.Statement')) as s,
json_each(json_extract(s.value, '$.Principal.AWS')) as p,
json_each(json_extract(s.value, '$.Action')) as a
where
json_extract(s.value, '$.Effect') = 'Allow'
and (
json_extract(a.value, '$') = '*'
or json_extract(a.value, '$') = 'sns:*'
);

List of topics that DO NOT enforce encryption in transit

Identify instances where certain topics do not enforce encryption in transit, which could pose potential security risks. This is useful for maintaining data privacy and meeting compliance requirements.

select
title
from
aws_sns_topic
where
title not in (
select
title
from
aws_sns_topic,
jsonb_array_elements(policy_std -> 'Statement') as s,
jsonb_array_elements_text(s -> 'Principal' -> 'AWS') as p,
jsonb_array_elements_text(s -> 'Action') as a,
jsonb_array_elements_text(s -> 'Condition' -> 'Bool' -> 'aws:securetransport') as ssl
where
p = '*'
and s ->> 'Effect' = 'Deny'
and ssl :: bool = false
);
select
title
from
aws_sns_topic
where
title not in (
select
aws_sns_topic.title
from
aws_sns_topic,
json_each(json_extract(policy_std, '$.Statement')) as s,
json_each(json_extract(s.value, '$.Principal.AWS')) as p,
json_each(json_extract(s.value, '$.Action')) as a,
json_each(
json_extract(s.value, '$.Condition.Bool."aws:securetransport"')
) as ssl
where
json_extract(p.value, '$') = '*'
and json_extract(s.value, '$.Effect') = 'Deny'
and json_extract(ssl.value, '$') = 'false'
);

List topics which have delivery status logging for notification messages disabled

Identify instances where certain topics in your AWS SNS service have disabled delivery status logging for notification messages. This can be useful for auditing purposes or to rectify potential communication issues.

select
title,
topic_arn,
region
from
aws_sns_topic
where
application_failure_feedback_role_arn is null
and firehose_failure_feedback_role_arn is null
and http_failure_feedback_role_arn is null
and lambda_failure_feedback_role_arn is null
and sqs_failure_feedback_role_arn is null;
select
title,
topic_arn,
region
from
aws_sns_topic
where
application_failure_feedback_role_arn is null
and firehose_failure_feedback_role_arn is null
and http_failure_feedback_role_arn is null
and lambda_failure_feedback_role_arn is null
and sqs_failure_feedback_role_arn is null;

Schema for aws_sns_topic

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.
application_failure_feedback_role_arntextIAM role for failed deliveries of notification messages sent to topics with platform application endpoint.
application_success_feedback_role_arntextIAM role for successful deliveries of notification messages sent to topics with platform application endpoint.
application_success_feedback_sample_ratetextSample rate for successful deliveries of notification messages sent to topics with platform application endpoint.
delivery_policyjsonbThe JSON object of the topic's delivery policy.
display_nametextThe human-readable name used in the From field for notifications to email and email-json endpoints.
effective_delivery_policyjsonbThe effective delivery policy, taking system defaults into account.
firehose_failure_feedback_role_arntextIAM role for failed deliveries of notification messages sent to topics with kinesis data firehose endpoint.
firehose_success_feedback_role_arntextIAM role for successful deliveries of notification messages sent to topics with kinesis data firehose endpoint.
firehose_success_feedback_sample_ratetextSample rate for successful deliveries of notification messages sent to topics with firehose endpoint.
http_failure_feedback_role_arntextIAM role for failed deliveries of notification messages sent to topics with http endpoint.
http_success_feedback_role_arntextIAM role for successful deliveries of notification messages sent to topics with http endpoint.
http_success_feedback_sample_ratetextSample rate for successful deliveries of notification messages sent to topics with http endpoint.
kms_master_key_idtextThe ID of an AWS-managed customer master key (CMK) for Amazon SNS or a custom CMK.
lambda_failure_feedback_role_arntextIAM role for failed deliveries of notification messages sent to topics with lambda endpoint.
lambda_success_feedback_role_arntextIAM role for successful deliveries of notification messages sent to topics with lambda endpoint.
lambda_success_feedback_sample_ratetextSample rate for successful deliveries of notification messages sent to topics with lambda endpoint.
ownertextThe AWS account ID of the topic's owner.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
policyjsonbThe topic's access control policy (i.e. Resource IAM Policy).
policy_stdjsonbContains the policy in a canonical form for easier searching.
regiontextThe AWS Region in which the resource is located.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
sqs_failure_feedback_role_arntextIAM role for failed deliveries of notification messages sent to topics with sqs endpoint.
sqs_success_feedback_role_arntextIAM role for successful deliveries of notification messages sent to topics with sqs endpoint.
sqs_success_feedback_sample_ratetextSample rate for successful deliveries of notification messages sent to topics with sqs endpoint.
subscriptions_confirmedbigintThe number of confirmed subscriptions for the topic.
subscriptions_deletedbigintThe number of deleted subscriptions for the topic.
subscriptions_pendingbigintThe number of subscriptions pending confirmation for the topic.
tagsjsonbA map of tags for the resource.
tags_srcjsonbThe list of tags associated with the topic.
titletextTitle of the resource.
topic_arntext=Amazon Resource Name (ARN) of the Topic.

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_sns_topic