turbot/aws_insights

Query: kinesis_streams_for_api_gatewayv2_api

Usage

powerpipe query aws_insights.query.kinesis_streams_for_api_gatewayv2_api

SQL

select
s.stream_arn as kinesis_stream_arn
from
aws_api_gatewayv2_integration as i
join aws_kinesis_stream as s on i.request_parameters ->> 'StreamName' = s.stream_name
join aws_api_gatewayv2_api as a on a.api_id = i.api_id
where
integration_subtype like '%Kinesis-%'
and a.api_id = $1;