how to data masking with gsql?

I have a database containing sensitive data, can we write a gsql query to perform data masking e.g masking data credit number, email, etc

@maulcenter currently you can use the combination of accumulating and string function to mask data , i.e.

lpad(right(v.creditcardnumber, 3), 16, "*")

result should be something like *************123

Bruno

1 Like

Also, consider that if there are sensitive values within attributes of a vertex, you can write your GSQL to not include the sensitive values at all.

Please give a few more details on whether you want to partially mask the values, or just not expose them at all.

yeah, I want to partially mask the values. e.g., don’t hide the last 4 digits, the rest are hide