Query: ec2_instance_public_access

select
  'Public IP Address' as label,
  case
    when public_ip_address is null then 'Disabled'
    else host(public_ip_address)
  end as value,
  case
    when public_ip_address is null then 'ok'
    else 'alert'
  end as type
from
  aws_ec2_instance
where
  arn = $1;