Skip to main content

sql_pool_recommended_sensitivity_labels

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

Overview

Namesql_pool_recommended_sensitivity_labels
TypeResource
Idazure.synapse.sql_pool_recommended_sensitivity_labels

Fields

The following fields are returned by SELECT queries:

SELECT not supported for this resource, use SHOW METHODS to view available operations for the resource.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
updateupdateresource_group_name, workspace_name, sql_pool_name, subscription_idUpdate recommended sensitivity labels states of a given SQL Pool using an operations batch.

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.

NameDatatypeDescription
resource_group_namestringThe name of the resource group. The name is case insensitive. Required.
sql_pool_namestringSQL pool name. Required.
subscription_idstring
workspace_namestringThe name of the workspace. Required.

UPDATE examples

Update recommended sensitivity labels states of a given SQL Pool using an operations batch.

UPDATE azure.synapse.sql_pool_recommended_sensitivity_labels
SET
operations = '{{ operations }}'
WHERE
resource_group_name = '{{ resource_group_name }}' --required
AND workspace_name = '{{ workspace_name }}' --required
AND sql_pool_name = '{{ sql_pool_name }}' --required
AND subscription_id = '{{ subscription_id }}' --required;