az synapse sql pool classification
Manage sensitivity classifications.
Commands
Name | Description | Type | Status |
---|---|---|---|
az synapse sql pool classification create |
Create a column's sensitivity classification. |
Core | GA |
az synapse sql pool classification delete |
Delete the sensitivity classification of a given column. |
Core | GA |
az synapse sql pool classification list |
Get the sensitivity classifications of a given SQL pool. |
Core | GA |
az synapse sql pool classification recommendation |
Manage sensitivity classification recommendations. |
Core | GA |
az synapse sql pool classification recommendation disable |
Disable sensitivity recommendations for a given column(recommendations are enabled by default on all columns). |
Core | GA |
az synapse sql pool classification recommendation enable |
Enable sensitivity recommendations for a given column(recommendations are enabled by default on all columns). |
Core | GA |
az synapse sql pool classification recommendation list |
List the recommended sensitivity classifications of a given SQL pool. |
Core | GA |
az synapse sql pool classification show |
Get the sensitivity classification of a given column. |
Core | GA |
az synapse sql pool classification update |
Update a column's sensitivity classification. |
Core | GA |
az synapse sql pool classification create
Create a column's sensitivity classification.
az synapse sql pool classification create --column
--information-type
--label
--name
--resource-group
--schema
--table
--workspace-name
Examples
Create sensitivity classification for a given column.
az synapse sql pool classification create --name sqlpool --workspace-name testsynapseworkspace \
--resource-group rg --schema dbo --table mytable --column mycolumn \
--information-type Name --label "Confidential - GDPR"
Required Parameters
The name of column.
The information type.
The label name.
The SQL pool name.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
The name of schema.
The name of table.
The workspace name.
Global Parameters
Increase logging verbosity to show all debug logs.
Property | Value |
---|---|
Default value: | False |
Show this help message and exit.
Only show errors, suppressing warnings.
Property | Value |
---|---|
Default value: | False |
Output format.
Property | Value |
---|---|
Default value: | json |
Accepted values: | json, jsonc, none, table, tsv, yaml, yamlc |
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Property | Value |
---|---|
Default value: | False |
az synapse sql pool classification delete
Delete the sensitivity classification of a given column.
az synapse sql pool classification delete --column
--schema
--table
[--ids]
[--name]
[--resource-group]
[--subscription]
[--workspace-name]
Examples
Delete the sensitivity classification of a given column.
az synapse sql pool classification delete --name sqlpool --workspace-name testsynapseworkspace --resource-group rg \
--schema dbo --table mytable --column mycolumn
Required Parameters
The name of column.
The name of schema.
The name of table.
Optional Parameters
The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.
One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
The SQL pool name.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
The workspace name.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Global Parameters
Increase logging verbosity to show all debug logs.
Property | Value |
---|---|
Default value: | False |
Show this help message and exit.
Only show errors, suppressing warnings.
Property | Value |
---|---|
Default value: | False |
Output format.
Property | Value |
---|---|
Default value: | json |
Accepted values: | json, jsonc, none, table, tsv, yaml, yamlc |
JMESPath query string. See http://jmespath.org/ for more information and examples.
Increase logging verbosity. Use --debug for full debug logs.
Property | Value |
---|---|
Default value: | False |
az synapse sql pool classification list
Get the sensitivity classifications of a given SQL pool.
az synapse sql pool classification list --name
--resource-group
--workspace-name
[--filter]
Examples
List the sensitivity classification of a given SQL pool.
az synapse sql pool classification list --name sqlpool --workspace-name testsynapseworkspace --resource-group rg
Required Parameters
The SQL pool name.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
The workspace name.
Optional Parameters
The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.
An OData filter expression that filters elements in the collection. Default value is None.
Global Parameters
Increase logging verbosity to show all debug logs.
Property | Value |
---|---|
Default value: | False |
Show this help message and exit.
Only show errors, suppressing warnings.
Property | Value |
---|---|
Default value: | False |
Output format.
Property | Value |
---|---|
Default value: | json |
Accepted values: | json, jsonc, none, table, tsv, yaml, yamlc |
JMESPath query string. See http://jmespath.org/ for more information and examples.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity. Use --debug for full debug logs.
Property | Value |
---|---|
Default value: | False |
az synapse sql pool classification show
Get the sensitivity classification of a given column.
az synapse sql pool classification show --column
--schema
--table
[--ids]
[--name]
[--resource-group]
[--subscription]
[--workspace-name]
Examples
Get the sensitivity classification of a given column.
az synapse sql pool classification show --name sqlpool --workspace-name testsynapseworkspace --resource-group rg \
--schema dbo --table mytable --column mycolumn
Required Parameters
The name of column.
The name of schema.
The name of table.
Optional Parameters
The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.
One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
The SQL pool name.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
The workspace name.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Global Parameters
Increase logging verbosity to show all debug logs.
Property | Value |
---|---|
Default value: | False |
Show this help message and exit.
Only show errors, suppressing warnings.
Property | Value |
---|---|
Default value: | False |
Output format.
Property | Value |
---|---|
Default value: | json |
Accepted values: | json, jsonc, none, table, tsv, yaml, yamlc |
JMESPath query string. See http://jmespath.org/ for more information and examples.
Increase logging verbosity. Use --debug for full debug logs.
Property | Value |
---|---|
Default value: | False |
az synapse sql pool classification update
Update a column's sensitivity classification.
az synapse sql pool classification update --column
--schema
--table
[--ids]
[--information-type]
[--label]
[--name]
[--resource-group]
[--subscription]
[--workspace-name]
Examples
Update sensitivity classification for a given column.
az synapse sql pool classification update --name sqlpool --workspace-name testsynapseworkspace \
--resource-group rg --schema dbo --table mytable --column mycolumn \
--information-type Name --label "Confidential - GDPR"
Required Parameters
The name of column.
The name of schema.
The name of table.
Optional Parameters
The following parameters are optional, but depending on the context, one or more might become required for the command to execute successfully.
One or more resource IDs (space-delimited). It should be a complete resource ID containing all information of 'Resource Id' arguments. You should provide either --ids or other 'Resource Id' arguments.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
The information type.
The label name.
The SQL pool name.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
The workspace name.
Property | Value |
---|---|
Parameter group: | Resource Id Arguments |
Global Parameters
Increase logging verbosity to show all debug logs.
Property | Value |
---|---|
Default value: | False |
Show this help message and exit.
Only show errors, suppressing warnings.
Property | Value |
---|---|
Default value: | False |
Output format.
Property | Value |
---|---|
Default value: | json |
Accepted values: | json, jsonc, none, table, tsv, yaml, yamlc |
JMESPath query string. See http://jmespath.org/ for more information and examples.
Increase logging verbosity. Use --debug for full debug logs.
Property | Value |
---|---|
Default value: | False |