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

vw_workspace_managed_sql_server_recoverable_sql_pools

Name	Datatype	Description
edition	text	field from the properties object
elastic_pool_name	text	field from the properties object
last_available_backup_date	text	field from the properties object
resourceGroupName	text	field from the properties object
service_level_objective	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

workspace_managed_sql_server_recoverable_sql_pools

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

Methods

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

SELECT examples

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

vw_workspace_managed_sql_server_recoverable_sql_pools

SELECT
edition,
elastic_pool_name,
last_available_backup_date,
resourceGroupName,
service_level_objective,
sqlPoolName,
subscriptionId,
workspaceName
FROM azure.synapse.vw_workspace_managed_sql_server_recoverable_sql_pools
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

workspace_managed_sql_server_recoverable_sql_pools

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