Skip to main content

vw_routes

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

Overview​

Namevw_routes
TypeView
Idazure.cdn.vw_routes

Fields​

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

SQL Definition​

SELECT
JSON_EXTRACT(properties, '$.endpointName') as "endpoint_name",
JSON_EXTRACT(properties, '$.customDomains') as "custom_domains",
JSON_EXTRACT(properties, '$.originGroup') as "origin_group",
JSON_EXTRACT(properties, '$.originPath') as "origin_path",
JSON_EXTRACT(properties, '$.ruleSets') as "rule_sets",
JSON_EXTRACT(properties, '$.supportedProtocols') as "supported_protocols",
JSON_EXTRACT(properties, '$.patternsToMatch') as "patterns_to_match",
JSON_EXTRACT(properties, '$.cacheConfiguration') as "cache_configuration",
JSON_EXTRACT(properties, '$.forwardingProtocol') as "forwarding_protocol",
JSON_EXTRACT(properties, '$.linkToDefaultDomain') as "link_to_default_domain",
JSON_EXTRACT(properties, '$.httpsRedirect') as "https_redirect",
JSON_EXTRACT(properties, '$.enabledState') as "enabled_state",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.deploymentStatus') as "deployment_status",
subscriptionId,
resourceGroupName,
profileName,
endpointName,
routeName
FROM azure.cdn.routes
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND profileName = 'replace-me' AND endpointName = 'replace-me';