Security

Data Masking

A technique that obscures sensitive data by replacing it with realistic but fake values to protect privacy.

In Depth

Data masking (also called data obfuscation or anonymization) is the process of replacing sensitive data with realistic but fictitious values. This protects personally identifiable information (PII), financial data, health records, and other sensitive information while preserving the data's format and usability for development, testing, and analytics. Types include static masking (permanently replaces data in a copy), dynamic masking (obscures data at query time based on user permissions), and tokenization (replaces sensitive values with tokens that can be reversed with a secure lookup). Common masking techniques include substitution, shuffling, encryption, nulling out, and format-preserving transformation.

How AI for Database Helps

AI for Database supports dynamic data masking so sensitive fields are automatically obscured for users without appropriate permissions.

Related Terms

Ready to try AI for Database?

Query your database in plain English. No SQL required. Start free today.