Query: cosmosdb_account_private_link

with private_link_enabled as (
  select
    distinct s.id
  from
    azure_cosmosdb_account as s,
    jsonb_array_elements(private_endpoint_connections) as connection
  where
    connection ->> 'PrivateLinkServiceConnectionStateStatus' = 'Approved'
)
select
  'Private Link' as label,
  case
    when va.id is not null then 'Enabled'
    else 'Disabled'
  end as value,
  case
    when va.id is not null then 'ok'
    else 'alert'
  end as type
from
  azure_cosmosdb_account as s
  left join private_link_enabled as va on s.id = va.id
where
  lower(s.id) = $1;