Skip to main content

sql_pool_sensitivity_labels_current

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

Overview

Namesql_pool_sensitivity_labels_current
TypeResource
Idazure.synapse.sql_pool_sensitivity_labels_current

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
managedBystringmanaged by
propertiesobjectResource properties.

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
listselectsubscriptionId, resourceGroupName, workspaceName, sqlPoolName$filterGets SQL pool sensitivity labels.

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
resourceGroupNamestringThe name of the resource group. The name is case insensitive.
sqlPoolNamestringSQL pool name
subscriptionIdstringThe ID of the target subscription.
workspaceNamestringThe name of the workspace.
$filterstringAn OData filter expression that filters elements in the collection.

SELECT examples

Gets SQL pool sensitivity labels.

SELECT
managedBy,
properties
FROM azure.synapse.sql_pool_sensitivity_labels_current
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND workspaceName = '{{ workspaceName }}' -- required
AND sqlPoolName = '{{ sqlPoolName }}' -- required
AND $filter = '{{ $filter }}'
;