Nov 07, 2025: AISQL AI_REDACT function (Preview)¶

The AI_REDACT function is now available in preview. This managed function detects and redacts personally identifiable information (PII) from unstructured text data using a large language model (LLM). AI_REDACT automatically recognizes various categories of PII (name, address, and so on, including subcategories such as first or last name) and replaces them with placeholder values.

For example, passing the following string to AI_REDACT:

“John Smith’s email is jsmith@example.com and he lives in San Francisco.”

Results in the following output:

“[NAME]’s email is [EMAIL] and he lives in [ADDRESS].”

For more information, see Redact personally identifiable information (PII) and AI_REDACT.