Skip to main content

virtual_appliance_connections

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

Overview

Namevirtual_appliance_connections
TypeResource
Idazure.network.virtual_appliance_connections

Fields

The following fields are returned by SELECT queries:

Request successful. Returns the details of the NVA connection

NameDatatypeDescription
idstringResource ID.
namestringThe name of the resource.
propertiesobjectProperties of the express route connection.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, networkVirtualApplianceName, connectionNameRetrieves the details of specified NVA connection.
listselectsubscriptionId, resourceGroupName, networkVirtualApplianceNameLists NetworkVirtualApplianceConnections under the NVA.
create_or_updateinsertsubscriptionId, resourceGroupName, networkVirtualApplianceName, connectionNameCreates a connection to Network Virtual Appliance, if it doesn't exist else updates the existing NVA connection'
deletedeletesubscriptionId, resourceGroupName, networkVirtualApplianceName, connectionNameDeletes a NVA connection.

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
connectionNamestringThe name of the NVA connection.
networkVirtualApplianceNamestringThe name of the Network Virtual Appliance.
resourceGroupNamestringThe name of the resource group.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Retrieves the details of specified NVA connection.

SELECT
id,
name,
properties
FROM azure.network.virtual_appliance_connections
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND networkVirtualApplianceName = '{{ networkVirtualApplianceName }}' -- required
AND connectionName = '{{ connectionName }}' -- required
;

INSERT examples

Creates a connection to Network Virtual Appliance, if it doesn't exist else updates the existing NVA connection'

INSERT INTO azure.network.virtual_appliance_connections (
data__properties,
data__name,
data__id,
subscriptionId,
resourceGroupName,
networkVirtualApplianceName,
connectionName
)
SELECT
'{{ properties }}',
'{{ name }}',
'{{ id }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ networkVirtualApplianceName }}',
'{{ connectionName }}'
RETURNING
id,
name,
properties
;

DELETE examples

Deletes a NVA connection.

DELETE FROM azure.network.virtual_appliance_connections
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND networkVirtualApplianceName = '{{ networkVirtualApplianceName }}' --required
AND connectionName = '{{ connectionName }}' --required
;