I want to Redact Names in my feedback column how can i achieve this in DBT Macro?

Help
,
1

The problem I’m having:

I want to Redact Names in my feedback column how can i achieve this in dbt Macro?

The context of why I’m trying to do this:

to redact the PII data like user names

What I’ve already tried:

tried dbt macro but was not successfully please, help me to redact the names in my column and its a free text column so i just want to redact names.

Note:my project does not allow any use of AI functions