hub_route_tables

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

Overview

Name	hub_route_tables
Type	Resource
Id	azure.network.hub_route_tables

Fields

The following fields are returned by SELECT queries:

get

Request successful. Returns the details of the RouteTable retrieved.

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 RouteTable resource.
type	string	Resource type.

list

Request successful. Returns the details of all the RouteTables for the VirtualHub.

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 RouteTable resource.
type	string	Resource type.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	subscriptionId, resourceGroupName, virtualHubName, routeTableName		Retrieves the details of a RouteTable.
list	select	subscriptionId, resourceGroupName, virtualHubName		Retrieves the details of all RouteTables.
create_or_update	insert	subscriptionId, resourceGroupName, virtualHubName, routeTableName		Creates a RouteTable resource if it doesn't exist else updates the existing RouteTable.
delete	delete	subscriptionId, resourceGroupName, virtualHubName, routeTableName		Deletes a RouteTable.

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.

Name	Datatype	Description
resourceGroupName	string	The resource group name of the RouteTable.
routeTableName	string	The name of the RouteTable.
subscriptionId	string (uuid)	The ID of the target subscription. The value must be an UUID.
virtualHubName	string	The name of the VirtualHub.

SELECT examples

get

Retrieves the details of a RouteTable.

SELECT
id,
name,
etag,
properties,
type
FROM azure.network.hub_route_tables
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND virtualHubName = '{{ virtualHubName }}' -- required
AND routeTableName = '{{ routeTableName }}' -- required
;

list

Retrieves the details of all RouteTables.

SELECT
id,
name,
etag,
properties,
type
FROM azure.network.hub_route_tables
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND virtualHubName = '{{ virtualHubName }}' -- required
;

INSERT examples

create_or_update

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

INSERT INTO azure.network.hub_route_tables (
data__properties,
data__name,
data__id,
subscriptionId,
resourceGroupName,
virtualHubName,
routeTableName
)
SELECT 
'{{ properties }}',
'{{ name }}',
'{{ id }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ virtualHubName }}',
'{{ routeTableName }}'
RETURNING
id,
name,
etag,
properties,
type
;

Manifest

# Description fields are for documentation purposes
- name: hub_route_tables
  props:
    - name: subscriptionId
      value: string (uuid)
      description: Required parameter for the hub_route_tables resource.
    - name: resourceGroupName
      value: string
      description: Required parameter for the hub_route_tables resource.
    - name: virtualHubName
      value: string
      description: Required parameter for the hub_route_tables resource.
    - name: routeTableName
      value: string
      description: Required parameter for the hub_route_tables resource.
    - name: properties
      value: object
      description: |
        Properties of the RouteTable resource.
    - name: name
      value: string
      description: |
        The name of the resource that is unique within a resource group. This name can be used to access the resource.
    - name: id
      value: string
      description: |
        Resource ID.

DELETE examples

delete

Deletes a RouteTable.

DELETE FROM azure.network.hub_route_tables
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND virtualHubName = '{{ virtualHubName }}' --required
AND routeTableName = '{{ routeTableName }}' --required
;