firewall_rules

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

Overview

Name	firewall_rules
Type	Resource
Id	azure_isv.redis.firewall_rules

Fields

vw_firewall_rules

Name	Datatype	Description
cacheName	text	field from the properties object
end_ip	text	field from the properties object
resourceGroupName	text	field from the properties object
ruleName	text	field from the properties object
start_ip	text	field from the properties object
subscriptionId	text	field from the properties object

firewall_rules

Name	Datatype	Description
properties	object	Specifies a range of IP addresses permitted to connect to the cache

Methods

Name	Accessible by	Required Params	Description
get	SELECT	cacheName, resourceGroupName, ruleName, subscriptionId	Gets a single firewall rule in a specified redis cache.
list	SELECT	cacheName, resourceGroupName, subscriptionId	Gets all firewall rules in the specified redis cache.
create_or_update	INSERT	cacheName, resourceGroupName, ruleName, subscriptionId, data__properties	Create or update a redis cache firewall rule
delete	DELETE	cacheName, resourceGroupName, ruleName, subscriptionId	Deletes a single firewall rule in a specified redis cache.

SELECT examples

Gets all firewall rules in the specified redis cache.

vw_firewall_rules

SELECT
cacheName,
end_ip,
resourceGroupName,
ruleName,
start_ip,
subscriptionId
FROM azure_isv.redis.vw_firewall_rules
WHERE cacheName = '{{ cacheName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

firewall_rules

SELECT
properties
FROM azure_isv.redis.firewall_rules
WHERE cacheName = '{{ cacheName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_isv.redis.firewall_rules (
cacheName,
resourceGroupName,
ruleName,
subscriptionId,
data__properties,
properties
)
SELECT 
'{{ cacheName }}',
'{{ resourceGroupName }}',
'{{ ruleName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: startIP
          value: string
        - name: endIP
          value: string

DELETE example

Deletes the specified firewall_rules resource.

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