Get-AzSynapseSqlPoolSensitivityRecommendation
Gets the recommended information types and sensitivity labels of columns in the SQL pool.
Syntax
Get-AzSynapseSqlPoolSensitivityRecommendation
-SqlPoolObject <PSSynapseSqlPool>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Get-AzSynapseSqlPoolSensitivityRecommendation
[-ResourceGroupName] <String>
[-WorkspaceName] <String>
[-SqlPoolName] <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>]
Description
The Get-AzSynapseSqlPoolSensitivityRecommendation cmdlet returns the recommended information types and sensitivity labels of columns in the SQL pool.
Examples
Example 1: Get recommended information types and sensitivity labels of an Azure Synapse SQL pool.
Get-AzSynapseSqlPoolSensitivityRecommendation -ResourceGroupName ContosoResourceGroup -WorkspaceName ContosoWorkspace -SqlPoolName ContosoSqlPool
ResourceGroupName : ContosoResourceGroup
WorkspaceName : ContosoWorkspace
SqlPoolName : ContosoSqlPool
SensitivityLabels : {{
SchemaName: dbo,
TableName: Report,
ColumnName: ReportEmailBody,
InformationType: Contact Info
}, {
SchemaName: dbo,
TableName: Report,
ColumnName: ReportEmailSubject,
SensitivityLabel: Confidential,
Rank: Medium
}, {
SchemaName: dbo,
TableName: EMailLog,
ColumnName: BounceEmailSubject,
SensitivityLabel: Confidential,
InformationType: Contact Info,
Rank: Medium
}}
Example 2: Get recommended information types and sensitivity labels of an Azure Synapse SQL pool using Piping.
Get-AzSynapseSqlPool -ResourceGroupName ContosoResourceGroup -WorkspaceName ContosoWorkspace -Name ContosoSqlPool | Get-AzSynapseSqlPoolSensitivityRecommendation
ResourceGroupName : ContosoResourceGroup
WorkspaceName : ContosoWorkspace
SqlPoolName : ContosoSqlPool
SensitivityLabels : {{
SchemaName: dbo,
TableName: Report,
ColumnName: ReportEmailBody,
InformationType: Contact Info
}, {
SchemaName: dbo,
TableName: Report,
ColumnName: ReportEmailSubject,
SensitivityLabel: Confidential,
Rank: Medium
}, {
SchemaName: dbo,
TableName: EMailLog,
ColumnName: BounceEmailSubject,
SensitivityLabel: Confidential,
InformationType: Contact Info,
Rank: Medium
}}
Parameters
-AsJob
Run cmdlet in the background
Type: | SwitchParameter |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-DefaultProfile
The credentials, account, tenant, and subscription used for communication with Azure.
Type: | IAzureContextContainer |
Aliases: | AzContext, AzureRmContext, AzureCredential |
Position: | Named |
Default value: | None |
Required: | False |
Accept pipeline input: | False |
Accept wildcard characters: | False |
-ResourceGroupName
Resource group name.
Type: | String |
Position: | 0 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-SqlPoolName
Name of Synapse SQL pool.
Type: | String |
Position: | 2 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-SqlPoolObject
SQL pool input object, usually passed through the pipeline.
Type: | PSSynapseSqlPool |
Position: | Named |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
-WorkspaceName
Name of Synapse workspace.
Type: | String |
Position: | 1 |
Default value: | None |
Required: | True |
Accept pipeline input: | True |
Accept wildcard characters: | False |
Inputs
Outputs
التعاون معنا على GitHub
يمكن العثور على مصدر هذا المحتوى على GitHub حيث يمكنك أيضاً إضافة مشاكل وطلبات سحب ومراجعتها. للحصول على معلومات إضافية، اطلع على دليل المساهم لدينا.
Azure PowerShell