Query: cosmosdb_account_private_endpoint_connection

select
  split_part(c ->> 'PrivateEndpointConnectionId', 'privateEndpointConnections/', 2) as "Private Endpoint Connection Name",
  c ->> 'PrivateEndpointConnectionType' as "Private Endpoint Connection Type",
  c ->> 'PrivateLinkServiceConnectionStateActionsRequired' as "Private Link Service Connection State Actions Required",
  c ->> 'PrivateLinkServiceConnectionStateStatus' as "Private Link Service Connection State Status",
  c ->> 'PrivateEndpointId' as "Private Endpoint ID",
  c ->> 'PrivateEndpointConnectionId' as "Private Endpoint Connection ID"
from
  azure_cosmosdb_account,
  jsonb_array_elements(private_endpoint_connections) as c
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);