load_balancer_backend_address_pools
Creates, updates, deletes, gets or lists a load_balancer_backend_address_pools resource.
Overview
| Name | load_balancer_backend_address_pools |
| Type | Resource |
| Id | azure.network.load_balancer_backend_address_pools |
Fields
- vw_load_balancer_backend_address_pools
- load_balancer_backend_address_pools
| Name | Datatype | Description |
|---|---|---|
id | text | Resource ID. |
name | text | The name of the resource that is unique within the set of backend address pools used by the load balancer. This name can be used to access the resource. |
backendAddressPoolName | text | field from the properties object |
backend_ip_configurations | text | field from the properties object |
drain_period_in_seconds | text | field from the properties object |
etag | text | A unique read-only string that changes whenever the resource is updated. |
inbound_nat_rules | text | field from the properties object |
loadBalancerName | text | field from the properties object |
load_balancer_backend_addresses | text | field from the properties object |
load_balancing_rules | text | field from the properties object |
location | text | field from the properties object |
outbound_rule | text | field from the properties object |
outbound_rules | text | field from the properties object |
provisioning_state | text | field from the properties object |
resourceGroupName | text | field from the properties object |
subscriptionId | text | field from the properties object |
sync_mode | text | field from the properties object |
tunnel_interfaces | text | field from the properties object |
type | text | Type of the resource. |
virtual_network | text | field from the properties object |
| Name | Datatype | Description |
|---|---|---|
id | string | Resource ID. |
name | string | The name of the resource that is unique within the set of backend address pools used by the load balancer. 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 backend address pool. |
type | string | Type of the resource. |
Methods
| Name | Accessible by | Required Params | Description |
|---|---|---|---|
get | SELECT | backendAddressPoolName, loadBalancerName, resourceGroupName, subscriptionId | Gets load balancer backend address pool. |
list | SELECT | loadBalancerName, resourceGroupName, subscriptionId | Gets all the load balancer backed address pools. |
create_or_update | INSERT | backendAddressPoolName, loadBalancerName, resourceGroupName, subscriptionId | Creates or updates a load balancer backend address pool. |
delete | DELETE | backendAddressPoolName, loadBalancerName, resourceGroupName, subscriptionId | Deletes the specified load balancer backend address pool. |
SELECT examples
Gets all the load balancer backed address pools.
- vw_load_balancer_backend_address_pools
- load_balancer_backend_address_pools
SELECT
id,
name,
backendAddressPoolName,
backend_ip_configurations,
drain_period_in_seconds,
etag,
inbound_nat_rules,
loadBalancerName,
load_balancer_backend_addresses,
load_balancing_rules,
location,
outbound_rule,
outbound_rules,
provisioning_state,
resourceGroupName,
subscriptionId,
sync_mode,
tunnel_interfaces,
type,
virtual_network
FROM azure.network.vw_load_balancer_backend_address_pools
WHERE loadBalancerName = '{{ loadBalancerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';
SELECT
id,
name,
etag,
properties,
type
FROM azure.network.load_balancer_backend_address_pools
WHERE loadBalancerName = '{{ loadBalancerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';
INSERT example
Use the following StackQL query and manifest file to create a new load_balancer_backend_address_pools resource.
- All Properties
- Manifest
/*+ create */
INSERT INTO azure.network.load_balancer_backend_address_pools (
backendAddressPoolName,
loadBalancerName,
resourceGroupName,
subscriptionId,
properties,
name,
id
)
SELECT
'{{ backendAddressPoolName }}',
'{{ loadBalancerName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ name }}',
'{{ id }}'
;
- name: your_resource_model_name
props:
- name: properties
value:
- name: location
value: string
- name: tunnelInterfaces
value:
- - name: port
value: integer
- name: identifier
value: integer
- name: protocol
value: string
- name: type
value: string
- name: loadBalancerBackendAddresses
value:
- - name: properties
value:
- name: virtualNetwork
value:
- name: id
value: string
- name: ipAddress
value: string
- name: inboundNatRulesPortMapping
value:
- - name: inboundNatRuleName
value: string
- name: frontendPort
value: integer
- name: backendPort
value: integer
- name: adminState
value: string
- name: name
value: string
- name: backendIPConfigurations
value:
- - name: properties
value:
- name: virtualNetworkTaps
value:
- - name: properties
value:
- name: networkInterfaceTapConfigurations
value:
- - name: properties
value:
- name: virtualNetworkTap
value:
- name: etag
value: string
- name: id
value: string
- name: name
value: string
- name: type
value: string
- name: location
value: string
- name: tags
value: object
- name: provisioningState
value: []
- name: name
value: string
- name: etag
value: string
- name: type
value: string
- name: id
value: string
- name: resourceGuid
value: string
- name: destinationNetworkInterfaceIPConfiguration
value:
- name: name
value: string
- name: etag
value: string
- name: type
value: string
- name: id
value: string
- name: destinationLoadBalancerFrontEndIPConfiguration
value:
- name: properties
value:
- name: inboundNatRules
value:
- - name: id
value: string
- name: inboundNatPools
value:
- - name: id
value: string
- name: outboundRules
value:
- - name: id
value: string
- name: loadBalancingRules
value:
- - name: id
value: string
- name: privateIPAddress
value: string
- name: privateIPAllocationMethod
value: []
- name: privateIPAddressVersion
value: []
- name: subnet
value:
- name: properties
value:
- name: addressPrefix
value: string
- name: addressPrefixes
value:
- string
- name: networkSecurityGroup
value:
- name: properties
value: []
- name: etag
value: string
- name: id
value: string
- name: name
value: string
- name: type
value: string
- name: location
value: string
- name: tags
value: object
- name: routeTable
value:
- name: properties
value: []
- name: etag
value: string
- name: id
value: string
- name: name
value: string
- name: type
value: string
- name: location
value: string
- name: tags
value: object
- name: serviceEndpoints
value:
- - name: service
value: string
- name: locations
value:
- string
- name: serviceEndpointPolicies
value:
- - name: properties
value: []
- name: etag
value: string
- name: kind
value: string
- name: id
value: string
- name: name
value: string
- name: type
value: string
- name: location
value: string
- name: tags
value: object
- name: privateEndpoints
value:
- - name: extendedLocation
value: []
- name: properties
value: []
- name: etag
value: string
- name: id
value: string
- name: name
value: string
- name: type
value: string
- name: location
value: string
- name: tags
value: object
- name: ipConfigurations
value:
- - name: properties
value: []
- name: name
value: string
- name: etag
value: string
- name: id
value: string
- name: ipConfigurationProfiles
value:
- - name: properties
value: []
- name: name
value: string
- name: type
value: string
- name: etag
value: string
- name: id
value: string
- name: ipAllocations
value:
- - name: id
value: string
- name: resourceNavigationLinks
value:
- - name: properties
value: []
- name: name
value: string
- name: id
value: string
- name: etag
value: string
- name: type
value: string
- name: serviceAssociationLinks
value:
- - name: properties
value: []
- name: name
value: string
- name: etag
value: string
- name: type
value: string
- name: id
value: string
- name: delegations
value:
- - name: properties
value: []
- name: name
value: string
- name: etag
value: string
- name: type
value: string
- name: id
value: string
- name: purpose
value: string
- name: privateEndpointNetworkPolicies
value: string
- name: privateLinkServiceNetworkPolicies
value: string
- name: applicationGatewayIPConfigurations
value:
- - name: properties
value: []
- name: name
value: string
- name: etag
value: string
- name: type
value: string
- name: id
value: string
- name: sharingScope
value: string
- name: defaultOutboundAccess
value: boolean
- name: name
value: string
- name: etag
value: string
- name: type
value: string
- name: id
value: string
- name: publicIPAddress
value:
- name: sku
value:
- name: name
value: string
- name: tier
value: string
- name: properties
value:
- name: ipConfiguration
value:
- name: name
value: string
- name: etag
value: string
- name: id
value: string
- name: dnsSettings
value:
- name: domainNameLabel
value: string
- name: domainNameLabelScope
value: string
- name: fqdn
value: string
- name: reverseFqdn
value: string
- name: ddosSettings
value:
- name: protectionMode
value: string
- name: ipTags
value:
- - name: ipTagType
value: string
- name: tag
value: string
- name: ipAddress
value: string
- name: idleTimeoutInMinutes
value: integer
- name: resourceGuid
value: string
- name: natGateway
value:
- name: sku
value: []
- name: properties
value: []
- name: zones
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
- name: migrationPhase
value: string
- name: deleteOption
value: string
- name: etag
value: string
- name: zones
value:
- string
- name: id
value: string
- name: name
value: string
- name: type
value: string
- name: location
value: string
- name: tags
value: object
- name: name
value: string
- name: etag
value: string
- name: type
value: string
- name: zones
value:
- string
- name: id
value: string
- name: destinationPort
value: integer
- name: etag
value: string
- name: id
value: string
- name: name
value: string
- name: type
value: string
- name: location
value: string
- name: tags
value: object
- name: applicationGatewayBackendAddressPools
value:
- - name: properties
value:
- name: backendIPConfigurations
value:
- - name: name
value: string
- name: etag
value: string
- name: type
value: string
- name: id
value: string
- name: backendAddresses
value:
- - name: fqdn
value: string
- name: ipAddress
value: string
- name: name
value: string
- name: etag
value: string
- name: type
value: string
- name: id
value: string
- name: loadBalancerBackendAddressPools
value:
- - name: name
value: string
- name: etag
value: string
- name: type
value: string
- name: id
value: string
- name: loadBalancerInboundNatRules
value:
- - name: properties
value:
- name: protocol
value: []
- name: frontendPort
value: integer
- name: backendPort
value: integer
- name: idleTimeoutInMinutes
value: integer
- name: enableFloatingIP
value: boolean
- name: enableTcpReset
value: boolean
- name: frontendPortRangeStart
value: integer
- name: frontendPortRangeEnd
value: integer
- name: name
value: string
- name: etag
value: string
- name: type
value: string
- name: id
value: string
- name: privateIPAddress
value: string
- name: privateIPAddressPrefixLength
value: integer
- name: primary
value: boolean
- name: applicationSecurityGroups
value:
- - name: properties
value:
- name: resourceGuid
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
- name: privateLinkConnectionProperties
value:
- name: groupId
value: string
- name: requiredMemberName
value: string
- name: fqdns
value:
- string
- name: name
value: string
- name: etag
value: string
- name: type
value: string
- name: id
value: string
- name: loadBalancingRules
value:
- - name: id
value: string
- name: outboundRules
value:
- - name: id
value: string
- name: inboundNatRules
value:
- - name: id
value: string
- name: drainPeriodInSeconds
value: integer
- name: syncMode
value: string
- name: name
value: string
- name: etag
value: string
- name: type
value: string
- name: id
value: string
DELETE example
Deletes the specified load_balancer_backend_address_pools resource.
/*+ delete */
DELETE FROM azure.network.load_balancer_backend_address_pools
WHERE backendAddressPoolName = '{{ backendAddressPoolName }}'
AND loadBalancerName = '{{ loadBalancerName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';