QuestionQ18
VerifiedPreparing and using data for analysisYou have a BigQuery dataset called customers. All tables will be tagged using a Data Catalog tag template named gdpr. The template includes one mandatory Boolean field, has_sensitive_data.
All employees must be able to perform a simple search to locate tables in the dataset where has_sensitive_data is either true or false. However, only the Human Resources (HR) group must be able to view the data in tables where has_sensitive_data is true. You grant the all-employees group the bigquery.metadataViewer and bigquery.connectionUser roles on the dataset. You want to minimize configuration overhead. What should you do next?
Community Discussion