<code className=”samp”><em>custom_classifier</em></code>!LIST

列出每个自定义分类语义类别系统标签及其在列中的列名和列值关联的正则表达式、描述和隐私类别标签。

See also:

Using custom classifiers to implement custom semantic categories

语法

<custom_classifier>!LIST()

实参

无。

输出

返回一个 JSON 对象，其结构如下：

{
  "semantic_category_name": {
    "col_name_regex": "string",
    "description": "string",
    "privacy_category": "string",
    "threshold": number,
    "value_regex": "string"
   }
}

Each field value corresponds to the value that you specify when calling the <code className=”samp”><em>custom_classifier</em></code>!ADD_REGEX method.

访问控制要求

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

Instance roleObjectNotes
custom_classifier!PRIVACY_USERThe custom classifier instance.

调用此方法的角色必须被授予实例角色。

默认情况下，用于创建实例的账户角色可以调用此方法。

Operating on an object in a schema requires at least one privilege on the parent database and at least one privilege on the parent 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.

使用说明

在单独的 SQL 语句中调用每个方法（无需方法链接）。

示例

SELECT internal_ids!LIST();

Returns:

+--------------------------------------------------------------------------------+
| INTERNAL_IDS!LIST()                                                            |
+--------------------------------------------------------------------------------+
| {                                                                              |
|   "EMPLOYEE_ID": {                                                             |
|     "col_name_regex": "EMP.*ID.*",                                             |
|     "description": "Add a regex to identify employee IDs in a column",         |
|     "privacy_category": "IDENTIFIER",                                          |
|     "threshold": 0.8,                                                          |
|     "value_regex": "^[0-9]{6}$"                                                |
|   }                                                                            |
| }                                                                              |
+--------------------------------------------------------------------------------+