sql_pool_maintenance_windows

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

Overview

Name	sql_pool_maintenance_windows
Type	Resource
Id	azure.synapse.sql_pool_maintenance_windows

Fields

vw_sql_pool_maintenance_windows

Name	Datatype	Description
maintenanceWindowName	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_ranges	text	field from the properties object
workspaceName	text	field from the properties object

sql_pool_maintenance_windows

Name	Datatype	Description
properties	object	Maintenance windows resource properties.

Methods

Name	Accessible by	Required Params	Description
get	SELECT	maintenanceWindowName, resourceGroupName, sqlPoolName, subscriptionId, workspaceName	Get a SQL pool's Maintenance Windows.
create_or_update	INSERT	maintenanceWindowName, resourceGroupName, sqlPoolName, subscriptionId, workspaceName	Creates or updates a Sql pool's maintenance windows settings.

SELECT examples

Get a SQL pool's Maintenance Windows.

vw_sql_pool_maintenance_windows

SELECT
maintenanceWindowName,
resourceGroupName,
sqlPoolName,
subscriptionId,
time_ranges,
workspaceName
FROM azure.synapse.vw_sql_pool_maintenance_windows
WHERE maintenanceWindowName = '{{ maintenanceWindowName }}'
AND resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workspaceName = '{{ workspaceName }}';

sql_pool_maintenance_windows

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

INSERT example

Use the following StackQL query and manifest file to create a new sql_pool_maintenance_windows resource.

All Properties

/*+ create */
INSERT INTO azure.synapse.sql_pool_maintenance_windows (
maintenanceWindowName,
resourceGroupName,
sqlPoolName,
subscriptionId,
workspaceName,
properties
)
SELECT 
'{{ maintenanceWindowName }}',
'{{ resourceGroupName }}',
'{{ sqlPoolName }}',
'{{ subscriptionId }}',
'{{ workspaceName }}',
'{{ properties }}'
;

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: timeRanges
          value:
            - - name: dayOfWeek
                value: string
              - name: startTime
                value: string
              - name: duration
                value: string