sql_pool_workload_classifiers

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

Overview

Name	sql_pool_workload_classifiers
Type	Resource
Id	azure.synapse.sql_pool_workload_classifiers

Fields

vw_sql_pool_workload_classifiers

Name	Datatype	Description
context	text	field from the properties object
end_time	text	field from the properties object
importance	text	field from the properties object
label	text	field from the properties object
member_name	text	field from the properties object
resourceGroupName	text	field from the properties object
sqlPoolName	text	field from the properties object
start_time	text	field from the properties object
subscriptionId	text	field from the properties object
workloadClassifierName	text	field from the properties object
workloadGroupName	text	field from the properties object
workspaceName	text	field from the properties object

sql_pool_workload_classifiers

Name	Datatype	Description
properties	object	Workload classifier definition. For more information look at sys.workload_management_workload_classifiers (DMV).

Methods

Name	Accessible by	Required Params	Description
get	SELECT	resourceGroupName, sqlPoolName, subscriptionId, workloadClassifierName, workloadGroupName, workspaceName	Get a workload classifier of Sql pool's workload group.
list	SELECT	resourceGroupName, sqlPoolName, subscriptionId, workloadGroupName, workspaceName	Get list of Sql pool's workload classifier for workload groups.
create_or_update	INSERT	resourceGroupName, sqlPoolName, subscriptionId, workloadClassifierName, workloadGroupName, workspaceName	Create Or Update workload classifier for a Sql pool's workload group.
delete	DELETE	resourceGroupName, sqlPoolName, subscriptionId, workloadClassifierName, workloadGroupName, workspaceName	Remove workload classifier of a Sql pool's workload group.

SELECT examples

Get list of Sql pool's workload classifier for workload groups.

vw_sql_pool_workload_classifiers

SELECT
context,
end_time,
importance,
label,
member_name,
resourceGroupName,
sqlPoolName,
start_time,
subscriptionId,
workloadClassifierName,
workloadGroupName,
workspaceName
FROM azure.synapse.vw_sql_pool_workload_classifiers
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workloadGroupName = '{{ workloadGroupName }}'
AND workspaceName = '{{ workspaceName }}';

sql_pool_workload_classifiers

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

INSERT example

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

All Properties

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

Manifest

- name: your_resource_model_name
  props:
    - name: properties
      value:
        - name: memberName
          value: string
        - name: label
          value: string
        - name: context
          value: string
        - name: startTime
          value: string
        - name: endTime
          value: string
        - name: importance
          value: string

DELETE example

Deletes the specified sql_pool_workload_classifiers resource.

/*+ delete */
DELETE FROM azure.synapse.sql_pool_workload_classifiers
WHERE resourceGroupName = '{{ resourceGroupName }}'
AND sqlPoolName = '{{ sqlPoolName }}'
AND subscriptionId = '{{ subscriptionId }}'
AND workloadClassifierName = '{{ workloadClassifierName }}'
AND workloadGroupName = '{{ workloadGroupName }}'
AND workspaceName = '{{ workspaceName }}';