route_filters

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

Overview

Name	route_filters
Type	Resource
Id	azure.network.route_filters

Fields

vw_route_filters

Name	Datatype	Description
id	text	Resource ID.
name	text	Resource name.
etag	text	A unique read-only string that changes whenever the resource is updated.
ipv6_peerings	text	field from the properties object
location	text	Resource location.
peerings	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
routeFilterName	text	field from the properties object
rules	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
type	text	Resource type.

route_filters

Name	Datatype	Description
id	string	Resource ID.
name	string	Resource name.
etag	string	A unique read-only string that changes whenever the resource is updated.
location	string	Resource location.
properties	object	Route Filter Resource.
tags	object	Resource tags.
type	string	Resource type.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, routeFilterName, subscriptionId	Gets the specified route filter.
list	SELECT	subscriptionId	Gets all route filters in a subscription.
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	Gets all route filters in a resource group.
create_or_update	INSERT	resourceGroupName, routeFilterName, subscriptionId, data__location	Creates or updates a route filter in a specified resource group.
delete	DELETE	resourceGroupName, routeFilterName, subscriptionId	Deletes the specified route filter.
update_tags	EXEC	resourceGroupName, routeFilterName, subscriptionId	Updates tags of a route filter.

SELECT examples

Gets all route filters in a subscription.

vw_route_filters

SELECT
id,
name,
etag,
ipv6_peerings,
location,
peerings,
provisioning_state,
resourceGroupName,
routeFilterName,
rules,
subscriptionId,
tags,
type
FROM azure.network.vw_route_filters
WHERE subscriptionId = '{{ subscriptionId }}';

route_filters

SELECT
id,
name,
etag,
location,
properties,
tags,
type
FROM azure.network.route_filters
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: rules
          value:
            - - name: properties
                value:
                  - name: access
                    value: []
                  - name: routeFilterRuleType
                    value: string
                  - name: communities
                    value:
                      - string
                  - name: provisioningState
                    value: []
              - name: name
                value: string
              - name: location
                value: string
              - name: etag
                value: string
              - name: id
                value: string
        - name: peerings
          value:
            - - name: properties
                value:
                  - name: peeringType
                    value: []
                  - name: state
                    value: []
                  - name: azureASN
                    value: integer
                  - name: peerASN
                    value: integer
                  - name: primaryPeerAddressPrefix
                    value: string
                  - name: secondaryPeerAddressPrefix
                    value: string
                  - name: primaryAzurePort
                    value: string
                  - name: secondaryAzurePort
                    value: string
                  - name: sharedKey
                    value: string
                  - name: vlanId
                    value: integer
                  - name: microsoftPeeringConfig
                    value:
                      - name: advertisedPublicPrefixes
                        value:
                          - string
                      - name: advertisedCommunities
                        value:
                          - string
                      - name: advertisedPublicPrefixesState
                        value: string
                      - name: legacyMode
                        value: integer
                      - name: customerASN
                        value: integer
                      - name: routingRegistryName
                        value: string
                  - name: stats
                    value:
                      - name: primarybytesIn
                        value: integer
                      - name: primarybytesOut
                        value: integer
                      - name: secondarybytesIn
                        value: integer
                      - name: secondarybytesOut
                        value: integer
                  - name: gatewayManagerEtag
                    value: string
                  - name: lastModifiedBy
                    value: string
                  - name: routeFilter
                    value:
                      - name: id
                        value: string
                  - name: ipv6PeeringConfig
                    value:
                      - name: primaryPeerAddressPrefix
                        value: string
                      - name: secondaryPeerAddressPrefix
                        value: string
                      - name: state
                        value: string
                  - name: expressRouteConnection
                    value:
                      - name: id
                        value: string
                  - name: connections
                    value:
                      - - name: properties
                          value:
                            - name: addressPrefix
                              value: string
                            - name: authorizationKey
                              value: string
                            - name: ipv6CircuitConnectionConfig
                              value:
                                - name: addressPrefix
                                  value: string
                                - name: circuitConnectionStatus
                                  value: []
                        - name: name
                          value: string
                        - name: etag
                          value: string
                        - name: type
                          value: string
                        - name: id
                          value: string
                  - name: peeredConnections
                    value:
                      - - name: properties
                          value:
                            - name: addressPrefix
                              value: string
                            - name: connectionName
                              value: string
                            - name: authResourceGuid
                              value: string
                        - name: name
                          value: string
                        - name: etag
                          value: string
                        - name: type
                          value: string
                        - name: id
                          value: string
              - name: name
                value: string
              - name: etag
                value: string
              - name: type
                value: string
              - name: id
                value: string
        - name: ipv6Peerings
          value:
            - - name: name
                value: string
              - name: etag
                value: string
              - name: type
                value: string
              - name: id
                value: string
    - name: etag
      value: string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string
    - name: location
      value: string
    - name: tags
      value: object

DELETE example

Deletes the specified route_filters resource.

/*+ delete */
DELETE FROM azure.network.route_filters
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND routeFilterName = '{{ routeFilterName }}'
AND subscriptionId = '{{ subscriptionId }}';