Skip to main content

nat_rules

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

Overview

Namenat_rules
TypeResource
Idazure.network.nat_rules

Fields

The following fields are returned by SELECT queries:

Request successful. Returns the details of the nat rule.

NameDatatypeDescription
idstringResource ID.
namestringThe name of the resource that is unique within a resource group. This name can be used to access the resource.
etagstringA unique read-only string that changes whenever the resource is updated.
propertiesobjectProperties of the VpnGateway NAT rule.
typestringResource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, gatewayName, natRuleNameRetrieves the details of a nat ruleGet.
list_by_vpn_gatewayselectsubscriptionId, resourceGroupName, gatewayNameRetrieves all nat rules for a particular virtual wan vpn gateway.
create_or_updateinsertsubscriptionId, resourceGroupName, gatewayName, natRuleNameCreates a nat rule to a scalable vpn gateway if it doesn't exist else updates the existing nat rules.
deletedeletesubscriptionId, resourceGroupName, gatewayName, natRuleNameDeletes a nat 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
gatewayNamestringThe name of the gateway.
natRuleNamestringThe name of the nat rule.
resourceGroupNamestringThe resource group name of the VpnGateway.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Retrieves the details of a nat ruleGet.

SELECT
id,
name,
etag,
properties,
type
FROM azure.network.nat_rules
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND gatewayName = '{{ gatewayName }}' -- required
AND natRuleName = '{{ natRuleName }}' -- required
;

INSERT examples

Creates a nat rule to a scalable vpn gateway if it doesn't exist else updates the existing nat rules.

INSERT INTO azure.network.nat_rules (
data__properties,
data__name,
data__id,
subscriptionId,
resourceGroupName,
gatewayName,
natRuleName
)
SELECT
'{{ properties }}',
'{{ name }}',
'{{ id }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ gatewayName }}',
'{{ natRuleName }}'
RETURNING
id,
name,
etag,
properties,
type
;

DELETE examples

Deletes a nat rule.

DELETE FROM azure.network.nat_rules
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND gatewayName = '{{ gatewayName }}' --required
AND natRuleName = '{{ natRuleName }}' --required
;