Skip to main content

standby_container_group_pools

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

Overview

Namestandby_container_group_pools
TypeResource
Idazure.standby_pools.standby_container_group_pools

Fields

NameDatatypeDescription
container_group_propertiestextfield from the properties object
elasticity_profiletextfield from the properties object
locationtextThe geo-location where the resource lives
provisioning_statetextfield from the properties object
resourceGroupNametextfield from the properties object
standbyContainerGroupPoolNametextfield from the properties object
subscriptionIdtextfield from the properties object
tagstextResource tags.

Methods

NameAccessible byRequired ParamsDescription
getSELECTresourceGroupName, standbyContainerGroupPoolName, subscriptionIdGet a StandbyContainerGroupPoolResource
list_by_resource_groupSELECTresourceGroupName, subscriptionIdList StandbyContainerGroupPoolResource resources by resource group
list_by_subscriptionSELECTsubscriptionIdList StandbyContainerGroupPoolResource resources by subscription ID
create_or_updateINSERTresourceGroupName, standbyContainerGroupPoolName, subscriptionIdCreate a StandbyContainerGroupPoolResource
deleteDELETEresourceGroupName, standbyContainerGroupPoolName, subscriptionIdDelete a StandbyContainerGroupPoolResource
updateUPDATEresourceGroupName, standbyContainerGroupPoolName, subscriptionIdUpdate a StandbyContainerGroupPoolResource

SELECT examples

List StandbyContainerGroupPoolResource resources by subscription ID

SELECT
container_group_properties,
elasticity_profile,
location,
provisioning_state,
resourceGroupName,
standbyContainerGroupPoolName,
subscriptionId,
tags
FROM azure.standby_pools.vw_standby_container_group_pools
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

/*+ create */
INSERT INTO azure.standby_pools.standby_container_group_pools (
resourceGroupName,
standbyContainerGroupPoolName,
subscriptionId,
properties,
tags,
location
)
SELECT
'{{ resourceGroupName }}',
'{{ standbyContainerGroupPoolName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ tags }}',
'{{ location }}'
;

UPDATE example

Updates a standby_container_group_pools resource.

/*+ update */
UPDATE azure.standby_pools.standby_container_group_pools
SET
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE
resourceGroupName = '{{ resourceGroupName }}'
AND standbyContainerGroupPoolName = '{{ standbyContainerGroupPoolName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified standby_container_group_pools resource.

/*+ delete */
DELETE FROM azure.standby_pools.standby_container_group_pools
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND standbyContainerGroupPoolName = '{{ standbyContainerGroupPoolName }}'
AND subscriptionId = '{{ subscriptionId }}';