sql_pool_restore_points

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

Overview

Name	sql_pool_restore_points
Type	Resource
Id	azure.synapse.sql_pool_restore_points

Fields

vw_sql_pool_restore_points

Name	Datatype	Description
earliest_restore_date	text	field from the properties object
location	text	Resource location.
resourceGroupName	text	field from the properties object
restorePointName	text	field from the properties object
restore_point_creation_date	text	field from the properties object
restore_point_label	text	field from the properties object
restore_point_type	text	field from the properties object
sqlPoolName	text	field from the properties object
subscriptionId	text	field from the properties object
workspaceName	text	field from the properties object

sql_pool_restore_points

Name	Datatype	Description
location	string	Resource location.
properties	object	Properties of a database restore point

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, restorePointName, sqlPoolName, subscriptionId, workspaceName	Gets a restore point.
list	SELECT	resourceGroupName, sqlPoolName, subscriptionId, workspaceName	Get SQL pool backup information
create	INSERT	resourceGroupName, sqlPoolName, subscriptionId, workspaceName, data__restorePointLabel	Creates a restore point for a data warehouse.
delete	DELETE	resourceGroupName, restorePointName, sqlPoolName, subscriptionId, workspaceName	Deletes a restore point.

SELECT examples

Get SQL pool backup information

vw_sql_pool_restore_points

SELECT
earliest_restore_date,
location,
resourceGroupName,
restorePointName,
restore_point_creation_date,
restore_point_label,
restore_point_type,
sqlPoolName,
subscriptionId,
workspaceName
FROM azure.synapse.vw_sql_pool_restore_points
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

sql_pool_restore_points

SELECT
location,
properties
FROM azure.synapse.sql_pool_restore_points
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_restore_points resource.

All Properties

/*+ create */
INSERT INTO azure.synapse.sql_pool_restore_points (
resourceGroupName,
sqlPoolName,
subscriptionId,
workspaceName,
data__restorePointLabel,
restorePointLabel
)
SELECT 
'{{ resourceGroupName }}',
'{{ sqlPoolName }}',
'{{ subscriptionId }}',
'{{ workspaceName }}',
'{{ data__restorePointLabel }}',
'{{ restorePointLabel }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: restorePointLabel
      value: string

DELETE example

Deletes the specified sql_pool_restore_points resource.

/*+ delete */
DELETE FROM azure.synapse.sql_pool_restore_points
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND restorePointName = '{{ restorePointName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';