associations_interfaces

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

Overview

Name	associations_interfaces
Type	Resource
Id	azure.service_networking.associations_interfaces

Fields

vw_associations_interfaces

Name	Datatype	Description
associationName	text	field from the properties object
association_type	text	field from the properties object
location	text	The geo-location where the resource lives
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subnet	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
trafficControllerName	text	field from the properties object

associations_interfaces

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	Association Properties.
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	associationName, resourceGroupName, subscriptionId, trafficControllerName	Get a Association
list_by_traffic_controller	SELECT	resourceGroupName, subscriptionId, trafficControllerName	List Association resources by TrafficController
create_or_update	INSERT	associationName, resourceGroupName, subscriptionId, trafficControllerName	Create a Association
delete	DELETE	associationName, resourceGroupName, subscriptionId, trafficControllerName	Delete a Association
update	UPDATE	associationName, resourceGroupName, subscriptionId, trafficControllerName	Update a Association

SELECT examples

List Association resources by TrafficController

vw_associations_interfaces

SELECT
associationName,
association_type,
location,
provisioning_state,
resourceGroupName,
subnet,
subscriptionId,
tags,
trafficControllerName
FROM azure.service_networking.vw_associations_interfaces
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND trafficControllerName = '{{ trafficControllerName }}';

associations_interfaces

SELECT
location,
properties,
tags
FROM azure.service_networking.associations_interfaces
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND trafficControllerName = '{{ trafficControllerName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.service_networking.associations_interfaces (
associationName,
resourceGroupName,
subscriptionId,
trafficControllerName,
properties,
tags,
location
)
SELECT 
'{{ associationName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ trafficControllerName }}',
'{{ properties }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: associationType
          value: []
        - name: subnet
          value:
            - name: id
              value: string
        - name: provisioningState
          value: []
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a associations_interfaces resource.

/*+ update */
UPDATE azure.service_networking.associations_interfaces
SET 
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
associationName = '{{ associationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND trafficControllerName = '{{ trafficControllerName }}';

DELETE example

Deletes the specified associations_interfaces resource.

/*+ delete */
DELETE FROM azure.service_networking.associations_interfaces
WHERE associationName = '{{ associationName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND trafficControllerName = '{{ trafficControllerName }}';