access_policies

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

Overview

Name	access_policies
Type	Resource
Id	azure.time_series_insights.access_policies

Fields

vw_access_policies

Name	Datatype	Description
id	text	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	text	The name of the resource
description	text	field from the properties object
accessPolicyName	text	field from the properties object
environmentName	text	field from the properties object
principal_object_id	text	field from the properties object
resourceGroupName	text	field from the properties object
roles	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

access_policies

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	string	The name of the resource
properties	object
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accessPolicyName, environmentName, resourceGroupName, subscriptionId	Gets the access policy with the specified name in the specified environment.
list_by_environment	SELECT	environmentName, resourceGroupName, subscriptionId	Lists all the available access policies associated with the environment.
create_or_update	INSERT	accessPolicyName, environmentName, resourceGroupName, subscriptionId, data__properties	Create or update an access policy in the specified environment.
delete	DELETE	accessPolicyName, environmentName, resourceGroupName, subscriptionId	Deletes the access policy with the specified name in the specified subscription, resource group, and environment
update	UPDATE	accessPolicyName, environmentName, resourceGroupName, subscriptionId	Updates the access policy with the specified name in the specified subscription, resource group, and environment.

SELECT examples

Lists all the available access policies associated with the environment.

vw_access_policies

SELECT
id,
name,
description,
accessPolicyName,
environmentName,
principal_object_id,
resourceGroupName,
roles,
subscriptionId,
type
FROM azure.time_series_insights.vw_access_policies
WHERE environmentName = '{{ environmentName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

access_policies

SELECT
id,
name,
properties,
type
FROM azure.time_series_insights.access_policies
WHERE environmentName = '{{ environmentName }}'
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.time_series_insights.access_policies (
accessPolicyName,
environmentName,
resourceGroupName,
subscriptionId,
data__properties,
properties
)
SELECT 
'{{ accessPolicyName }}',
'{{ environmentName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: principalObjectId
          value: string
        - name: description
          value: string
        - name: roles
          value:
            - string

UPDATE example

Updates a access_policies resource.

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

DELETE example

Deletes the specified access_policies resource.

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