Skip to main content

vw_apps

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

Overview​

Namevw_apps
TypeView
Idazure.spring_apps.vw_apps

Fields​

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

SQL Definition​

SELECT
location as location,
identity as identity,
JSON_EXTRACT(properties, '$.public') as "public",
JSON_EXTRACT(properties, '$.url') as "url",
JSON_EXTRACT(properties, '$.addonConfigs') as "addon_configs",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.fqdn') as "fqdn",
JSON_EXTRACT(properties, '$.httpsOnly') as "https_only",
JSON_EXTRACT(properties, '$.temporaryDisk') as "temporary_disk",
JSON_EXTRACT(properties, '$.persistentDisk') as "persistent_disk",
JSON_EXTRACT(properties, '$.customPersistentDisks') as "custom_persistent_disks",
JSON_EXTRACT(properties, '$.enableEndToEndTLS') as "enable_end_to_end_tls",
JSON_EXTRACT(properties, '$.loadedCertificates') as "loaded_certificates",
JSON_EXTRACT(properties, '$.vnetAddons') as "vnet_addons",
JSON_EXTRACT(properties, '$.ingressSettings') as "ingress_settings",
JSON_EXTRACT(properties, '$.secrets') as "secrets",
JSON_EXTRACT(properties, '$.workloadProfileName') as "workload_profile_name",
JSON_EXTRACT(properties, '$.testEndpointAuthState') as "test_endpoint_auth_state",
subscriptionId,
resourceGroupName,
serviceName,
appName
FROM azure.spring_apps.apps
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serviceName = 'replace-me';