Skip to main content

firewall_rules

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

Overview

Namefirewall_rules
TypeResource
Idazure_isv.mongo_db.firewall_rules

Fields

NameDatatypeDescription
end_ip_addresstextfield from the properties object
firewallRuleNametextfield from the properties object
mongoClusterNametextfield from the properties object
provisioning_statetextfield from the properties object
resourceGroupNametextfield from the properties object
start_ip_addresstextfield from the properties object
subscriptionIdtextfield from the properties object

Methods

NameAccessible byRequired ParamsDescription
getSELECTfirewallRuleName, mongoClusterName, resourceGroupName, subscriptionIdGets information about a mongo cluster firewall rule.
list_by_mongo_clusterSELECTmongoClusterName, resourceGroupName, subscriptionIdList all the firewall rules in a given mongo cluster.
create_or_updateINSERTfirewallRuleName, mongoClusterName, resourceGroupName, subscriptionIdCreates a new firewall rule or updates an existing firewall rule on a mongo cluster.
deleteDELETEfirewallRuleName, mongoClusterName, resourceGroupName, subscriptionIdDeletes a mongo cluster firewall rule.

SELECT examples

List all the firewall rules in a given mongo cluster.

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 }}';

INSERT example

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

/*+ create */
INSERT INTO azure_isv.mongo_db.firewall_rules (
firewallRuleName,
mongoClusterName,
resourceGroupName,
subscriptionId,
properties
)
SELECT
'{{ firewallRuleName }}',
'{{ mongoClusterName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

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 }}';