failover_groups

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

Overview

Name	failover_groups
Type	Resource
Id	azure.azure_arc_data.failover_groups

Fields

vw_failover_groups

Name	Datatype	Description
failoverGroupName	text	field from the properties object
partner_managed_instance_id	text	field from the properties object
provisioning_state	text	field from the properties object
resourceGroupName	text	field from the properties object
spec	text	field from the properties object
sqlManagedInstanceName	text	field from the properties object
status	text	field from the properties object
subscriptionId	text	field from the properties object

failover_groups

Name	Datatype	Description
properties	object	The properties of a failover group resource.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	failoverGroupName, resourceGroupName, sqlManagedInstanceName, subscriptionId	Retrieves a failover group resource
list	SELECT	resourceGroupName, sqlManagedInstanceName, subscriptionId
create	INSERT	failoverGroupName, resourceGroupName, sqlManagedInstanceName, subscriptionId, data__properties	Creates or replaces a failover group resource.
delete	DELETE	failoverGroupName, resourceGroupName, sqlManagedInstanceName, subscriptionId	Deletes a failover group resource

SELECT examples

vw_failover_groups

SELECT
failoverGroupName,
partner_managed_instance_id,
provisioning_state,
resourceGroupName,
spec,
sqlManagedInstanceName,
status,
subscriptionId
FROM azure.azure_arc_data.vw_failover_groups
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlManagedInstanceName = '{{ sqlManagedInstanceName }}'
AND subscriptionId = '{{ subscriptionId }}';

failover_groups

SELECT
properties
FROM azure.azure_arc_data.failover_groups
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlManagedInstanceName = '{{ sqlManagedInstanceName }}'
AND subscriptionId = '{{ subscriptionId }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.azure_arc_data.failover_groups (
failoverGroupName,
resourceGroupName,
sqlManagedInstanceName,
subscriptionId,
data__properties,
properties
)
SELECT 
'{{ failoverGroupName }}',
'{{ resourceGroupName }}',
'{{ sqlManagedInstanceName }}',
'{{ subscriptionId }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: provisioningState
          value: string
        - name: partnerManagedInstanceId
          value: string
        - name: spec
          value:
            - name: sharedName
              value: string
            - name: sourceMI
              value: string
            - name: partnerMI
              value: string
            - name: partnerMirroringURL
              value: string
            - name: partnerMirroringCert
              value: string
            - name: partnerSyncMode
              value: string
            - name: role
              value: string
        - name: status
          value: object

DELETE example

Deletes the specified failover_groups resource.

/*+ delete */
DELETE FROM azure.azure_arc_data.failover_groups
WHERE failoverGroupName = '{{ failoverGroupName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND sqlManagedInstanceName = '{{ sqlManagedInstanceName }}'
AND subscriptionId = '{{ subscriptionId }}';