Skip to main content

pools

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

Overview

Namepools
TypeResource
Idazure.container_storage.pools

Fields

The following fields are returned by SELECT queries:

Azure operation completed successfully.

NameDatatypeDescription
locationstringThe geo-location where the resource lives
propertiesobjectThe resource-specific properties for this resource.
tagsobjectResource tags.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectsubscriptionId, resourceGroupName, poolNameGet a Pool
list_by_resource_groupselectsubscriptionId, resourceGroupNameList Pool resources by resource group
list_by_subscriptionselectsubscriptionIdList Pool resources by subscription ID
create_or_updateinsertsubscriptionId, resourceGroupName, poolNameCreate a Pool
updateupdatesubscriptionId, resourceGroupName, poolNameUpdate a Pool
deletedeletesubscriptionId, resourceGroupName, poolNameDelete a 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
poolNamestringPool Object
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
subscriptionIdstringThe ID of the target subscription.

SELECT examples

Get a Pool

SELECT
location,
properties,
tags
FROM azure.container_storage.pools
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND poolName = '{{ poolName }}' -- required
;

INSERT examples

Create a Pool

INSERT INTO azure.container_storage.pools (
data__properties,
data__tags,
data__location,
subscriptionId,
resourceGroupName,
poolName
)
SELECT
'{{ properties }}',
'{{ tags }}',
'{{ location }}',
'{{ subscriptionId }}',
'{{ resourceGroupName }}',
'{{ poolName }}'
RETURNING
location,
properties,
tags
;

UPDATE examples

Update a Pool

UPDATE azure.container_storage.pools
SET
data__tags = '{{ tags }}',
data__properties = '{{ properties }}'
WHERE
subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND poolName = '{{ poolName }}' --required
RETURNING
location,
properties,
tags;

DELETE examples

Delete a Pool

DELETE FROM azure.container_storage.pools
WHERE subscriptionId = '{{ subscriptionId }}' --required
AND resourceGroupName = '{{ resourceGroupName }}' --required
AND poolName = '{{ poolName }}' --required
;