How to mask a specified field in a table when I query it using big query?

Question

I want to mask a specified field in a table when I query it using big query. For example: a table named employee has email-id column, so when I query the table all the email-id field should be masked with ****.

How can I do it using DLP in google?

Does this article helps you? https://cloud.google.com/solutions/validating-de-identified-data-bigquery-re-identifying-pii-data — rmesteves, May 22 '20 at 14:28

score 0 · Accepted Answer · answered Jul 14 '20 at 16:44

At the moment, there isn't a way to do this with Cloud DLP/Bigquery during the time of the query.

Possible work around options

You could create a de-identified copy of your table and query that instead
You could use column level acls to hide this column from folks who shouldn't see the email addresses https://cloud.google.com/bigquery/docs/column-level-security-intro

How to mask a specified field in a table when I query it using big query?

1 Answers1