custom_classifier!LIST

Lists each custom classification semantic category system tag with its associated regular expressions for the column name and values in the column, the description, and the privacy category tag.

See also:

Using custom classifiers

Syntax

<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",
    "threshold": number,
    "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

SELECT medical_codes!LIST();
Copy

Returns:

+--------------------------------------------------------------------------------+
| MEDICAL_CODES!LIST()                                                           |
+--------------------------------------------------------------------------------+
| {                                                                              |
|   "ICD-10-CODES": {                                                            |
|     "col_name_regex": "ICD.*",                                                 |
|     "description": "Add a regex to identify ICD-10 medical codes in a column", |
|     "privacy_category": "IDENTIFIER",                                          |
|     "threshold": 0.8,                                                          |
|     "value_regex": "[A-TV-Z][0-9][0-9AB]\.?[0-9A-TV-Z]{0,4}"                   |
|   }                                                                            |
| }                                                                              |
+--------------------------------------------------------------------------------+
Language: English