restorable_dropped_sql_pools

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

Overview

Name	restorable_dropped_sql_pools
Type	Resource
Id	azure.synapse.restorable_dropped_sql_pools

Fields

vw_restorable_dropped_sql_pools

Name	Datatype	Description
creation_date	text	field from the properties object
database_name	text	field from the properties object
deletion_date	text	field from the properties object
earliest_restore_date	text	field from the properties object
edition	text	field from the properties object
elastic_pool_name	text	field from the properties object
location	text	The geo-location where the resource lives
max_size_bytes	text	field from the properties object
resourceGroupName	text	field from the properties object
restorableDroppedSqlPoolId	text	field from the properties object
service_level_objective	text	field from the properties object
subscriptionId	text	field from the properties object
workspaceName	text	field from the properties object

restorable_dropped_sql_pools

Name	Datatype	Description
location	string	The geo-location where the resource lives
properties	object	The properties of a restorable dropped Sql pool

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, restorableDroppedSqlPoolId, subscriptionId, workspaceName	Gets a deleted sql pool that can be restored
list_by_workspace	SELECT	resourceGroupName, subscriptionId, workspaceName	Gets a list of deleted Sql pools that can be restored

SELECT examples

Gets a list of deleted Sql pools that can be restored

vw_restorable_dropped_sql_pools

SELECT
creation_date,
database_name,
deletion_date,
earliest_restore_date,
edition,
elastic_pool_name,
location,
max_size_bytes,
resourceGroupName,
restorableDroppedSqlPoolId,
service_level_objective,
subscriptionId,
workspaceName
FROM azure.synapse.vw_restorable_dropped_sql_pools
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

restorable_dropped_sql_pools

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