clouddata-maskingsensitive-datagoogle-cloud-dlpsql-masking

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


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?


Solution

  • 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