firewall_rules

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

Overview

Name	firewall_rules
Type	Resource
Id	azure_isv.mongo_db.firewall_rules

Fields

vw_firewall_rules

Name	Datatype	Description
end_ip_address	text	field from the properties object
firewallRuleName	text	field from the properties object
mongoClusterName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
start_ip_address	text	field from the properties object
subscriptionId	text	field from the properties object

firewall_rules

Name	Datatype	Description
properties	object	The properties of a mongo cluster firewall rule.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	firewallRuleName, mongoClusterName, resourceGroupName, subscriptionId	Gets information about a mongo cluster firewall rule.
list_by_mongo_cluster	SELECT	mongoClusterName, resourceGroupName, subscriptionId	List all the firewall rules in a given mongo cluster.
create_or_update	INSERT	firewallRuleName, mongoClusterName, resourceGroupName, subscriptionId	Creates a new firewall rule or updates an existing firewall rule on a mongo cluster.
delete	DELETE	firewallRuleName, mongoClusterName, resourceGroupName, subscriptionId	Deletes a mongo cluster firewall rule.

SELECT examples

List all the firewall rules in a given mongo cluster.

vw_firewall_rules

SELECT
end_ip_address,
firewallRuleName,
mongoClusterName,
provisioning_state,
resourceGroupName,
start_ip_address,
subscriptionId
FROM azure_isv.mongo_db.vw_firewall_rules
WHERE mongoClusterName = '{{ mongoClusterName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

firewall_rules

SELECT
properties
FROM azure_isv.mongo_db.firewall_rules
WHERE mongoClusterName = '{{ mongoClusterName }}'
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.mongo_db.firewall_rules (
firewallRuleName,
mongoClusterName,
resourceGroupName,
subscriptionId,
properties
)
SELECT 
'{{ firewallRuleName }}',
'{{ mongoClusterName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: startIpAddress
          value: string
        - name: endIpAddress
          value: string

DELETE example

Deletes the specified firewall_rules resource.

/*+ delete */
DELETE FROM azure_isv.mongo_db.firewall_rules
WHERE firewallRuleName = '{{ firewallRuleName }}'
AND mongoClusterName = '{{ mongoClusterName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';