Skip to main content

vw_gateways

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

Overview​

Namevw_gateways
TypeView
Idazure.spring_apps.vw_gateways

Fields​

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

SQL Definition​

SELECT
sku as sku,
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.public') as "public",
JSON_EXTRACT(properties, '$.url') as "url",
JSON_EXTRACT(properties, '$.httpsOnly') as "https_only",
JSON_EXTRACT(properties, '$.ssoProperties') as "sso_properties",
JSON_EXTRACT(properties, '$.apiMetadataProperties') as "api_metadata_properties",
JSON_EXTRACT(properties, '$.corsProperties') as "cors_properties",
JSON_EXTRACT(properties, '$.clientAuth') as "client_auth",
JSON_EXTRACT(properties, '$.apmTypes') as "apm_types",
JSON_EXTRACT(properties, '$.apms') as "apms",
JSON_EXTRACT(properties, '$.environmentVariables') as "environment_variables",
JSON_EXTRACT(properties, '$.resourceRequests') as "resource_requests",
JSON_EXTRACT(properties, '$.addonConfigs') as "addon_configs",
JSON_EXTRACT(properties, '$.instances') as "instances",
JSON_EXTRACT(properties, '$.operatorProperties') as "operator_properties",
JSON_EXTRACT(properties, '$.responseCacheProperties') as "response_cache_properties",
subscriptionId,
resourceGroupName,
serviceName,
gatewayName
FROM azure.spring_apps.gateways
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serviceName = 'replace-me';