turbot/aws_insights

Query: source_sqs_queues_for_api_gatewayv2_api

Usage

powerpipe query aws_insights.query.source_sqs_queues_for_api_gatewayv2_api

SQL

select
q.queue_arn as queue_arn
from
aws_api_gatewayv2_integration as i
join aws_sqs_queue as q on i.request_parameters ->> 'QueueUrl' = q.queue_url
join aws_api_gatewayv2_api as a on a.api_id = i.api_id
where
integration_subtype like '%SQS-ReceiveMessage%'
and a.api_id = $1;