access_policies

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

Overview

Name	access_policies
Type	Resource
Id	azure.video_analyzer.access_policies

Fields

vw_access_policies

Name	Datatype	Description
accessPolicyName	text	field from the properties object
accountName	text	field from the properties object
authentication	text	field from the properties object
resourceGroupName	text	field from the properties object
role	text	field from the properties object
subscriptionId	text	field from the properties object

access_policies

Name	Datatype	Description
properties	object	Application level properties for the access policy resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accessPolicyName, accountName, resourceGroupName, subscriptionId	Retrieves an existing access policy resource with the given name.
list	SELECT	accountName, resourceGroupName, subscriptionId	Retrieves all existing access policy resources, along with their JSON representations.
create_or_update	INSERT	accessPolicyName, accountName, resourceGroupName, subscriptionId	Creates a new access policy resource or updates an existing one with the given name.
delete	DELETE	accessPolicyName, accountName, resourceGroupName, subscriptionId	Deletes an existing access policy resource with the given name.
update	UPDATE	accessPolicyName, accountName, resourceGroupName, subscriptionId	Updates individual properties of an existing access policy resource with the given name.

SELECT examples

Retrieves all existing access policy resources, along with their JSON representations.

vw_access_policies

SELECT
accessPolicyName,
accountName,
authentication,
resourceGroupName,
role,
subscriptionId
FROM azure.video_analyzer.vw_access_policies
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

access_policies

SELECT
properties
FROM azure.video_analyzer.access_policies
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.video_analyzer.access_policies (
accessPolicyName,
accountName,
resourceGroupName,
subscriptionId,
properties
)
SELECT 
'{{ accessPolicyName }}',
'{{ accountName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: role
          value: string
        - name: authentication
          value:
            - name: '@type'
              value: string

UPDATE example

Updates a access_policies resource.

/*+ update */
UPDATE azure.video_analyzer.access_policies
SET 
properties = '{{ properties }}'
WHERE 
accessPolicyName = '{{ accessPolicyName }}'
AND accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified access_policies resource.

/*+ delete */
DELETE FROM azure.video_analyzer.access_policies
WHERE accessPolicyName = '{{ accessPolicyName }}'
AND accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';