How to apply De-identification template on BigQuery table

[prabhaA]

Couldn't find any good information on google documentation. 

Is it possible to apply the Cloud DLP de-identification template on the BQ table? Can you point me to the right resource pls?

Regards,

Prabha Arivalagan

[ste_google]

Hi Prabha,

There are a few options depending on what you want to do.  You can use various ETL pipelines (e.g. Dataflow or Data Fusion) to pull data from a BigQuery table and then make a de-identified copy of it before sharing.   You can also call DLP directly from a BigQuery UDF to get access to the engine at query time via SQL. 

Here are a few prototype solutions to help get you started:

• Using Cloud Storage (export smaller shards from BQ to GCS): 
  Introducing easier de-identification of Cloud Storage data
• Calling BigQuery from a remote UDF function
• Using Dataflow with DLP

Are any of those options helpful to try out?