Skip to main content

vw_external_networks

Creates, updates, deletes, gets or lists a vw_external_networks resource.

Overview​

Namevw_external_networks
TypeView
Idazure.managed_network_fabric.vw_external_networks

Fields​

See the SQL Definition (view DDL) for fields returned by this view.

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.annotation') as "annotation",
JSON_EXTRACT(properties, '$.networkToNetworkInterconnectId') as "network_to_network_interconnect_id",
JSON_EXTRACT(properties, '$.importRoutePolicyId') as "import_route_policy_id",
JSON_EXTRACT(properties, '$.exportRoutePolicyId') as "export_route_policy_id",
JSON_EXTRACT(properties, '$.importRoutePolicy') as "import_route_policy",
JSON_EXTRACT(properties, '$.exportRoutePolicy') as "export_route_policy",
JSON_EXTRACT(properties, '$.peeringOption') as "peering_option",
JSON_EXTRACT(properties, '$.optionBProperties') as "option_b_properties",
JSON_EXTRACT(properties, '$.optionAProperties') as "option_a_properties",
JSON_EXTRACT(properties, '$.configurationState') as "configuration_state",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.administrativeState') as "administrative_state",
subscriptionId,
resourceGroupName,
l3IsolationDomainName,
externalNetworkName
FROM azure.managed_network_fabric.external_networks
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND l3IsolationDomainName = 'replace-me';