Query: sql_server_private_endpoint_connection

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