role_assignments

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

Overview

Name	role_assignments
Type	Resource
Id	azure_extras.customer_insights.role_assignments

Fields

vw_role_assignments

Name	Datatype	Description
id	text	Resource ID.
name	text	Resource name.
description	text	field from the properties object
assignmentName	text	field from the properties object
assignment_name	text	field from the properties object
conflation_policies	text	field from the properties object
connectors	text	field from the properties object
display_name	text	field from the properties object
hubName	text	field from the properties object
interactions	text	field from the properties object
kpis	text	field from the properties object
links	text	field from the properties object
principals	text	field from the properties object
profiles	text	field from the properties object
provisioning_state	text	field from the properties object
relationship_links	text	field from the properties object
relationships	text	field from the properties object
resourceGroupName	text	field from the properties object
role	text	field from the properties object
role_assignments	text	field from the properties object
sas_policies	text	field from the properties object
segments	text	field from the properties object
subscriptionId	text	field from the properties object
tenant_id	text	field from the properties object
type	text	Resource type.
views	text	field from the properties object
widget_types	text	field from the properties object

role_assignments

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

Methods

Name	Accessible by	Required Params	Description
get	SELECT	assignmentName, hubName, resourceGroupName, subscriptionId	Gets the role assignment in the hub.
list_by_hub	SELECT	hubName, resourceGroupName, subscriptionId	Gets all the role assignments for the specified hub.
create_or_update	INSERT	assignmentName, hubName, resourceGroupName, subscriptionId	Creates or updates a role assignment in the hub.
delete	DELETE	assignmentName, hubName, resourceGroupName, subscriptionId	Deletes the role assignment in the hub.

SELECT examples

Gets all the role assignments for the specified hub.

vw_role_assignments

SELECT
id,
name,
description,
assignmentName,
assignment_name,
conflation_policies,
connectors,
display_name,
hubName,
interactions,
kpis,
links,
principals,
profiles,
provisioning_state,
relationship_links,
relationships,
resourceGroupName,
role,
role_assignments,
sas_policies,
segments,
subscriptionId,
tenant_id,
type,
views,
widget_types
FROM azure_extras.customer_insights.vw_role_assignments
WHERE hubName = '{{ hubName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

role_assignments

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

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: tenantId
          value: string
        - name: assignmentName
          value: string
        - name: displayName
          value: object
        - name: description
          value: object
        - name: provisioningState
          value: []
        - name: role
          value: string
        - name: principals
          value:
            - - name: principalId
                value: string
              - name: principalType
                value: string
              - name: principalMetadata
                value: object
        - name: profiles
          value:
            - name: elements
              value:
                - string
            - name: exceptions
              value:
                - string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string

DELETE example

Deletes the specified role_assignments resource.

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