access_policies

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

Overview

Name	access_policies
Type	Resource
Id	azure_isv.redis.access_policies

Fields

vw_access_policies

Name	Datatype	Description
accessPolicyName	text	field from the properties object
cacheName	text	field from the properties object
permissions	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	field from the properties object

access_policies

Name	Datatype	Description
properties	object	All properties of an access policy.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accessPolicyName, cacheName, resourceGroupName, subscriptionId	Gets the detailed information about an access policy of a redis cache
list	SELECT	cacheName, resourceGroupName, subscriptionId	Gets the list of access policies associated with this redis cache
create_update	INSERT	accessPolicyName, cacheName, resourceGroupName, subscriptionId	Adds an access policy to the redis cache
delete	DELETE	accessPolicyName, cacheName, resourceGroupName, subscriptionId	Deletes the access policy from a redis cache

SELECT examples

Gets the list of access policies associated with this redis cache

vw_access_policies

SELECT
accessPolicyName,
cacheName,
permissions,
provisioning_state,
resourceGroupName,
subscriptionId,
type
FROM azure_isv.redis.vw_access_policies
WHERE cacheName = '{{ cacheName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

access_policies

SELECT
properties
FROM azure_isv.redis.access_policies
WHERE cacheName = '{{ cacheName }}'
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_isv.redis.access_policies (
accessPolicyName,
cacheName,
resourceGroupName,
subscriptionId,
properties
)
SELECT 
'{{ accessPolicyName }}',
'{{ cacheName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: string
        - name: type
          value: string
        - name: permissions
          value: string

DELETE example

Deletes the specified access_policies resource.

/*+ delete */
DELETE FROM azure_isv.redis.access_policies
WHERE accessPolicyName = '{{ accessPolicyName }}'
AND cacheName = '{{ cacheName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';