Query: network_express_route_circuit_overview

select
  name as "Name",
  etag as "ETag",
  service_key as "Service Key",
  circuit_provisioning_state as "Circuit Provisioning State",
  service_provider_provisioning_state as "Service Provider Provisioning State",
  region as "Region",
  resource_group as "Resource Group",
  subscription_id as "Subscription ID",
  id as "ID"
from
  azure_express_route_circuit
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);