data_pools

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

Overview

Name	data_pools
Type	Resource
Id	azure.autonomous_dev_platform.data_pools

Fields

vw_data_pools

Name	Datatype	Description
id	text	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	text	The name of the resource
accountName	text	field from the properties object
dataPoolName	text	field from the properties object
data_pool_id	text	field from the properties object
locations	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
subscriptionId	text	field from the properties object
system_data	text	field from the properties object
tags	text	field from the properties object
type	text	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

data_pools

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}
name	string	The name of the resource
properties	object	Data Pool properties
systemData	object	Metadata pertaining to creation and last modification of the resource.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts"

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, dataPoolName, resourceGroupName, subscriptionId	Gets the properties of a Data Pool
list	SELECT	accountName, resourceGroupName, subscriptionId	Lists the data pools under the ADP account
create_or_update	INSERT	accountName, dataPoolName, resourceGroupName, subscriptionId	Creates or updates a Data Pool
delete	DELETE	accountName, dataPoolName, resourceGroupName, subscriptionId	Deletes a Data Pool
update	UPDATE	accountName, dataPoolName, resourceGroupName, subscriptionId	Updates the properties of an existing Data Pool

SELECT examples

Lists the data pools under the ADP account

vw_data_pools

SELECT
id,
name,
accountName,
dataPoolName,
data_pool_id,
locations,
provisioning_state,
resourceGroupName,
subscriptionId,
system_data,
tags,
type
FROM azure.autonomous_dev_platform.vw_data_pools
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

data_pools

SELECT
id,
name,
properties,
systemData,
type
FROM azure.autonomous_dev_platform.data_pools
WHERE accountName = '{{ accountName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.autonomous_dev_platform.data_pools (
accountName,
dataPoolName,
resourceGroupName,
subscriptionId,
properties
)
SELECT 
'{{ accountName }}',
'{{ dataPoolName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: dataPoolId
          value: string
        - name: provisioningState
          value: string
        - name: locations
          value:
            - - name: name
                value: string
              - name: encryption
                value:
                  - name: keyVaultUri
                    value: string
                  - name: keyName
                    value: string
                  - name: keyVersion
                    value: string
                  - name: userAssignedIdentity
                    value: string
              - name: storageSku
                value:
                  - name: name
                    value: string
              - name: storageAccountCount
                value: integer
        - name: tags
          value: []
    - name: systemData
      value:
        - name: createdBy
          value: string
        - name: createdByType
          value: string
        - name: createdAt
          value: string
        - name: lastModifiedBy
          value: string
        - name: lastModifiedByType
          value: string
        - name: lastModifiedAt
          value: string
    - name: id
      value: string
    - name: name
      value: string
    - name: type
      value: string

UPDATE example

Updates a data_pools resource.

/*+ update */
UPDATE azure.autonomous_dev_platform.data_pools
SET 
properties = '{{ properties }}'
WHERE 
accountName = '{{ accountName }}'
AND dataPoolName = '{{ dataPoolName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified data_pools resource.

/*+ delete */
DELETE FROM azure.autonomous_dev_platform.data_pools
WHERE accountName = '{{ accountName }}'
AND dataPoolName = '{{ dataPoolName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';