Query: api_gateway_method_authorization_type_configured

select
  resource_id as resource,
  case
    when authorization_type = 'NONE' then 'alarm'
    else 'ok'
  end as status,
  case
    when authorization_type = 'NONE' then title || ' authorization type not configured.'
    else title || ' authorization type ' || authorization_type || ' configured.'
  end as reason,
  region,
  account_id
from
  aws_api_gateway_method;