how to data masking with gsql?

maulcenter · February 20, 2022, 3:47pm

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

Bruno · February 21, 2022, 9:21am

@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

markmegerian · February 21, 2022, 2:40pm

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.

maulcenter · February 21, 2022, 5:48pm

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