Query: network_express_route_circuit_service_provider_properties

select
  service_provider_properties ->> 'serviceProviderName' as "Name",
  service_provider_properties ->> 'bandwidthInMbps' as "Bandwidth In Mbps",
  service_provider_properties ->> 'peeringLocation' as "Peering Location"
from
  azure_express_route_circuit
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);