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

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
propertiesobjectThe resource-specific properties for this resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, mongoClusterName, firewallRuleNameGets information about a mongo cluster firewall rule.
list_by_mongo_clusterselectsubscriptionId, resourceGroupName, mongoClusterNameList all the firewall rules in a given mongo cluster.
create_or_updateinsertsubscriptionId, resourceGroupName, mongoClusterName, firewallRuleNameCreates a new firewall rule or updates an existing firewall rule on a mongo cluster.
deletedeletesubscriptionId, resourceGroupName, mongoClusterName, firewallRuleNameDeletes a mongo cluster firewall rule.

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
firewallRuleNamestringThe name of the mongo cluster firewall rule.
mongoClusterNamestringThe name of the mongo cluster.
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Gets information about a mongo cluster firewall rule.

SELECT
properties
FROM azure_isv.mongo_db.firewall_rules
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND mongoClusterName = '{{ mongoClusterName }}' -- required
AND firewallRuleName = '{{ firewallRuleName }}' -- required
;

INSERT examples

Creates a new firewall rule or updates an existing firewall rule on a mongo cluster.

INSERT INTO azure_isv.mongo_db.firewall_rules (
data__properties,
subscriptionId,
resourceGroupName,
mongoClusterName,
firewallRuleName
)
SELECT
'{{ properties }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ mongoClusterName }}',
'{{ firewallRuleName }}'
RETURNING
properties
;

DELETE examples

Deletes a mongo cluster firewall rule.

DELETE FROM azure_isv.mongo_db.firewall_rules
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND mongoClusterName = '{{ mongoClusterName }}' --required
AND firewallRuleName = '{{ firewallRuleName }}' --required
;