accounts

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

Overview

Name	accounts
Type	Resource
Id	azure_extras.video_indexer.accounts

Fields

vw_accounts

Name	Datatype	Description
accountName	text	field from the properties object
account_id	text	field from the properties object
account_name	text	field from the properties object
identity	text	Managed service identity (system assigned and/or user assigned identities)
location	text	The geo-location where the resource lives
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
storage_services	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
tags	text	Resource tags.
tenant_id	text	field from the properties object
total_seconds_indexed	text	field from the properties object

accounts

Name	Datatype	Description
identity	object	Managed service identity (system assigned and/or user assigned identities)
location	string	The geo-location where the resource lives
properties	object	Azure Video Indexer account properties
systemData	object	Metadata pertaining to creation and last modification of the resource.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, resourceGroupName, subscriptionId	Gets the properties of an Azure Video Indexer account.
list	SELECT	subscriptionId	List all Azure Video Indexer accounts available under the subscription
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List all Azure Video Indexer accounts available under the resource group
create_or_update	INSERT	accountName, resourceGroupName, subscriptionId	Creates or updates an Azure Video Indexer account.
delete	DELETE	accountName, resourceGroupName, subscriptionId	Delete an Azure Video Indexer account.
update	UPDATE	accountName, resourceGroupName, subscriptionId	Updates the properties of an existing Azure Video Indexer account.
check_name_availability	EXEC	subscriptionId, data__name, data__type	Checks that the Video Indexer account name is valid and is not already in use.

SELECT examples

List all Azure Video Indexer accounts available under the subscription

vw_accounts

SELECT
accountName,
account_id,
account_name,
identity,
location,
provisioning_state,
resourceGroupName,
storage_services,
subscriptionId,
system_data,
tags,
tenant_id,
total_seconds_indexed
FROM azure_extras.video_indexer.vw_accounts
WHERE subscriptionId = '{{ subscriptionId }}';

accounts

SELECT
identity,
location,
properties,
systemData,
tags
FROM azure_extras.video_indexer.accounts
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_extras.video_indexer.accounts (
accountName,
resourceGroupName,
subscriptionId,
properties,
identity,
tags,
location
)
SELECT 
'{{ accountName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ identity }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: tenantId
          value: string
        - name: accountId
          value: string
        - name: accountName
          value: string
        - name: storageServices
          value:
            - name: resourceId
              value: string
            - name: userAssignedIdentity
              value: string
        - name: totalSecondsIndexed
          value: integer
        - name: provisioningState
          value: string
    - name: identity
      value:
        - name: principalId
          value: string
        - name: tenantId
          value: string
        - name: type
          value: []
        - name: userAssignedIdentities
          value: []
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a accounts resource.

/*+ update */
UPDATE azure_extras.video_indexer.accounts
SET 
properties = '{{ properties }}',
identity = '{{ identity }}',
tags = '{{ tags }}'
WHERE 
accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified accounts resource.

/*+ delete */
DELETE FROM azure_extras.video_indexer.accounts
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';