<classification_profile_name>!SET_CUSTOM_CLASSIFIERS¶

Adds custom classifiers to an existing classification profile so sensitive data can be automatically classified with custom classification semantic and privacy categories.

Syntax¶

<classification_profile_name>!SET_CUSTOM_CLASSIFIERS( <object> )

Copy

Arguments¶

object

An OBJECT value that specifies the custom classifiers to add to the classification profile.

Each key in the object specifies the name of an instance of the CUSTOM_CLASSIFIER class.

The value of each key specifies the custom_classifier!LIST method of the custom classifier instance.

Returns¶

Returns a successful status message or an error message.

Access control requirements¶

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

Instance role	Object	Notes
`classification_profile`!PRIVACY_USER	The classification profile instance.	The account role that calls this method must be granted this instance role on the classification profile. The role used to create the instance is automatically granted this instance role.

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¶

Calling this method does not return the object. Because of this, you can’t use method chaining to call another method on the return value of this method. Instead, call each method in a separate SQL statement.

Examples¶

CALL my_classification_profile!SET_CUSTOM_CLASSIFIERS(
  {
    'medical_codes': medical_codes!list(),
    'finance_codes': finance_codes!list()
  });

Copy