Skip to main content

virtual_hub_route_table_v2s

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

Overview

Namevirtual_hub_route_table_v2s
TypeResource
Idazure.network.virtual_hub_route_table_v2s

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringResource ID.
namestringThe name of the resource that is unique within a resource group. This name can be used to access the resource.
attachedConnectionsarrayList of all connections attached to this route table v2.
etagstringA unique read-only string that changes whenever the resource is updated.
provisioningStatestringThe provisioning state of the virtual hub route table v2 resource. Known values are: "Failed", "Succeeded", "Canceled", "Creating", "Updating", and "Deleting". (Failed, Succeeded, Canceled, Creating, Updating, Deleting)
routesarrayList of all routes.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_group_name, virtual_hub_name, route_table_name, subscription_idRetrieves the details of a VirtualHubRouteTableV2.
listselectresource_group_name, virtual_hub_name, subscription_idRetrieves the details of all VirtualHubRouteTableV2s.
create_or_updateinsertresource_group_name, virtual_hub_name, route_table_name, subscription_idCreates a VirtualHubRouteTableV2 resource if it doesn't exist else updates the existing VirtualHubRouteTableV2.
create_or_updatereplaceresource_group_name, virtual_hub_name, route_table_name, subscription_idCreates a VirtualHubRouteTableV2 resource if it doesn't exist else updates the existing VirtualHubRouteTableV2.
deletedeleteresource_group_name, virtual_hub_name, route_table_name, subscription_idDeletes a VirtualHubRouteTableV2.

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
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
route_table_namestringThe name of the VirtualHubRouteTableV2. Required.
subscription_idstring
virtual_hub_namestringThe name of the Virtual Hub. Required.

SELECT examples

Retrieves the details of a VirtualHubRouteTableV2.

SELECT
id,
name,
attachedConnections,
etag,
provisioningState,
routes
FROM azure.network.virtual_hub_route_table_v2s
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND virtual_hub_name = '{{ virtual_hub_name }}' -- required
AND route_table_name = '{{ route_table_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

INSERT examples

Creates a VirtualHubRouteTableV2 resource if it doesn't exist else updates the existing VirtualHubRouteTableV2.

INSERT INTO azure.network.virtual_hub_route_table_v2s (
id,
properties,
name,
resource_group_name,
virtual_hub_name,
route_table_name,
subscription_id
)
SELECT
'{{ id }}',
'{{ properties }}',
'{{ name }}',
'{{ resource_group_name }}',
'{{ virtual_hub_name }}',
'{{ route_table_name }}',
'{{ subscription_id }}'
RETURNING
id,
name,
etag,
properties
;

REPLACE examples

Creates a VirtualHubRouteTableV2 resource if it doesn't exist else updates the existing VirtualHubRouteTableV2.

REPLACE azure.network.virtual_hub_route_table_v2s
SET
id = '{{ id }}',
properties = '{{ properties }}',
name = '{{ name }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND virtual_hub_name = '{{ virtual_hub_name }}' --required
AND route_table_name = '{{ route_table_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
RETURNING
id,
name,
etag,
properties;

DELETE examples

Deletes a VirtualHubRouteTableV2.

DELETE FROM azure.network.virtual_hub_route_table_v2s
WHERE resource_group_name = '{{ resource_group_name }}' --required
AND virtual_hub_name = '{{ virtual_hub_name }}' --required
AND route_table_name = '{{ route_table_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required
;