az sql db classification

Manage sensitivity classifications.

Commands

az sql db classification delete

Delete the sensitivity classification of a given column.

az sql db classification list

Get the sensitivity classifications of a given database.

az sql db classification recommendation

Manage sensitivity classification recommendations.

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 show

Get the sensitivity classification of a given column.

az sql db classification update

Update a columns's sensitivity classification.

az sql db classification delete

Delete the sensitivity classification of a given column.

az sql db classification delete --column
                                --schema
                                --table
                                [--ids]
                                [--name]
                                [--resource-group]
                                [--server]
                                [--subscription]

Examples

Delete the sensitivity classification of a given column.

az sql db classification delete -g mygroup -s myserver -n mydb --schema dbo --table mytable --column mycolumn

Required Parameters

--column

The name of the column.

--schema

The name of the schema.

--table

The name of the table.

Optional Parameters

--ids

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 -n

Name of the Azure SQL Database.

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

--server -s

Name of the Azure SQL server. You can configure the default using az configure --defaults sql-server=<name>.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

az sql db classification list

Get the sensitivity classifications of a given database.

az sql db classification list [--filter]
                              [--ids]
                              [--name]
                              [--query-examples]
                              [--resource-group]
                              [--server]
                              [--subscription]

Examples

List the sensitivity classification of a given database.

az sql db classification list -g mygroup -s myserver -n mydb

Optional Parameters

--filter

An OData filter expression that filters elements in the collection.

--ids

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 -n

Name of the Azure SQL Database.

--query-examples

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.

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

--server -s

Name of the Azure SQL server. You can configure the default using az configure --defaults sql-server=<name>.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

az sql db classification show

Get the sensitivity classification of a given column.

az sql db classification show --column
                              --schema
                              --table
                              [--ids]
                              [--name]
                              [--query-examples]
                              [--resource-group]
                              [--server]
                              [--subscription]

Examples

Get the sensitivity classification of a given column.

az sql db classification show -g mygroup -s myserver -n mydb --schema dbo --table mytable --column mycolumn

Required Parameters

--column

The name of the column.

--schema

The name of the schema.

--table

The name of the table.

Optional Parameters

--ids

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 -n

Name of the Azure SQL Database.

--query-examples

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.

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

--server -s

Name of the Azure SQL server. You can configure the default using az configure --defaults sql-server=<name>.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.

az sql db classification update

Update a columns's sensitivity classification.

az sql db classification update --column
                                --schema
                                --table
                                [--ids]
                                [--information-type]
                                [--label]
                                [--name]
                                [--resource-group]
                                [--server]
                                [--subscription]

Examples

Update sensitivity classification for a given column.

az sql db classification update -g mygroup -s myserver -n mydb --schema dbo --table mytable --column mycolumn --information-type Name --label "Confidential - GDPR"

Required Parameters

--column

The name of the column.

--schema

The name of the schema.

--table

The name of the table.

Optional Parameters

--ids

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.

--information-type

The information type.

--label

The label name.

--name -n

Name of the Azure SQL Database.

--resource-group -g

Name of resource group. You can configure the default group using az configure --defaults group=<name>.

--server -s

Name of the Azure SQL server. You can configure the default using az configure --defaults sql-server=<name>.

--subscription

Name or ID of subscription. You can configure the default subscription using az account set -s NAME_OR_ID.