sql_pool_geo_backup_policies

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

Overview

Name	sql_pool_geo_backup_policies
Type	Resource
Id	azure.synapse.sql_pool_geo_backup_policies

Fields

vw_sql_pool_geo_backup_policies

Name	Datatype	Description
geoBackupPolicyName	text	field from the properties object
kind	text	Kind of geo backup policy. This is metadata used for the Azure portal experience.
location	text	Backup policy location.
resourceGroupName	text	field from the properties object
sqlPoolName	text	field from the properties object
state	text	field from the properties object
storage_type	text	field from the properties object
subscriptionId	text	field from the properties object
workspaceName	text	field from the properties object

sql_pool_geo_backup_policies

Name	Datatype	Description
kind	string	Kind of geo backup policy. This is metadata used for the Azure portal experience.
location	string	Backup policy location.
properties	object	The properties of the geo backup policy.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	geoBackupPolicyName, resourceGroupName, sqlPoolName, subscriptionId, workspaceName	Get the specified SQL pool geo backup policy
list	SELECT	resourceGroupName, sqlPoolName, subscriptionId, workspaceName	Get list of SQL pool geo backup policies
create_or_update	INSERT	geoBackupPolicyName, resourceGroupName, sqlPoolName, subscriptionId, workspaceName, data__properties	Updates a SQL Pool geo backup policy.

SELECT examples

Get list of SQL pool geo backup policies

vw_sql_pool_geo_backup_policies

SELECT
geoBackupPolicyName,
kind,
location,
resourceGroupName,
sqlPoolName,
state,
storage_type,
subscriptionId,
workspaceName
FROM azure.synapse.vw_sql_pool_geo_backup_policies
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

sql_pool_geo_backup_policies

SELECT
kind,
location,
properties
FROM azure.synapse.sql_pool_geo_backup_policies
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

INSERT example

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

All Properties

/*+ create */
INSERT INTO azure.synapse.sql_pool_geo_backup_policies (
geoBackupPolicyName,
resourceGroupName,
sqlPoolName,
subscriptionId,
workspaceName,
data__properties,
properties
)
SELECT 
'{{ geoBackupPolicyName }}',
'{{ resourceGroupName }}',
'{{ sqlPoolName }}',
'{{ subscriptionId }}',
'{{ workspaceName }}',
'{{ data__properties }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: state
          value: string
        - name: storageType
          value: string
    - name: kind
      value: string
    - name: location
      value: string