How do I mask data in an existing table?

Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat for MySQL, Navicat for PostgreSQL, Navicat for Oracle, Navicat for SQL Server, Navicat for SQLite, Navicat for MariaDB, Navicat for MongoDB, Navicat for Snowflake, Navicat Premium

Important: This method (masking data in existing tables) overwrites the data in the table directly. Back up the table before you start.

1. In the main window, choose Tools > Data Masking.
2. Select Mask data in existing tables and click Next.
3. Select the connection, database and schema, choose the table to modify and click Next.
4. Choose the columns that need protection and click Next.
5. Assign a masking technique to each selected column and click Next.
6. Review your settings and click Start.

Except for MongoDB, the table must have a primary key.