profiles

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

Overview

Name	profiles
Type	Resource
Id	azure_extras.customer_insights.profiles

Fields

vw_profiles

Name	Datatype	Description
id	text	Resource ID.
name	text	Resource name.
api_entity_set_name	text	field from the properties object
entity_type	text	field from the properties object
fields	text	field from the properties object
hubName	text	field from the properties object
instances_count	text	field from the properties object
last_changed_utc	text	field from the properties object
profileName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
schema_item_type_link	text	field from the properties object
strong_ids	text	field from the properties object
subscriptionId	text	field from the properties object
tenant_id	text	field from the properties object
timestamp_field_name	text	field from the properties object
type	text	Resource type.
type_name	text	field from the properties object

profiles

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

Methods

Name	Accessible by	Required Params	Description
get	SELECT	hubName, profileName, resourceGroupName, subscriptionId	Gets information about the specified profile.
list_by_hub	SELECT	hubName, resourceGroupName, subscriptionId	Gets all profile in the hub.
create_or_update	INSERT	hubName, profileName, resourceGroupName, subscriptionId	Creates a profile within a Hub, or updates an existing profile.
delete	DELETE	hubName, profileName, resourceGroupName, subscriptionId	Deletes a profile within a hub

SELECT examples

Gets all profile in the hub.

vw_profiles

SELECT
id,
name,
api_entity_set_name,
entity_type,
fields,
hubName,
instances_count,
last_changed_utc,
profileName,
provisioning_state,
resourceGroupName,
schema_item_type_link,
strong_ids,
subscriptionId,
tenant_id,
timestamp_field_name,
type,
type_name
FROM azure_extras.customer_insights.vw_profiles
WHERE hubName = '{{ hubName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

profiles

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

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: strongIds
          value:
            - - name: keyPropertyNames
                value:
                  - string
              - name: strongIdName
                value: string
              - name: displayName
                value: object
              - name: description
                value: object
        - name: apiEntitySetName
          value: string
        - name: entityType
          value: string
        - name: fields
          value:
            - - name: arrayValueSeparator
                value: string
              - name: enumValidValues
                value:
                  - - name: value
                      value: integer
                    - name: localizedValueNames
                      value: object
              - name: fieldName
                value: string
              - name: fieldType
                value: string
              - name: isArray
                value: boolean
              - name: isEnum
                value: boolean
              - name: isFlagEnum
                value: boolean
              - name: isImage
                value: boolean
              - name: isLocalizedString
                value: boolean
              - name: isName
                value: boolean
              - name: isRequired
                value: boolean
              - name: propertyId
                value: string
              - name: schemaItemPropLink
                value: string
              - name: maxLength
                value: integer
              - name: isAvailableInGraph
                value: boolean
              - name: dataSourcePrecedenceRules
                value:
                  - - name: dataSource
                      value:
                        - name: name
                          value: string
                        - name: dataSourceType
                          value: string
                        - name: status
                          value: string
                        - name: id
                          value: integer
                        - name: dataSourceReferenceId
                          value: string
                    - name: precedence
                      value: integer
        - name: instancesCount
          value: integer
        - name: lastChangedUtc
          value: string
        - name: provisioningState
          value: []
        - name: schemaItemTypeLink
          value: string
        - name: tenantId
          value: string
        - name: timestampFieldName
          value: string
        - name: typeName
          value: string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string

DELETE example

Deletes the specified profiles resource.

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