Skip to main content

load_balancers

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

Overview

Nameload_balancers
TypeResource
Idazure.container_orchestrator_runtime.load_balancers

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringFully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}. # pylint: disable=line-too-long
namestringThe name of the resource.
addressesarrayIP Range. Required.
advertiseModestringAdvertise Mode. Required. Known values are: "ARP", "BGP", and "Both". (ARP, BGP, Both)
bgpPeersarrayThe list of BGP peers it should advertise to. Null or empty means to advertise to all peers.
provisioningStatestringResource provision state. Known values are: "Succeeded", "Failed", "Canceled", "Provisioning", "Updating", "Deleting", and "Accepted". (Succeeded, Failed, Canceled, Provisioning, Updating, Deleting, Accepted)
serviceSelectorobjectA dynamic label mapping to select related services. For instance, if you want to create a load balancer only for services with label "a=b", then please specify {"a": "b"} in the field.
systemDataobjectAzure Resource Manager metadata containing createdBy and modifiedBy information.
typestringThe type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectresource_uri, load_balancer_nameGet a LoadBalancer.
listselectresource_uriList LoadBalancer resources by parent.
create_or_updateinsertresource_uri, load_balancer_nameCreate a LoadBalancer.
create_or_updatereplaceresource_uri, load_balancer_nameCreate a LoadBalancer.
deletedeleteresource_uri, load_balancer_nameDelete a LoadBalancer.

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
load_balancer_namestringThe name of the LoadBalancer. Required.
resource_uristringThe fully qualified Azure Resource manager identifier of the resource. Required.

SELECT examples

Get a LoadBalancer.

SELECT
id,
name,
addresses,
advertiseMode,
bgpPeers,
provisioningState,
serviceSelector,
systemData,
type
FROM azure.container_orchestrator_runtime.load_balancers
WHERE resource_uri = '{{ resource_uri }}' -- required
AND load_balancer_name = '{{ load_balancer_name }}' -- required
;

INSERT examples

Create a LoadBalancer.

INSERT INTO azure.container_orchestrator_runtime.load_balancers (
properties,
resource_uri,
load_balancer_name
)
SELECT
'{{ properties }}',
'{{ resource_uri }}',
'{{ load_balancer_name }}'
RETURNING
id,
name,
properties,
systemData,
type
;

REPLACE examples

Create a LoadBalancer.

REPLACE azure.container_orchestrator_runtime.load_balancers
SET
properties = '{{ properties }}'
WHERE
resource_uri = '{{ resource_uri }}' --required
AND load_balancer_name = '{{ load_balancer_name }}' --required
RETURNING
id,
name,
properties,
systemData,
type;

DELETE examples

Delete a LoadBalancer.

DELETE FROM azure.container_orchestrator_runtime.load_balancers
WHERE resource_uri = '{{ resource_uri }}' --required
AND load_balancer_name = '{{ load_balancer_name }}' --required
;