user_assigned_identities

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

Overview

Name	user_assigned_identities
Type	Resource
Id	azure.managed_identity.user_assigned_identities

Fields

Name	Datatype	Description
principalId	string	The principal ID of resource identity. The value must be an UUID.
tenantId	string	The tenant ID of resource. The value must be an UUID.
type	string	The identity type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, resourceName, subscriptionId	Gets the identity.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Lists all the userAssignedIdentities available under the specified ResourceGroup.
list_by_subscription	SELECT	subscriptionId	Lists all the userAssignedIdentities available under the specified subscription.
create_or_update	INSERT	resourceGroupName, resourceName, subscriptionId	Create or update an identity in the specified subscription and resource group.
delete	DELETE	resourceGroupName, resourceName, subscriptionId	Deletes the identity.
update	UPDATE	resourceGroupName, resourceName, subscriptionId	Update an identity in the specified subscription and resource group.

SELECT examples

Lists all the userAssignedIdentities available under the specified subscription.

SELECT
principalId,
tenantId,
type
FROM azure.managed_identity.user_assigned_identities
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.managed_identity.user_assigned_identities (
resourceGroupName,
resourceName,
subscriptionId,
type
)
SELECT 
'{{ resourceGroupName }}',
'{{ resourceName }}',
'{{ subscriptionId }}',
'{{ type }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: principalId
      value: string
    - name: tenantId
      value: string
    - name: type
      value: string

UPDATE example

Updates a user_assigned_identities resource.

/*+ update */
UPDATE azure.managed_identity.user_assigned_identities
SET 
location = '{{ location }}',
tags = '{{ tags }}'
WHERE 
resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified user_assigned_identities resource.

/*+ delete */
DELETE FROM azure.managed_identity.user_assigned_identities
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND resourceName = '{{ resourceName }}'
AND subscriptionId = '{{ subscriptionId }}';