Skip to main content

express_route_connections

Creates, updates, deletes, gets or lists an express_route_connections resource.

Overview

Nameexpress_route_connections
TypeResource
Idazure.network.express_route_connections

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringResource ID.
namestringThe name of the resource. Required.
authorizationKeystringAuthorization key to establish the connection.
enableInternetSecuritybooleanEnable internet security.
enablePrivateLinkFastPathbooleanBypass the ExpressRoute gateway when accessing private-links. ExpressRoute FastPath (expressRouteGatewayBypass) must be enabled.
expressRouteCircuitPeeringobjectThe ExpressRoute circuit peering. Required.
expressRouteGatewayBypassbooleanEnable FastPath to vWan Firewall hub.
provisioningStatestringThe provisioning state of the express route connection 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.
routingWeightintegerThe routing weight associated to the connection.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, express_route_gateway_name, connection_name, subscription_idGets the specified ExpressRouteConnection.
listselectresource_group_name, express_route_gateway_name, subscription_idLists ExpressRouteConnections.
create_or_updateinsertresource_group_name, express_route_gateway_name, connection_name, subscription_id, nameCreates a connection between an ExpressRoute gateway and an ExpressRoute circuit.
create_or_updatereplaceresource_group_name, express_route_gateway_name, connection_name, subscription_id, nameCreates a connection between an ExpressRoute gateway and an ExpressRoute circuit.
deletedeleteresource_group_name, express_route_gateway_name, connection_name, subscription_idDeletes a connection to a ExpressRoute circuit.

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_namestringThe name of the express route connection. Required.
express_route_gateway_namestringThe name of the express route gateway. Required.
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
subscription_idstring

SELECT examples

Gets the specified ExpressRouteConnection.

SELECT
id,
name,
authorizationKey,
enableInternetSecurity,
enablePrivateLinkFastPath,
expressRouteCircuitPeering,
expressRouteGatewayBypass,
provisioningState,
routingConfiguration,
routingWeight
FROM azure.network.express_route_connections
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND express_route_gateway_name = '{{ express_route_gateway_name }}' -- required
AND connection_name = '{{ connection_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates a connection between an ExpressRoute gateway and an ExpressRoute circuit.

INSERT INTO azure.network.express_route_connections (
id,
properties,
name,
resource_group_name,
express_route_gateway_name,
connection_name,
subscription_id
)
SELECT
'{{ id }}',
'{{ properties }}',
'{{ name }}' /* required */,
'{{ resource_group_name }}',
'{{ express_route_gateway_name }}',
'{{ connection_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
properties
;

REPLACE examples

Creates a connection between an ExpressRoute gateway and an ExpressRoute circuit.

REPLACE azure.network.express_route_connections
SET
id = '{{ id }}',
properties = '{{ properties }}',
name = '{{ name }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND express_route_gateway_name = '{{ express_route_gateway_name }}' --required
AND connection_name = '{{ connection_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
AND name = '{{ name }}' --required
RETURNING
id,
name,
properties;

DELETE examples

Deletes a connection to a ExpressRoute circuit.

DELETE FROM azure.network.express_route_connections
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND express_route_gateway_name = '{{ express_route_gateway_name }}' --required
AND connection_name = '{{ connection_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;