Skip to main content

express_route_cross_connections

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

Overview

Nameexpress_route_cross_connections
TypeResource
Idazure.network.express_route_cross_connections

Fields

NameDatatypeDescription
idtextResource ID.
nametextResource name.
bandwidth_in_mbpstextfield from the properties object
crossConnectionNametextfield from the properties object
etagtextA unique read-only string that changes whenever the resource is updated.
express_route_circuittextfield from the properties object
locationtextResource location.
peering_locationtextfield from the properties object
peeringstextfield from the properties object
primary_azure_porttextfield from the properties object
provisioning_statetextfield from the properties object
resourceGroupNametextfield from the properties object
s_tagtextfield from the properties object
secondary_azure_porttextfield from the properties object
service_provider_notestextfield from the properties object
service_provider_provisioning_statetextfield from the properties object
subscriptionIdtextfield from the properties object
tagstextResource tags.
typetextResource type.

Methods

NameAccessible byRequired ParamsDescription
getSELECTcrossConnectionName, resourceGroupName, subscriptionIdGets details about the specified ExpressRouteCrossConnection.
listSELECTsubscriptionIdRetrieves all the ExpressRouteCrossConnections in a subscription.
list_by_resource_groupSELECTresourceGroupName, subscriptionIdRetrieves all the ExpressRouteCrossConnections in a resource group.
create_or_updateINSERTcrossConnectionName, resourceGroupName, subscriptionIdUpdate the specified ExpressRouteCrossConnection.
update_tagsEXECcrossConnectionName, resourceGroupName, subscriptionIdUpdates an express route cross connection tags.

SELECT examples

Retrieves all the ExpressRouteCrossConnections in a subscription.

SELECT
id,
name,
bandwidth_in_mbps,
crossConnectionName,
etag,
express_route_circuit,
location,
peering_location,
peerings,
primary_azure_port,
provisioning_state,
resourceGroupName,
s_tag,
secondary_azure_port,
service_provider_notes,
service_provider_provisioning_state,
subscriptionId,
tags,
type
FROM azure.network.vw_express_route_cross_connections
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

/*+ create */
INSERT INTO azure.network.express_route_cross_connections (
crossConnectionName,
resourceGroupName,
subscriptionId,
properties,
id,
location,
tags
)
SELECT
'{{ crossConnectionName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ id }}',
'{{ location }}',
'{{ tags }}'
;