Skip to main content

vw_workflows

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

Overview​

Namevw_workflows
TypeView
Idazure.data_replication.vw_workflows

Fields​

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

SQL Definition​

SELECT
id as id,
name as name,
type as type,
systemData as system_data,
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.state') as "state",
JSON_EXTRACT(properties, '$.startTime') as "start_time",
JSON_EXTRACT(properties, '$.endTime') as "end_time",
JSON_EXTRACT(properties, '$.objectId') as "object_id",
JSON_EXTRACT(properties, '$.objectName') as "object_name",
JSON_EXTRACT(properties, '$.objectInternalId') as "object_internal_id",
JSON_EXTRACT(properties, '$.objectInternalName') as "object_internal_name",
JSON_EXTRACT(properties, '$.objectType') as "object_type",
JSON_EXTRACT(properties, '$.replicationProviderId') as "replication_provider_id",
JSON_EXTRACT(properties, '$.sourceFabricProviderId') as "source_fabric_provider_id",
JSON_EXTRACT(properties, '$.targetFabricProviderId') as "target_fabric_provider_id",
JSON_EXTRACT(properties, '$.allowedActions') as "allowed_actions",
JSON_EXTRACT(properties, '$.activityId') as "activity_id",
JSON_EXTRACT(properties, '$.tasks') as "tasks",
JSON_EXTRACT(properties, '$.errors') as "errors",
JSON_EXTRACT(properties, '$.customProperties') as "custom_properties",
subscriptionId,
resourceGroupName,
vaultName,
jobName
FROM azure.data_replication.workflows
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND vaultName = 'replace-me';