backups

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

Overview

Name	backups
Type	Resource
Id	azure_isv.netapp.backups

Fields

vw_backups

Name	Datatype	Description
accountName	text	field from the properties object
backupName	text	field from the properties object
backupVaultName	text	field from the properties object
backup_id	text	field from the properties object
backup_policy_resource_id	text	field from the properties object
backup_type	text	field from the properties object
creation_date	text	field from the properties object
failure_reason	text	field from the properties object
label	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
size	text	field from the properties object
snapshot_name	text	field from the properties object
subscriptionId	text	field from the properties object
use_existing_snapshot	text	field from the properties object
volume_resource_id	text	field from the properties object

backups

Name	Datatype	Description
properties	object	Backup properties

Methods

Name	Accessible by	Required Params	Description
get	SELECT	accountName, backupName, backupVaultName, resourceGroupName, subscriptionId	Get the specified Backup under Backup Vault.
list_by_vault	SELECT	accountName, backupVaultName, resourceGroupName, subscriptionId	List all backups Under a Backup Vault
create	INSERT	accountName, backupName, backupVaultName, resourceGroupName, subscriptionId, data__properties	Create a backup under the Backup Vault
delete	DELETE	accountName, backupName, backupVaultName, resourceGroupName, subscriptionId	Delete a Backup under the Backup Vault
update	UPDATE	accountName, backupName, backupVaultName, resourceGroupName, subscriptionId	Patch a Backup under the Backup Vault

SELECT examples

List all backups Under a Backup Vault

vw_backups

SELECT
accountName,
backupName,
backupVaultName,
backup_id,
backup_policy_resource_id,
backup_type,
creation_date,
failure_reason,
label,
provisioning_state,
resourceGroupName,
size,
snapshot_name,
subscriptionId,
use_existing_snapshot,
volume_resource_id
FROM azure_isv.netapp.vw_backups
WHERE accountName = '{{ accountName }}'
AND backupVaultName = '{{ backupVaultName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

backups

SELECT
properties
FROM azure_isv.netapp.backups
WHERE accountName = '{{ accountName }}'
AND backupVaultName = '{{ backupVaultName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure_isv.netapp.backups (
accountName,
backupName,
backupVaultName,
resourceGroupName,
subscriptionId,
data__properties,
properties
)
SELECT 
'{{ accountName }}',
'{{ backupName }}',
'{{ backupVaultName }}',
'{{ resourceGroupName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: backupId
          value: string
        - name: creationDate
          value: string
        - name: provisioningState
          value: string
        - name: size
          value: integer
        - name: label
          value: string
        - name: backupType
          value: string
        - name: failureReason
          value: string
        - name: volumeResourceId
          value: string
        - name: useExistingSnapshot
          value: boolean
        - name: snapshotName
          value: string
        - name: backupPolicyResourceId
          value: string

UPDATE example

Updates a backups resource.

/*+ update */
UPDATE azure_isv.netapp.backups
SET 
properties = '{{ properties }}'
WHERE 
accountName = '{{ accountName }}'
AND backupName = '{{ backupName }}'
AND backupVaultName = '{{ backupVaultName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';

DELETE example

Deletes the specified backups resource.

/*+ delete */
DELETE FROM azure_isv.netapp.backups
WHERE accountName = '{{ accountName }}'
AND backupName = '{{ backupName }}'
AND backupVaultName = '{{ backupVaultName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}';