pools

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

Overview

Name	pools
Type	Resource
Id	azure.container_storage.pools

Fields

vw_pools

Name	Datatype	Description
assignments	text	field from the properties object
location	text	The geo-location where the resource lives
poolName	text	field from the properties object
pool_type	text	field from the properties object
provisioning_state	text	field from the properties object
reclaim_policy	text	field from the properties object
resourceGroupName	text	field from the properties object
resources	text	field from the properties object
status	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
zones	text	field from the properties object

pools

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	Pool Properties
tags	object	Resource tags.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	poolName, resourceGroupName, subscriptionId	Get a Pool
list_by_resource_group	SELECT	resourceGroupName, subscriptionId	List Pool resources by resource group
list_by_subscription	SELECT	subscriptionId	List Pool resources by subscription ID
create_or_update	INSERT	poolName, resourceGroupName, subscriptionId	Create a Pool
delete	DELETE	poolName, resourceGroupName, subscriptionId	Delete a Pool
update	UPDATE	poolName, resourceGroupName, subscriptionId	Update a Pool

SELECT examples

List Pool resources by subscription ID

vw_pools

SELECT
assignments,
location,
poolName,
pool_type,
provisioning_state,
reclaim_policy,
resourceGroupName,
resources,
status,
subscriptionId,
tags,
zones
FROM azure.container_storage.vw_pools
WHERE subscriptionId = '{{ subscriptionId }}';

pools

SELECT
location,
properties,
tags
FROM azure.container_storage.pools
WHERE subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.container_storage.pools (
poolName,
resourceGroupName,
subscriptionId,
properties,
tags,
location
)
SELECT 
'{{ poolName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}',
'{{ tags }}',
'{{ location }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: []
        - name: status
          value:
            - name: state
              value: []
            - name: message
              value: string
        - name: zones
          value:
            - []
        - name: resources
          value:
            - name: requests
              value:
                - name: storage
                  value: integer
        - name: poolType
          value:
            - name: azureDisk
              value:
                - name: resourceGroup
                  value: string
                - name: skuName
                  value: []
                - name: encryption
                  value:
                    - name: keyName
                      value: string
                    - name: keyVaultUri
                      value: string
                    - name: identity
                      value:
                        - name: principalId
                          value: string
                        - name: tenantId
                          value: string
                        - name: type
                          value: []
                        - name: userAssignedIdentities
                          value: []
                - name: disks
                  value:
                    - - name: id
                        value: string
                      - name: reference
                        value: string
            - name: elasticSan
              value:
                - name: resourceGroup
                  value: string
                - name: skuName
                  value: []
            - name: ephemeralDisk
              value:
                - name: replicas
                  value: integer
                - name: disks
                  value:
                    - - name: id
                        value: string
                      - name: reference
                        value: string
        - name: reclaimPolicy
          value: []
        - name: assignments
          value:
            - - name: status
                value:
                  - name: state
                    value: []
                  - name: message
                    value: string
              - name: id
                value: []
    - name: tags
      value: object
    - name: location
      value: string

UPDATE example

Updates a pools resource.

/*+ update */
UPDATE azure.container_storage.pools
SET 
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
poolName = '{{ poolName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified pools resource.

/*+ delete */
DELETE FROM azure.container_storage.pools
WHERE poolName = '{{ poolName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';