Skip to main content

vw_links

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

Overview​

Namevw_links
TypeView
Idazure_extras.customer_insights.vw_links

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,
JSON_EXTRACT(properties, '$.tenantId') as "tenant_id",
JSON_EXTRACT(properties, '$.linkName') as "link_name",
JSON_EXTRACT(properties, '$.sourceEntityType') as "source_entity_type",
JSON_EXTRACT(properties, '$.targetEntityType') as "target_entity_type",
JSON_EXTRACT(properties, '$.sourceEntityTypeName') as "source_entity_type_name",
JSON_EXTRACT(properties, '$.targetEntityTypeName') as "target_entity_type_name",
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.description') as "description",
JSON_EXTRACT(properties, '$.mappings') as "mappings",
JSON_EXTRACT(properties, '$.participantPropertyReferences') as "participant_property_references",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.referenceOnly') as "reference_only",
JSON_EXTRACT(properties, '$.operationType') as "operation_type",
subscriptionId,
resourceGroupName,
hubName,
linkName
FROM azure_extras.customer_insights.links
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND hubName = 'replace-me';