Query: network_firewall_ip_configurations

select
  c ->> 'privateIPAddress' as "Private IP Address",
  c -> 'publicIPAddress' ->> 'id' as "Public IP Address",
  c ->> 'provisioningState' as "Provisioning State",
  c -> 'subnet' ->> 'id' as "Subnet ID"
from
  azure_firewall,
  jsonb_array_elements(ip_configurations) as c
where
  lower(id) = $1;