workspace_managed_sql_server_recoverable_sql_pools

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

Overview

Name	workspace_managed_sql_server_recoverable_sql_pools
Type	Resource
Id	azure.synapse.workspace_managed_sql_server_recoverable_sql_pools

Fields

The following fields are returned by SELECT queries:

get

Name	Datatype	Description
properties	object	The properties of a recoverable sql pool

list

Name	Datatype	Description
properties	object	The properties of a recoverable sql pool

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	subscriptionId, resourceGroupName, workspaceName, sqlPoolName		Get recoverable sql pools for workspace managed sql server.
list	select	subscriptionId, resourceGroupName, workspaceName		Get list of recoverable sql pools for workspace managed sql server.

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
resourceGroupName	string	The name of the resource group. The name is case insensitive.
sqlPoolName	string	The name of the sql pool
subscriptionId	string	The ID of the target subscription.
workspaceName	string	The name of the workspace.

SELECT examples

get

Get recoverable sql pools for workspace managed sql server.

SELECT
properties
FROM azure.synapse.workspace_managed_sql_server_recoverable_sql_pools
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND workspaceName = '{{ workspaceName }}' -- required
AND sqlPoolName = '{{ sqlPoolName }}' -- required
;

list

Get list of recoverable sql pools for workspace managed sql server.

SELECT
properties
FROM azure.synapse.workspace_managed_sql_server_recoverable_sql_pools
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND workspaceName = '{{ workspaceName }}' -- required
;