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;