SHOW CLASSIFICATION_PROFILE¶

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

列出所有分类配置文件实例。

语法

SHOW SNOWFLAKE.DATA_PRIVACY.CLASSIFICATION_PROFILE
  [ 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.

访问控制要求

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

权限/角色	对象	备注
<classification_profile>!PRIVACY_USER instance role	不适用

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.CLASSIFICATION_PROFILE;