Query: virtual_network_peering_connection

select
  np ->> 'name' as "Name",
  np -> 'properties' -> 'allowForwardedTraffic' as "Allow Forwarded Traffic",
  np -> 'properties' -> 'allowGatewayTransit' as "Allow Gateway Transit",
  np -> 'properties' -> 'allowVirtualNetworkAccess' as "Allow Virtual Network Access",
  np -> 'properties' -> 'peeringState' as "Peering State",
  np -> 'properties' -> 'remoteAddressSpace'  -> 'addressPrefixes' as "Address Prefixes",
  np -> 'properties' -> 'remoteVirtualNetwork' ->> 'id' as "Remote Virtual Network ID",
  np -> 'properties' -> 'useRemoteGateways'   as "Use Remote Gateways",
  np -> 'id' as "ID"
from
  azure_virtual_network,
  jsonb_array_elements(network_peerings) as np
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);