turbot/aws_compliance

Query: apigateway_rest_api_authorizers_configured

Usage

powerpipe query aws_compliance.query.apigateway_rest_api_authorizers_configured

SQL

select
p.name as resource,
case
when jsonb_array_length(a.provider_arns) > 0 then 'ok'
else 'alarm'
end as status,
case
when jsonb_array_length(a.provider_arns) > 0 then p.name || ' authorizers configured.'
else p.name || ' authorizers not configured.'
end as reason,
p.region,
p.account_id
from
aws_api_gateway_rest_api as p
left join aws_api_gateway_authorizer as a on p.api_id = a.rest_api_id;

Controls

The query is being used by the following controls: