express_route_connections

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

Overview

Name	express_route_connections
Type	Resource
Id	azure.network.express_route_connections

Fields

vw_express_route_connections

Name	Datatype	Description
id	text	Resource ID.
name	text	The name of the resource.
authorization_key	text	field from the properties object
connectionName	text	field from the properties object
enable_internet_security	text	field from the properties object
enable_private_link_fast_path	text	field from the properties object
expressRouteGatewayName	text	field from the properties object
express_route_circuit_peering	text	field from the properties object
express_route_gateway_bypass	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
routing_configuration	text	field from the properties object
routing_weight	text	field from the properties object
subscriptionId	text	field from the properties object

express_route_connections

Name	Datatype	Description
id	string	Resource ID.
name	string	The name of the resource.
properties	object	Properties of the ExpressRouteConnection subresource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	connectionName, expressRouteGatewayName, resourceGroupName, subscriptionId	Gets the specified ExpressRouteConnection.
list	SELECT	expressRouteGatewayName, resourceGroupName, subscriptionId	Lists ExpressRouteConnections.
create_or_update	INSERT	connectionName, expressRouteGatewayName, resourceGroupName, subscriptionId, data__name	Creates a connection between an ExpressRoute gateway and an ExpressRoute circuit.
delete	DELETE	connectionName, expressRouteGatewayName, resourceGroupName, subscriptionId	Deletes a connection to a ExpressRoute circuit.

SELECT examples

Lists ExpressRouteConnections.

vw_express_route_connections

SELECT
id,
name,
authorization_key,
connectionName,
enable_internet_security,
enable_private_link_fast_path,
expressRouteGatewayName,
express_route_circuit_peering,
express_route_gateway_bypass,
provisioning_state,
resourceGroupName,
routing_configuration,
routing_weight,
subscriptionId
FROM azure.network.vw_express_route_connections
WHERE expressRouteGatewayName = '{{ expressRouteGatewayName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

express_route_connections

SELECT
id,
name,
properties
FROM azure.network.express_route_connections
WHERE expressRouteGatewayName = '{{ expressRouteGatewayName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

Use the following StackQL query and manifest file to create a new express_route_connections resource.

All Properties

/*+ create */
INSERT INTO azure.network.express_route_connections (
connectionName,
expressRouteGatewayName,
resourceGroupName,
subscriptionId,
data__name,
properties,
name,
id
)
SELECT 
'{{ connectionName }}',
'{{ expressRouteGatewayName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__name }}',
'{{ properties }}',
'{{ name }}',
'{{ id }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: expressRouteCircuitPeering
          value:
            - name: id
              value: string
        - name: authorizationKey
          value: string
        - name: routingWeight
          value: integer
        - name: enableInternetSecurity
          value: boolean
        - name: expressRouteGatewayBypass
          value: boolean
        - name: enablePrivateLinkFastPath
          value: boolean
        - name: routingConfiguration
          value:
            - name: associatedRouteTable
              value:
                - name: id
                  value: string
            - name: propagatedRouteTables
              value:
                - name: labels
                  value:
                    - string
                - name: ids
                  value:
                    - - name: id
                        value: string
            - name: vnetRoutes
              value:
                - name: staticRoutesConfig
                  value:
                    - name: propagateStaticRoutes
                      value: boolean
                    - name: vnetLocalRouteOverrideCriteria
                      value: []
                - name: staticRoutes
                  value:
                    - - name: name
                        value: string
                      - name: addressPrefixes
                        value:
                          - string
                      - name: nextHopIpAddress
                        value: string
                - name: bgpConnections
                  value:
                    - - name: id
                        value: string
    - name: name
      value: string
    - name: id
      value: string

DELETE example

Deletes the specified express_route_connections resource.

/*+ delete */
DELETE FROM azure.network.express_route_connections
WHERE connectionName = '{{ connectionName }}'
AND expressRouteGatewayName = '{{ expressRouteGatewayName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';