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
;