custom_classifier!LIST

Lists each custom classification semantic category system tag with its associated

See also:

Working with custom classifiers

Syntax

SELECT <custom_classifier>!LIST()
Copy

Arguments

None.

Output

Returns a JSON object with the following structure:

{
  "semantic_category_name": {
    "col_name_regex": "string",
    "description": "string",
    "privacy_category": "string",
    "value_regex": "string"
   }
}
Copy

Each field value corresponds to the value that you specify when calling the custom_classifier!ADD_REGEX method.

Access control requirements

A role used to execute this SQL command must have the following privileges at a minimum:

Instance role

Object

Notes

custom_classifier!PRIVACY_USER.

The custom classifier instance.

The role that calls this method must be granted the instance role.

By default, the account role used to create the instance can call this method.

Note that operating on any object in a schema also requires the USAGE privilege on the parent database and schema.

For instructions on creating a custom role with a specified set of privileges, see Creating custom roles.

For general information about roles and privilege grants for performing SQL actions on securable objects, see Overview of Access Control.

Usage notes

Call each method in a separate SQL statement (no method chaining).

Examples

For a representative example, see the custom classification example.

Language: English