express_route_circuit_connections

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

Overview

Name	express_route_circuit_connections
Type	Resource
Id	azure.network.express_route_circuit_connections

Fields

vw_express_route_circuit_connections

Name	Datatype	Description
id	text	Resource ID.
name	text	The name of the resource that is unique within a resource group. This name can be used to access the resource.
address_prefix	text	field from the properties object
authorization_key	text	field from the properties object
circuitName	text	field from the properties object
circuit_connection_status	text	field from the properties object
connectionName	text	field from the properties object
etag	text	A unique read-only string that changes whenever the resource is updated.
express_route_circuit_peering	text	field from the properties object
ipv6_circuit_connection_config	text	field from the properties object
peer_express_route_circuit_peering	text	field from the properties object
peeringName	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
type	text	Type of the resource.

express_route_circuit_connections

Name	Datatype	Description
id	string	Resource ID.
name	string	The name of the resource that is unique within a resource group. This name can be used to access the resource.
etag	string	A unique read-only string that changes whenever the resource is updated.
properties	object	Properties of the express route circuit connection.
type	string	Type of the resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	circuitName, connectionName, peeringName, resourceGroupName, subscriptionId	Gets the specified Express Route Circuit Connection from the specified express route circuit.
list	SELECT	circuitName, peeringName, resourceGroupName, subscriptionId	Gets all global reach connections associated with a private peering in an express route circuit.
create_or_update	INSERT	circuitName, connectionName, peeringName, resourceGroupName, subscriptionId	Creates or updates a Express Route Circuit Connection in the specified express route circuits.
delete	DELETE	circuitName, connectionName, peeringName, resourceGroupName, subscriptionId	Deletes the specified Express Route Circuit Connection from the specified express route circuit.

SELECT examples

Gets all global reach connections associated with a private peering in an express route circuit.

vw_express_route_circuit_connections

SELECT
id,
name,
address_prefix,
authorization_key,
circuitName,
circuit_connection_status,
connectionName,
etag,
express_route_circuit_peering,
ipv6_circuit_connection_config,
peer_express_route_circuit_peering,
peeringName,
provisioning_state,
resourceGroupName,
subscriptionId,
type
FROM azure.network.vw_express_route_circuit_connections
WHERE circuitName = '{{ circuitName }}'
AND peeringName = '{{ peeringName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

express_route_circuit_connections

SELECT
id,
name,
etag,
properties,
type
FROM azure.network.express_route_circuit_connections
WHERE circuitName = '{{ circuitName }}'
AND peeringName = '{{ peeringName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.network.express_route_circuit_connections (
circuitName,
connectionName,
peeringName,
resourceGroupName,
subscriptionId,
properties,
name,
id
)
SELECT 
'{{ circuitName }}',
'{{ connectionName }}',
'{{ peeringName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ name }}',
'{{ id }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: expressRouteCircuitPeering
          value:
            - name: id
              value: string
        - name: addressPrefix
          value: string
        - name: authorizationKey
          value: string
        - name: ipv6CircuitConnectionConfig
          value:
            - name: addressPrefix
              value: string
            - name: circuitConnectionStatus
              value: []
        - name: provisioningState
          value: []
    - name: name
      value: string
    - name: etag
      value: string
    - name: type
      value: string
    - name: id
      value: string

DELETE example

Deletes the specified express_route_circuit_connections resource.

/*+ delete */
DELETE FROM azure.network.express_route_circuit_connections
WHERE circuitName = '{{ circuitName }}'
AND connectionName = '{{ connectionName }}'
AND peeringName = '{{ peeringName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';