Skip to main content

virtual_network_gateway_nat_rules

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

Overview

Namevirtual_network_gateway_nat_rules
TypeResource
Idazure.network.virtual_network_gateway_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 Virtual Network Gateway NAT rule.
typestringResource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, virtualNetworkGatewayName, natRuleNameRetrieves the details of a nat rule.
list_by_virtual_network_gatewayselectsubscriptionId, resourceGroupName, virtualNetworkGatewayNameRetrieves all nat rules for a particular virtual network gateway.
create_or_updateinsertsubscriptionId, resourceGroupName, virtualNetworkGatewayName, natRuleNameCreates a nat rule to a scalable virtual network gateway if it doesn't exist else updates the existing nat rules.
deletedeletesubscriptionId, resourceGroupName, virtualNetworkGatewayName, 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
natRuleNamestringThe name of the nat rule.
resourceGroupNamestringThe resource group name of the Virtual Network Gateway.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.
virtualNetworkGatewayNamestringThe name of the gateway.

SELECT examples

Retrieves the details of a nat rule.

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

INSERT examples

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

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

DELETE examples

Deletes a nat rule.

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