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

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
creationDate	string (date-time)	The creation date of the database (ISO8601 format).
databaseName	string	The name of the database.
deletionDate	string (date-time)	The deletion date of the database (ISO8601 format).
earliestRestoreDate	string (date-time)	The earliest restore date of the database (ISO8601 format).
edition	string	The edition of the database.
elasticPoolName	string	The elastic pool name of the database.
location	string	The geo-location where the resource lives.
maxSizeBytes	string	The max size in bytes of the database.
serviceLevelObjective	string	The service level objective name of the database.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

list_by_workspace

Name	Datatype	Description
id	string	Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName}.
name	string	The name of the resource.
creationDate	string (date-time)	The creation date of the database (ISO8601 format).
databaseName	string	The name of the database.
deletionDate	string (date-time)	The deletion date of the database (ISO8601 format).
earliestRestoreDate	string (date-time)	The earliest restore date of the database (ISO8601 format).
edition	string	The edition of the database.
elasticPoolName	string	The elastic pool name of the database.
location	string	The geo-location where the resource lives.
maxSizeBytes	string	The max size in bytes of the database.
serviceLevelObjective	string	The service level objective name of the database.
type	string	The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts".

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	resource_group_name, workspace_name, restorable_dropped_sql_pool_id, subscription_id		Gets a deleted sql pool that can be restored.
list_by_workspace	select	resource_group_name, workspace_name, subscription_id		Gets a list of deleted Sql pools that can be restored.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
resource_group_name	string	The name of the resource group. The name is case insensitive. Required.
restorable_dropped_sql_pool_id	string	The id of the deleted Sql Pool in the form of sqlPoolName,deletionTimeInFileTimeFormat. Required.
subscription_id	string
workspace_name	string	The name of the workspace. Required.

SELECT examples

get

Gets a deleted sql pool that can be restored.

SELECT
id,
name,
creationDate,
databaseName,
deletionDate,
earliestRestoreDate,
edition,
elasticPoolName,
location,
maxSizeBytes,
serviceLevelObjective,
type
FROM azure.synapse.restorable_dropped_sql_pools
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND workspace_name = '{{ workspace_name }}' -- required
AND restorable_dropped_sql_pool_id = '{{ restorable_dropped_sql_pool_id }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;

list_by_workspace

Gets a list of deleted Sql pools that can be restored.

SELECT
id,
name,
creationDate,
databaseName,
deletionDate,
earliestRestoreDate,
edition,
elasticPoolName,
location,
maxSizeBytes,
serviceLevelObjective,
type
FROM azure.synapse.restorable_dropped_sql_pools
WHERE resource_group_name = '{{ resource_group_name }}' -- required
AND workspace_name = '{{ workspace_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;