predictions

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

Overview

Name	predictions
Type	Resource
Id	azure_extras.customer_insights.predictions

Fields

vw_predictions

Name	Datatype	Description
id	text	Resource ID.
name	text	Resource name.
description	text	field from the properties object
auto_analyze	text	field from the properties object
display_name	text	field from the properties object
grades	text	field from the properties object
hubName	text	field from the properties object
involved_interaction_types	text	field from the properties object
involved_kpi_types	text	field from the properties object
involved_relationships	text	field from the properties object
mappings	text	field from the properties object
negative_outcome_expression	text	field from the properties object
positive_outcome_expression	text	field from the properties object
predictionName	text	field from the properties object
prediction_name	text	field from the properties object
primary_profile_type	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
scope_expression	text	field from the properties object
score_label	text	field from the properties object
subscriptionId	text	field from the properties object
system_generated_entities	text	field from the properties object
tenant_id	text	field from the properties object
type	text	Resource type.

predictions

Name	Datatype	Description
id	string	Resource ID.
name	string	Resource name.
properties	object	The prediction definition.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	hubName, predictionName, resourceGroupName, subscriptionId	Gets a Prediction in the hub.
list_by_hub	SELECT	hubName, resourceGroupName, subscriptionId	Gets all the predictions in the specified hub.
create_or_update	INSERT	hubName, predictionName, resourceGroupName, subscriptionId	Creates a Prediction or updates an existing Prediction in the hub.
delete	DELETE	hubName, predictionName, resourceGroupName, subscriptionId	Deletes a Prediction in the hub.
model_status	EXEC	hubName, predictionName, resourceGroupName, subscriptionId, data__status	Creates or updates the model status of prediction.

SELECT examples

Gets all the predictions in the specified hub.

vw_predictions

SELECT
id,
name,
description,
auto_analyze,
display_name,
grades,
hubName,
involved_interaction_types,
involved_kpi_types,
involved_relationships,
mappings,
negative_outcome_expression,
positive_outcome_expression,
predictionName,
prediction_name,
primary_profile_type,
provisioning_state,
resourceGroupName,
scope_expression,
score_label,
subscriptionId,
system_generated_entities,
tenant_id,
type
FROM azure_extras.customer_insights.vw_predictions
WHERE hubName = '{{ hubName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

predictions

SELECT
id,
name,
properties,
type
FROM azure_extras.customer_insights.predictions
WHERE hubName = '{{ hubName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new predictions resource.

All Properties

/*+ create */
INSERT INTO azure_extras.customer_insights.predictions (
hubName,
predictionName,
resourceGroupName,
subscriptionId,
properties
)
SELECT 
'{{ hubName }}',
'{{ predictionName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: description
          value: object
        - name: displayName
          value: object
        - name: involvedInteractionTypes
          value:
            - string
        - name: involvedKpiTypes
          value:
            - string
        - name: involvedRelationships
          value:
            - string
        - name: negativeOutcomeExpression
          value: string
        - name: positiveOutcomeExpression
          value: string
        - name: primaryProfileType
          value: string
        - name: provisioningState
          value: []
        - name: predictionName
          value: string
        - name: scopeExpression
          value: string
        - name: tenantId
          value: string
        - name: autoAnalyze
          value: boolean
        - name: mappings
          value:
            - name: score
              value: string
            - name: grade
              value: string
            - name: reason
              value: string
        - name: scoreLabel
          value: string
        - name: grades
          value:
            - - name: gradeName
                value: string
              - name: minScoreThreshold
                value: integer
              - name: maxScoreThreshold
                value: integer
        - name: systemGeneratedEntities
          value: string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string

DELETE example

Deletes the specified predictions resource.

/*+ delete */
DELETE FROM azure_extras.customer_insights.predictions
WHERE hubName = '{{ hubName }}'
AND predictionName = '{{ predictionName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';