- Categories:
String & binary functions (AI Functions)
AI_REDACT¶
Redacts personally identifiable information (PII) from unstructured text data.
Syntax¶
AI_REDACT( <input> [, <categories> ] )
Arguments¶
Required:
inputA VARCHAR value containing text data that may contain personally-identifiable information (PII).
Optional:
categoriesAn ARRAY of string values that specify the types of PII to be redacted. If not specified, all supported PII categories are redacted. See Detected PII categories for a list of supported categories.
Returns¶
A string containing placeholder values in place of redacted PII, for example [NAME] where the input text had “John Smith”.
Usage notes¶
For categories of PII that AI_REDACT can redact, see Detected PII categories.
For limitations in the current version of AI_REDACT, see Limitations.
Examples¶
See Examples.