Skip to main content

load_balancer_backend_address_pools

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

Overview

Nameload_balancer_backend_address_pools
TypeResource
Idazure.network.load_balancer_backend_address_pools

Fields

The following fields are returned by SELECT queries:

Request successful. The operation returns LoadBalancer BackendAddressPool resource.

NameDatatypeDescription
idstringResource ID.
namestringThe 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.
etagstringA unique read-only string that changes whenever the resource is updated.
propertiesobjectProperties of load balancer backend address pool.
typestringType of the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresourceGroupName, loadBalancerName, backendAddressPoolName, subscriptionIdGets load balancer backend address pool.
listselectresourceGroupName, loadBalancerName, subscriptionIdGets all the load balancer backed address pools.
create_or_updateinsertresourceGroupName, loadBalancerName, backendAddressPoolName, subscriptionIdCreates or updates a load balancer backend address pool.
deletedeleteresourceGroupName, loadBalancerName, backendAddressPoolName, subscriptionIdDeletes the specified load balancer backend address pool.

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
backendAddressPoolNamestringThe name of the backend address pool.
loadBalancerNamestringThe name of the load balancer.
resourceGroupNamestringThe name of the resource group.
subscriptionIdstring (uuid)The ID of the target subscription. The value must be an UUID.

SELECT examples

Gets load balancer backend address pool.

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

INSERT examples

Creates or updates a load balancer backend address pool.

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

DELETE examples

Deletes the specified load balancer backend address pool.

DELETE FROM azure.network.load_balancer_backend_address_pools
WHERE resourceGroupName = '{{ resourceGroupName }}' --required
AND loadBalancerName = '{{ loadBalancerName }}' --required
AND backendAddressPoolName = '{{ backendAddressPoolName }}' --required
AND subscriptionId = '{{ subscriptionId }}' --required
;