Skip to main content

role_assignments

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

Overview

Namerole_assignments
TypeResource
Idazure_extras.customer_insights.role_assignments

Fields

The following fields are returned by SELECT queries:

OK. Successfully get the role assignment.

NameDatatypeDescription
idstringResource ID.
namestringResource name.
propertiesobjectThe Role Assignment definition.
typestringResource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, hubName, assignmentName, subscriptionIdGets the role assignment in the hub.
list_by_hubselectresourceGroupName, hubName, subscriptionIdGets all the role assignments for the specified hub.
create_or_updateinsertresourceGroupName, hubName, assignmentName, subscriptionIdCreates or updates a role assignment in the hub.
deletedeleteresourceGroupName, hubName, assignmentName, subscriptionIdDeletes the role assignment in the hub.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
assignmentNamestringThe name of the role assignment.
hubNamestringThe name of the hub.
resourceGroupNamestringThe name of the resource group.
subscriptionIdstringGets subscription credentials which uniquely identify Microsoft Azure subscription. The subscription ID forms part of the URI for every service call.

SELECT examples

Gets the role assignment in the hub.

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

INSERT examples

Creates or updates a role assignment in the hub.

INSERT INTO azure_extras.customer_insights.role_assignments (
data__properties,
resourceGroupName,
hubName,
assignmentName,
subscriptionId
)
SELECT
'{{ properties }}',
'{{ resourceGroupName }}',
'{{ hubName }}',
'{{ assignmentName }}',
'{{ subscriptionId }}'
RETURNING
id,
name,
properties,
type
;

DELETE examples

Deletes the role assignment in the hub.

DELETE FROM azure_extras.customer_insights.role_assignments
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND hubName = '{{ hubName }}' --required
AND assignmentName = '{{ assignmentName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;