Skip to main content

access_policies

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

Overview

Nameaccess_policies
TypeResource
Idazure_isv.redis.access_policies

Fields

The following fields are returned by SELECT queries:

Response of get access policy.

NameDatatypeDescription
propertiesobjectProperties of an access policy.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, cacheName, accessPolicyName, subscriptionIdGets the detailed information about an access policy of a redis cache
listselectresourceGroupName, cacheName, subscriptionIdGets the list of access policies associated with this redis cache
create_updateinsertresourceGroupName, cacheName, accessPolicyName, subscriptionIdAdds an access policy to the redis cache
deletedeleteresourceGroupName, cacheName, accessPolicyName, subscriptionIdDeletes the access policy from a redis cache

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
accessPolicyNamestringThe name of the access policy that is being added to the Redis cache.
cacheNamestringThe name of the Redis cache.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Gets the detailed information about an access policy of a redis cache

SELECT
properties
FROM azure_isv.redis.access_policies
WHERE resourceGroupName = '{{ resourceGroupName }}' -- required
AND cacheName = '{{ cacheName }}' -- required
AND accessPolicyName = '{{ accessPolicyName }}' -- required
AND subscriptionId = '{{ subscriptionId }}' -- required
;

INSERT examples

Adds an access policy to the redis cache

INSERT INTO azure_isv.redis.access_policies (
data__properties,
resourceGroupName,
cacheName,
accessPolicyName,
subscriptionId
)
SELECT
'{{ properties }}',
'{{ resourceGroupName }}',
'{{ cacheName }}',
'{{ accessPolicyName }}',
'{{ subscriptionId }}'
RETURNING
properties
;

DELETE examples

Deletes the access policy from a redis cache

DELETE FROM azure_isv.redis.access_policies
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND cacheName = '{{ cacheName }}' --required
AND accessPolicyName = '{{ accessPolicyName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;