vw_build_service_builds

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

Overview

Name	vw_build_service_builds
Type	View
Id	azure.spring_apps.vw_build_service_builds

Fields

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

SQL Definition

Sqlite3

SELECT
JSON_EXTRACT(properties, '$.relativePath') as "relative_path",
JSON_EXTRACT(properties, '$.builder') as "builder",
JSON_EXTRACT(properties, '$.agentPool') as "agent_pool",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.env') as "env",
JSON_EXTRACT(properties, '$.apms') as "apms",
JSON_EXTRACT(properties, '$.certificates') as "certificates",
JSON_EXTRACT(properties, '$.triggeredBuildResult') as "triggered_build_result",
JSON_EXTRACT(properties, '$.resourceRequests') as "resource_requests",
subscriptionId,
resourceGroupName,
serviceName,
buildServiceName,
buildName
FROM azure.spring_apps.build_service_builds
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serviceName = 'replace-me' AND buildServiceName = 'replace-me';

Postgres

SELECT
json_extract_path_text(properties, '$.relativePath') as "relative_path",
json_extract_path_text(properties, '$.builder') as "builder",
json_extract_path_text(properties, '$.agentPool') as "agent_pool",
json_extract_path_text(properties, '$.provisioningState') as "provisioning_state",
json_extract_path_text(properties, '$.env') as "env",
json_extract_path_text(properties, '$.apms') as "apms",
json_extract_path_text(properties, '$.certificates') as "certificates",
json_extract_path_text(properties, '$.triggeredBuildResult') as "triggered_build_result",
json_extract_path_text(properties, '$.resourceRequests') as "resource_requests",
subscriptionId,
resourceGroupName,
serviceName,
buildServiceName,
buildName
FROM azure.spring_apps.build_service_builds
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND serviceName = 'replace-me' AND buildServiceName = 'replace-me';