Query: vpc_configured_to_use_interface_endpoint_for_docker_registry

with vpc_endpoints as (
  select distinct
    vpc_id
  from
    aws_vpc_endpoint
  where
    service_name  like 'com.amazonaws.' || region || '.ecr.dkr'
)
select
  v.arn as resource,
  case
    when e.vpc_id is null then 'alarm'
    else 'ok'
  end as status,
  case
    when e.vpc_id is null then v.title || ' not configured to use interface endpoint for docker registry.'
    else v.title || ' configured to use interface endpoint for docker registry.'
  end as reason
  
  , region, account_id
from
  aws_vpc v left join vpc_endpoints e using (vpc_id);