7.4 Ensure all data in BigQuery has been classified

Information

BigQuery tables can contain sensitive data that for security purposes should be discovered, monitored, classified, and protected. Google Cloud's Sensitive Data Protection tools can automatically provide data classification of all BigQuery data across an organization.

Rationale:

Using a cloud service or 3rd party software to continuously monitor and automate the process of data discovery and classification for BigQuery tables is an important part of protecting the data.

Sensitive Data Protection is a fully managed data protection and data privacy platform that uses machine learning and pattern matching to discover and classify sensitive data in Google Cloud.

Impact:

There is a cost associated with using Sensitive Data Protection. There is also typically a cost associated with 3rd party tools that perform similar processes and protection.

Solution

Enable profiling:

Go to Cloud DLP by visiting https://console.cloud.google.com/dlp/landing/dataProfiles/configurations

Click 'Create Configuration'

For projects follow https://cloud.google.com/dlp/docs/profile-project. For organizations or folders follow https://cloud.google.com/dlp/docs/profile-org-folder









Review findings:

Columns or tables with high data risk have evidence of sensitive information without additional protections. To lower the data risk score, consider doing the following:

For columns containing sensitive data, apply a BigQuery policy tag to restrict access to accounts with specific access rights.

De-identify the raw sensitive data using de-identification techniques like masking and tokenization.

Incorporate findings into your security and governance operations:

Enable sending findings into your security and posture services. You can publish data profiles to Security Command Center and Chronicle.

Automate remediation or enable alerting of new or changed data risk with Pub/Sub.

NOTE: Nessus has not performed this check. Please review the benchmark to ensure target compliance.

See Also

https://workbench.cisecurity.org/benchmarks/11843

Item Details

Category: AUDIT AND ACCOUNTABILITY, RISK ASSESSMENT, SYSTEM AND INFORMATION INTEGRITY

References: 800-53|AU-11, 800-53|RA-2, 800-53|SI-12, CSCv7|5.1

Plugin: GCP

Control ID: 957b6517dbbae70bb2f0094dc65c35e571ed6a6e72acb0671b535831532ca0a6