SHOW CUSTOM_CLASSIFIER¶

完全限定名称 ：SNOWFLAKE.DATA_PRIVACY.CUSTOM_CLASSIFIER

See also:: Using custom classifiers to implement custom semantic categories

列出您可以访问的所有自定义分类实例。

SHOW SNOWFLAKE.DATA_PRIVACY.CUSTOM_CLASSIFIERSHOW SNOWFLAKE.DATA_PRIVACY.CUSTOM_CLASSIFIER 是 INSTANCES 的别名。

语法

{
  SHOW SNOWFLAKE.DATA_PRIVACY.CUSTOM_CLASSIFIER           |
  SHOW SNOWFLAKE.DATA_PRIVACY.CUSTOM_CLASSIFIER INSTANCES
}
  [ LIKE <pattern> ]
  [ IN
    {
      ACCOUNT                  |

      DATABASE                 |
      DATABASE <database_name> |

      SCHEMA                   |
      SCHEMA <schema_name>     |
      <schema_name>
    }
  ]

参数

LIKE 'pattern'

Optionally filters the command output by object name. The filter uses case-insensitive pattern matching, with support for SQL wildcard characters (% and _).

For example, the following patterns return the same results:

... LIKE '%testing%' ... ... LIKE '%TESTING%' ...

Default: No value (no filtering is applied to the output).

[ IN ... ]

Optionally specifies the scope of the command. Specify one of the following:

ACCOUNT

Returns records for the entire account.

DATABASE, DATABASE db_name

Returns records for the current database in use or for a specified database (db_name).

If you specify DATABASE without db_name and no database is in use, the keyword has no effect on the output.

Note

Using SHOW commands without an IN clause in a database context can result in fewer than expected results.

Objects with the same name are only displayed once if no IN clause is used. For example, if you have table t1 in schema1 and table t1 in schema2, and they are both in scope of the database context you’ve specified (that is, the database you’ve selected is the parent of schema1 and schema2), then SHOW TABLES only displays one of the t1 tables.

SCHEMA, SCHEMA schema_name

Returns records for the current schema in use or a specified schema (schema_name).

SCHEMA is optional if a database is in use or if you specify the fully qualified schema_name (for example, db.schema).

If no database is in use, specifying SCHEMA has no effect on the output.

If you omit IN ..., the scope of the command depends on whether the session currently has a database in use:

If a database is currently in use, the command returns the objects you have privileges to view in the database. This has the same effect as specifying IN DATABASE.
If no database is currently in use, the command returns the objects you have privileges to view in your account. This has the same effect as specifying IN ACCOUNT.

使用说明

The order of results is not guaranteed.

访问控制要求

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

权限	对象	备注
OWNERSHIP	自定义分类实例。	具有 ACCOUNTADMIN 管理员角色的用户可以使用此命令列出实例。

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.

输出

在以下列中提供自定义分类器实例属性和元数据：

列	描述
created_on	自定义分类实例的创建日期和时间。
name	自定义分类实例的名称。
database_name	存储自定义分类实例的数据库。
schema_name	存储自定义分类实例的架构。
current_version	自定义分类实例的版本。Snowflake 会自动更新版本号。
comment	为自定义分类实例添加注释。
owner	拥有自定义分类实例的角色。

示例

列出您可以访问的所有自定义分类器：

SHOW SNOWFLAKE.DATA_PRIVACY.CUSTOM_CLASSIFIER;

Returns:

+----------------------------------+---------------+---------------+-------------+-----------------+---------+-------------+
| created_on                       | name          | database_name | schema_name | current_version | comment | owner       |
+----------------------------------+---------------+---------------+-------------+-----------------+---------+-------------+
| 2023-09-08 07:00:00.123000+00:00 | INTERNAL_IDS  | DATA          | CLASSIFIERS | 1.0             | None    | DATA_OWNER  |
+----------------------------------+---------------+---------------+-------------+-----------------+---------+-------------+