Jump to Content
Data Analytics

Scan BigQuery for sensitive data using Cloud DLP

May 31, 2019
Adam Gavish

Product Manager, VPC Service Controls

Michael Saunders

Product Manager, BigQuery

Preventing the exposure of sensitive data is critically important for many businesses—particularly those that operate in industries with substantial compliance needs, such as finance and healthcare. Cloud Data Loss Prevention (DLP) can help meet those needs and protect sensitive data through data discovery, classification, and redaction. But in some cases, you might need more awareness and quick access to Cloud DLP capabilities in the context of other GCP services such as BigQuery. Today, we’re making it easier to discover, and classify sensitive data in BigQuery with the Scan with DLP button. This new feature makes it possible to run DLP scans with just a few clicks, directly from the BigQuery UI.

Cloud DLP in action

Here’s what you can do:

  • Detect common sensitive data types such as credit card numbers or custom sensitive data types to highlight intellectual property or proprietary business information.
  • Create triggers for automatic Cloud DLP scan scheduling.
  • Publish Cloud DLP scan findings to BigQuery and Cloud Security Command Center for further analysis and reporting.
  • De-identify and obfuscate sensitive data.
  • Use the Cloud DLP UI (Beta) to create, manage, and trigger DLP scans across multiple GCP services, such as BigQuery, Cloud Storage, and Datastore.
  • Scan a subset of your entire dataset using the sampling feature to keep your Cloud DLP costs under control.

Today, BigQuery customers can start using Cloud DLP to scan for sensitive data with a few clicks, following these simple steps:

1. Browse to a particular BigQuery table and choose Scan with DLP from the Export menu.


2. Complete the Cloud DLP scan job creation with a click, or specify custom configurations such as information types to scan, sampling versus full scanning, post-scan actions, and more.


3. Once a Cloud DLP scan is completed, you will receive an email with links to the scan details page where you can analyze findings and take further actions.

You can also quickly scan your other cloud-based data repositories with the Data Loss Prevention (DLP) user interface, now available in beta. Through this new interface, you can run DLP scans with just a few clicks—no code required, and no hardware or VMs to manage. Get started today in the GCP console.

To learn more, check out our Cloud DLP documentation.

Posted in