sql_pool_maintenance_window_options

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

Overview

Name	sql_pool_maintenance_window_options
Type	Resource
Id	azure.synapse.sql_pool_maintenance_window_options

Fields

vw_sql_pool_maintenance_window_options

Name	Datatype	Description
allow_multiple_maintenance_windows_per_cycle	text	field from the properties object
default_duration_in_minutes	text	field from the properties object
is_enabled	text	field from the properties object
maintenanceWindowOptionsName	text	field from the properties object
maintenance_window_cycles	text	field from the properties object
min_cycles	text	field from the properties object
min_duration_in_minutes	text	field from the properties object
resourceGroupName	text	field from the properties object
sqlPoolName	text	field from the properties object
subscriptionId	text	field from the properties object
time_granularity_in_minutes	text	field from the properties object
workspaceName	text	field from the properties object

sql_pool_maintenance_window_options

Name	Datatype	Description
properties	object	Maintenance window options properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	maintenanceWindowOptionsName, resourceGroupName, sqlPoolName, subscriptionId, workspaceName	Get list of SQL pool's available maintenance windows.

SELECT examples

Get list of SQL pool's available maintenance windows.

vw_sql_pool_maintenance_window_options

SELECT
allow_multiple_maintenance_windows_per_cycle,
default_duration_in_minutes,
is_enabled,
maintenanceWindowOptionsName,
maintenance_window_cycles,
min_cycles,
min_duration_in_minutes,
resourceGroupName,
sqlPoolName,
subscriptionId,
time_granularity_in_minutes,
workspaceName
FROM azure.synapse.vw_sql_pool_maintenance_window_options
WHERE maintenanceWindowOptionsName = '{{ maintenanceWindowOptionsName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

sql_pool_maintenance_window_options

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