Sql Pool Sensitivity Labels - List Recommended
Gets sensitivity labels of a given SQL pool.
GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools/{sqlPoolName}/recommendedSensitivityLabels?api-version=2021-06-01
GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Synapse/workspaces/{workspaceName}/sqlPools/{sqlPoolName}/recommendedSensitivityLabels?api-version=2021-06-01&includeDisabledRecommendations={includeDisabledRecommendations}&$skipToken={$skipToken}&$filter={$filter}
URI Parameters
Name | In | Required | Type | Description |
---|---|---|---|---|
resource
|
path | True |
string |
The name of the resource group. The name is case insensitive. |
sql
|
path | True |
string |
SQL pool name |
subscription
|
path | True |
string |
The ID of the target subscription. |
workspace
|
path | True |
string |
The name of the workspace. |
api-version
|
query | True |
string |
The API version to use for this operation. |
$filter
|
query |
string |
An OData filter expression that filters elements in the collection. |
|
$skip
|
query |
string |
An OData query option to indicate how many elements to skip in the collection. |
|
include
|
query |
boolean |
Specifies whether to include disabled recommendations or not. |
Responses
Name | Type | Description |
---|---|---|
200 OK |
OK |
|
Other Status Codes |
*** Error Responses: ***
|
Examples
Gets the recommended sensitivity labels of a given SQL Analytics pool
Sample Request
Sample Response
{
"value": [
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/myRG/providers/Microsoft.Synapse/workspaces/myServer/sqlPools/myDatabase/schemas/dbo/tables/myTable/columns/myColumn/sensitivityLabels/recommended",
"name": "recommended",
"type": "Microsoft.Synapse/workspaces/sqlPools/schemas/tables/columns/sensitivityLabels",
"properties": {
"informationType": "Financial",
"informationTypeId": "d22fa6e9-5ee4-3bde-4c2b-a409604c4646",
"labelId": "05e6eaa1-075a-4fb4-a732-a92215a2444a",
"labelName": "Sensitive"
}
},
{
"id": "/subscriptions/00000000-1111-2222-3333-444444444444/resourceGroups/myRG/providers/Microsoft.Synapse/workspaces/myServer/sqlPools/myDatabase/schemas/dbo/tables/myTable/columns/myColumn2/sensitivityLabels/recommended",
"name": "recommended",
"type": "Microsoft.Synapse/workspaces/sqlPools/schemas/tables/columns/sensitivityLabels",
"properties": {
"informationType": "Email",
"informationTypeId": "d22fa6e9-5ee4-3bde-4c2b-a409604c4646",
"labelId": "bf91e08c-f4f0-478a-b016-25164b2a65ff",
"labelName": "PII"
}
}
]
}
Definitions
Name | Description |
---|---|
Sensitivity |
A sensitivity label. |
Sensitivity |
A list of sensitivity labels. |
Sensitivity |
SensitivityLabel
A sensitivity label.
Name | Type | Description |
---|---|---|
id |
string |
Fully qualified resource ID for the resource. Ex - /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/{resourceProviderNamespace}/{resourceType}/{resourceName} |
managedBy |
string |
managed by |
name |
string |
The name of the resource |
properties.columnName |
string |
The column name. |
properties.informationType |
string |
The information type. |
properties.informationTypeId |
string |
The information type ID. |
properties.isDisabled |
boolean |
Is sensitivity recommendation disabled. Applicable for recommended sensitivity label only. Specifies whether the sensitivity recommendation on this column is disabled (dismissed) or not. |
properties.labelId |
string |
The label ID. |
properties.labelName |
string |
The label name. |
properties.rank | ||
properties.schemaName |
string |
The schema name. |
properties.tableName |
string |
The table name. |
type |
string |
The type of the resource. E.g. "Microsoft.Compute/virtualMachines" or "Microsoft.Storage/storageAccounts" |
SensitivityLabelListResult
A list of sensitivity labels.
Name | Type | Description |
---|---|---|
nextLink |
string |
Link to retrieve next page of results. |
value |
Array of results. |
SensitivityLabelRank
Name | Type | Description |
---|---|---|
Critical |
string |
|
High |
string |
|
Low |
string |
|
Medium |
string |
|
None |
string |