pools

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

Overview

Name	pools
Type	Resource
Id	azure_isv.netapp.pools

Fields

vw_pools

Name	Datatype	Description
accountName	text	field from the properties object
cool_access	text	field from the properties object
encryption_type	text	field from the properties object
etag	text	A unique read-only string that changes whenever the resource is updated.
location	text	The geo-location where the resource lives
poolName	text	field from the properties object
pool_id	text	field from the properties object
provisioning_state	text	field from the properties object
qos_type	text	field from the properties object
resourceGroupName	text	field from the properties object
service_level	text	field from the properties object
size	text	field from the properties object
subscriptionId	text	field from the properties object
tags	text	Resource tags.
total_throughput_mibps	text	field from the properties object
utilized_throughput_mibps	text	field from the properties object

pools

Name	Datatype	Description
etag	string	A unique read-only string that changes whenever the resource is updated.
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	accountName, poolName, resourceGroupName, subscriptionId	Get details of the specified capacity pool
list	SELECT	accountName, resourceGroupName, subscriptionId	List all capacity pools in the NetApp Account
create_or_update	INSERT	accountName, poolName, resourceGroupName, subscriptionId, data__location, data__properties	Create or Update a capacity pool
delete	DELETE	accountName, poolName, resourceGroupName, subscriptionId	Delete the specified capacity pool
update	UPDATE	accountName, poolName, resourceGroupName, subscriptionId	Patch the specified capacity pool

SELECT examples

List all capacity pools in the NetApp Account

vw_pools

SELECT
accountName,
cool_access,
encryption_type,
etag,
location,
poolName,
pool_id,
provisioning_state,
qos_type,
resourceGroupName,
service_level,
size,
subscriptionId,
tags,
total_throughput_mibps,
utilized_throughput_mibps
FROM azure_isv.netapp.vw_pools
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

pools

SELECT
etag,
location,
properties,
tags
FROM azure_isv.netapp.pools
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_isv.netapp.pools (
accountName,
poolName,
resourceGroupName,
subscriptionId,
data__location,
data__properties,
tags,
location,
properties
)
SELECT 
'{{ accountName }}',
'{{ poolName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__location }}',
'{{ data__properties }}',
'{{ tags }}',
'{{ location }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: tags
      value: object
    - name: location
      value: string
    - name: etag
      value: string
    - name: properties
      value:
        - name: poolId
          value: string
        - name: size
          value: integer
        - name: serviceLevel
          value: []
        - name: provisioningState
          value: string
        - name: totalThroughputMibps
          value: number
        - name: utilizedThroughputMibps
          value: number
        - name: qosType
          value: string
        - name: coolAccess
          value: boolean
        - name: encryptionType
          value: string

UPDATE example

Updates a pools resource.

/*+ update */
UPDATE azure_isv.netapp.pools
SET 
location = '{{ location }}',
tags = '{{ tags }}',
properties = '{{ properties }}'
WHERE 
accountName = '{{ accountName }}'
AND poolName = '{{ poolName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified pools resource.

/*+ delete */
DELETE FROM azure_isv.netapp.pools
WHERE accountName = '{{ accountName }}'
AND poolName = '{{ poolName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';