az sql db classification recommendation
Manage sensitivity classification recommendations.
Commands
az sql db classification recommendation disable |
Disable sensitivity recommendations for a given column (recommendations are enabled by default on all columns). |
az sql db classification recommendation enable |
Enable sensitivity recommendations for a given column (recommendations are enabled by default on all columns). |
az sql db classification recommendation list |
List the recommended sensitivity classifications of a given database. |
az sql db classification recommendation disable
Disable sensitivity recommendations for a given column (recommendations are enabled by default on all columns).
az sql db classification recommendation disable --column
--schema
--table
[--ids]
[--name]
[--resource-group]
[--server]
[--subscription]
Examples
Disable sensitivity recommendations for a given column.
az sql db classification recommendation disable -g mygroup -s myserver -n mydb --schema dbo --table mytable --column mycolumn
Required Parameters
The name of the column.
The name of the schema.
The name of the table.
Optional Parameters
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.
Name of the Azure SQL Database.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name of the Azure SQL server. You can configure the default using az configure --defaults sql-server=<name>
.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Increase logging verbosity. Use --debug for full debug logs.
az sql db classification recommendation enable
Enable sensitivity recommendations for a given column (recommendations are enabled by default on all columns).
az sql db classification recommendation enable --column
--schema
--table
[--ids]
[--name]
[--resource-group]
[--server]
[--subscription]
Examples
Enable sensitivity recommendations for a given column.
az sql db classification recommendation enable -g mygroup -s myserver -n mydb --schema dbo --table mytable --column mycolumn
Required Parameters
The name of the column.
The name of the schema.
The name of the table.
Optional Parameters
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.
Name of the Azure SQL Database.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name of the Azure SQL server. You can configure the default using az configure --defaults sql-server=<name>
.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Increase logging verbosity. Use --debug for full debug logs.
az sql db classification recommendation list
List the recommended sensitivity classifications of a given database.
az sql db classification recommendation list [--filter]
[--ids]
[--include-disabled-recommendations]
[--name]
[--query-examples]
[--resource-group]
[--server]
[--subscription]
Examples
List the recommended sensitivity classifications of a given database.
az sql db classification recommendation list -g mygroup -s myserver -n mydb
Optional Parameters
An OData filter expression that filters elements in the collection.
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.
Specifies whether to include disabled recommendations or not.
Name of the Azure SQL Database.
Recommend JMESPath string for you. You can copy one of the query and paste it after --query parameter within double quotation marks to see the results. You can add one or more positional keywords so that we can give suggestions based on these key words.
Name of resource group. You can configure the default group using az configure --defaults group=<name>
.
Name of the Azure SQL server. You can configure the default using az configure --defaults sql-server=<name>
.
Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID
.
Increase logging verbosity to show all debug logs.
Show this help message and exit.
Only show errors, suppressing warnings.
Output format.
JMESPath query string. See http://jmespath.org/ for more information and examples.
Increase logging verbosity. Use --debug for full debug logs.