Scrub data on Couchbase


Our Couchbase server (Enterprise Edition 6.0.2) stores user messages. As part of data security we want to scrub/remove Personally identifiable information(PII… like phone number, email, dob etc) when we take a backup of our Production data to our Stage/UAT environments.

We want to just replace a field, say “message_text”, with dummy data.

With cbbackup, we know that there’s an option to ignore this field with cbexport, but we DO want this field in our backup but with dummy data.

Is there a way we can handle this with cbbackup/cbrestore/cbexport/cbimport tools? Or will I have to write a process that will replace the text using N1QL? Or is there any better alternate?