Skip to main content

vw_predictions

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

Overview​

Namevw_predictions
TypeView
Idazure_extras.customer_insights.vw_predictions

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, '$.description') as "description",
JSON_EXTRACT(properties, '$.displayName') as "display_name",
JSON_EXTRACT(properties, '$.involvedInteractionTypes') as "involved_interaction_types",
JSON_EXTRACT(properties, '$.involvedKpiTypes') as "involved_kpi_types",
JSON_EXTRACT(properties, '$.involvedRelationships') as "involved_relationships",
JSON_EXTRACT(properties, '$.negativeOutcomeExpression') as "negative_outcome_expression",
JSON_EXTRACT(properties, '$.positiveOutcomeExpression') as "positive_outcome_expression",
JSON_EXTRACT(properties, '$.primaryProfileType') as "primary_profile_type",
JSON_EXTRACT(properties, '$.provisioningState') as "provisioning_state",
JSON_EXTRACT(properties, '$.predictionName') as "prediction_name",
JSON_EXTRACT(properties, '$.scopeExpression') as "scope_expression",
JSON_EXTRACT(properties, '$.tenantId') as "tenant_id",
JSON_EXTRACT(properties, '$.autoAnalyze') as "auto_analyze",
JSON_EXTRACT(properties, '$.mappings') as "mappings",
JSON_EXTRACT(properties, '$.scoreLabel') as "score_label",
JSON_EXTRACT(properties, '$.grades') as "grades",
JSON_EXTRACT(properties, '$.systemGeneratedEntities') as "system_generated_entities",
subscriptionId,
resourceGroupName,
hubName,
predictionName
FROM azure_extras.customer_insights.predictions
WHERE subscriptionId = 'replace-me' AND resourceGroupName = 'replace-me' AND hubName = 'replace-me';