turbot/aws_insights

Query: sqs_queue_policy

Usage

powerpipe query aws_insights.query.sqs_queue_policy

Steampipe Tables

SQL

select
p ->> 'Sid' as "SID",
p ->> 'Effect' as "Effect",
p -> 'Principal' as "Principal",
p -> 'Action' as "Action",
p -> 'Resource' as "Resource"
from
aws_sqs_queue,
jsonb_array_elements(policy_std -> 'Statement') as p
where
queue_arn = $1;