long_running_backups

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

Overview

Name	long_running_backups
Type	Resource
Id	azure.mysql.long_running_backups

Fields

vw_long_running_backups

Name	Datatype	Description
backupName	text	field from the properties object
backup_name_v2	text	field from the properties object
backup_type	text	field from the properties object
completed_time	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
serverName	text	field from the properties object
source	text	field from the properties object
subscriptionId	text	field from the properties object

long_running_backups

Name	Datatype	Description
properties	object	The properties of a server backup.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	backupName, resourceGroupName, serverName, subscriptionId	Get backup for a given server.
list	SELECT	resourceGroupName, serverName, subscriptionId	List all the backups for a given server.
create	INSERT	backupName, resourceGroupName, serverName, subscriptionId	Create backup for a given server with specified backup name.

SELECT examples

List all the backups for a given server.

vw_long_running_backups

SELECT
backupName,
backup_name_v2,
backup_type,
completed_time,
provisioning_state,
resourceGroupName,
serverName,
source,
subscriptionId
FROM azure.mysql.vw_long_running_backups
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

long_running_backups

SELECT
properties
FROM azure.mysql.long_running_backups
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND serverName = '{{ serverName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.mysql.long_running_backups (
backupName,
resourceGroupName,
serverName,
subscriptionId,
properties
)
SELECT 
'{{ backupName }}',
'{{ resourceGroupName }}',
'{{ serverName }}',
'{{ subscriptionId }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: backupNameV2
          value: string
        - name: backupType
          value: string
        - name: completedTime
          value: string
        - name: source
          value: string
        - name: provisioningState
          value: []