Skip to main content

connection_policies

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

Overview

Nameconnection_policies
TypeResource
Idazure.network.connection_policies

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringResource ID.
namestringResource name.
associatedConnectionsarrayList of connection names (e.g. VpnConnection, HubVirtualNetworkConnection) associated with this ConnectionPolicy. These are resource names, not Azure resource IDs, consistent with the established VirtualWAN pattern used by HubRouteTable.associatedConnections.
enableInternetSecuritybooleanEnable internet security.
etagstringA unique read-only string that changes whenever the resource is updated.
provisioningStatestringThe provisioning state of the ConnectionPolicy resource. Known values are: "Failed", "Succeeded", "Canceled", "Creating", "Updating", and "Deleting". (Failed, Succeeded, Canceled, Creating, Updating, Deleting)
routingConfigurationobjectThe Routing Configuration indicating the associated and propagated route tables on this connection.
typestringResource type.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, virtual_hub_name, connection_policy_name, subscription_idRetrieves the details of a ConnectionPolicy.
listselectresource_group_name, virtual_hub_name, subscription_idRetrieves the details of all ConnectionPolicies.
create_or_updateinsertresource_group_name, virtual_hub_name, connection_policy_name, subscription_idCreates a ConnectionPolicy if it doesn't exist else updates the existing one.
create_or_updatereplaceresource_group_name, virtual_hub_name, connection_policy_name, subscription_idCreates a ConnectionPolicy if it doesn't exist else updates the existing one.
deletedeleteresource_group_name, virtual_hub_name, connection_policy_name, subscription_idDeletes a ConnectionPolicy.

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
connection_policy_namestringThe name of the ConnectionPolicy that is unique within a VirtualHub. This name can be used to access the resource. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring
virtual_hub_namestringThe name of the VirtualHub. Required.

SELECT examples

Retrieves the details of a ConnectionPolicy.

SELECT
id,
name,
associatedConnections,
enableInternetSecurity,
etag,
provisioningState,
routingConfiguration,
type
FROM azure.network.connection_policies
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND virtual_hub_name = '{{ virtual_hub_name }}' -- required
AND connection_policy_name = '{{ connection_policy_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates a ConnectionPolicy if it doesn't exist else updates the existing one.

INSERT INTO azure.network.connection_policies (
id,
properties,
resource_group_name,
virtual_hub_name,
connection_policy_name,
subscription_id
)
SELECT
'{{ id }}',
'{{ properties }}',
'{{ resource_group_name }}',
'{{ virtual_hub_name }}',
'{{ connection_policy_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
etag,
properties,
type
;

REPLACE examples

Creates a ConnectionPolicy if it doesn't exist else updates the existing one.

REPLACE azure.network.connection_policies
SET
id = '{{ id }}',
properties = '{{ properties }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND virtual_hub_name = '{{ virtual_hub_name }}' --required
AND connection_policy_name = '{{ connection_policy_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
etag,
properties,
type;

DELETE examples

Deletes a ConnectionPolicy.

DELETE FROM azure.network.connection_policies
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND virtual_hub_name = '{{ virtual_hub_name }}' --required
AND connection_policy_name = '{{ connection_policy_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;