CREATE CUSTOM_CLASSIFIER¶

Fully qualified name: SNOWFLAKE.DATA_PRIVACY.CUSTOM_CLASSIFIER

See also:: Using custom classifiers for sensitive data classification

Creates a new custom classification instance or replaces an existing custom classification instance in the current or specified schema.

Syntax¶

CREATE [ OR REPLACE ] SNOWFLAKE.DATA_PRIVACY.CUSTOM_CLASSIFIER
[ IF NOT EXISTS ] <custom_classifier_name>()

Copy

Parameters¶

custom_classifier_name()

Specifies the identifier (name) for the instance; the name must be unique for the schema in which the object is created. You must add the parentheses at the end of the identifier when creating the object.

In addition, the identifier must start with an alphabetic character and cannot contain spaces or special characters unless the entire identifier string is enclosed in double quotes (for example, "My object"). Identifiers enclosed in double quotes are also case-sensitive.

For more information, see Identifier requirements.

Arguments¶

None.

Access control requirements¶

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

Database role	Object	Notes
CLASSIFICATION_ADMIN	Database role	The account role that creates the object must be granted this database role. This database role exists in the shared SNOWFLAKE database.

Database role

Object

Notes

CLASSIFICATION_ADMIN

Database role

The account role that creates the object must be granted this database role.

This database role exists in the shared SNOWFLAKE database.

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.

Methods¶

You can call the following methods on the custom classification instance that you create:

Usage notes¶

SNOWFLAKE.DATA_PRIVACY.CUSTOM_CLASSIFIER is a name that Snowflake defines and maintains. Use this object name every time you want to create an instance of this class. Alternatively, update your search path to make it easier to use the instance.

Examples¶

Create a custom classifier named medical_codes:

CREATE OR REPLACE SNOWFLAKE.DATA_PRIVACY.CUSTOM_CLASSIFIER medical_codes();

Copy