Get-AzSynapseSqlPoolSensitivityClassification
Gets the current information types and sensitivity labels of columns in the SQL pool.
Syntax
Get-AzSynapseSqlPoolSensitivityClassification
-SqlPoolObject <PSSynapseSqlPool>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>] Get-AzSynapseSqlPoolSensitivityClassification
[-ResourceGroupName] <String>
[-WorkspaceName] <String>
[-SqlPoolName] <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>] Get-AzSynapseSqlPoolSensitivityClassification
[-ResourceGroupName] <String>
[-WorkspaceName] <String>
[-SqlPoolName] <String>
-SchemaName <String>
-TableName <String>
-ColumnName <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>] Get-AzSynapseSqlPoolSensitivityClassification
-SqlPoolObject <PSSynapseSqlPool>
-SchemaName <String>
-TableName <String>
-ColumnName <String>
[-AsJob]
[-DefaultProfile <IAzureContextContainer>]
[<CommonParameters>] Description
The Get-AzSynapseSqlPoolSensitivityClassification cmdlet returns the current information types and sensitivity labels of columns in the Azure Synapse SQL pool.
Examples
Example 1: Get current information types and sensitivity labels of an Azure Synapse SQL pool.
Get-AzSynapseSqlPoolSensitivityClassification -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 current information types and sensitivity labels of an Azure Synapse SQL pool with Piping.
Get-AzSynapseSqlPool -ResourceGroupName ContosoResourceGroup -WorkspaceName ContosoWorkspace -SqlPoolName ContosoSqlPool | Get-AzSynapseSqlPoolSensitivityClassification
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 3: Get current information type and sensitivity label of a specific column of an Azure Synapse SQL pool.
Get-AzSynapseSqlPoolSensitivityClassification -ResourceGroupName ContosoResourceGroup -WorkspaceName ContosoWorkspace -SqlPoolName ContosoSqlPool -SchemaName dbo -TableName EMailLog -ColumnName BounceEmailSubject
ResourceGroupName : ContosoResourceGroup
WorkspaceName : ContosoWorkspace
SqlPoolName : ContosoSqlPool
SensitivityLabels : {{
SchemaName: dbo,
TableName: EMailLog,
ColumnName: BounceEmailSubject,
SensitivityLabel: Confidential,
InformationType: Contact Info,
Rank: Medium
}}Example 4: Get current information type and sensitivity label of a specific column of an Azure Synapse SQL pool using Piping.
Get-AzSynapseSqlPool -ResourceGroupName ContosoResourceGroup -WorkspaceName ContosoWorkspace -Name ContosoSqlPool | Get-AzSynapseSqlPoolSensitivityClassification -SchemaName dbo -TableName EMailLog -ColumnName BounceEmailSubject
ResourceGroupName : ContosoResourceGroup
WorkspaceName : ContosoWorkspace
SqlPoolName : ContosoSqlPool
SensitivityLabels : {{
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 |
-ColumnName
Name of column.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| 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 |
-SchemaName
Name of schema.
| Type: | String |
| Position: | Named |
| 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 |
-TableName
Name of table.
| Type: | String |
| 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 |