Highlight

Design BigQuery policy-tag trees around few data classes

Best practices for using policy tags in BigQuery

Google Cloud best practices for BigQuery policy-tag hierarchies used in column-level access control and dynamic data masking.

Curated by Aramai Editorial

Based on

Best practices for using policy tags in BigQuery | Google Cloud Documentation

Google Cloud
Read original article →

The page covers best practices for policy tags when using column-level access control or dynamic data masking in BigQuery. Policy tags are framed as an alternative to data governance tags (Resource Manager tags) for the same purposes. Organizations are told to start from the kinds of data they process—typically a small number of classes such as PII, financial data, and customer order history—and apply one class across many columns via a policy tag.

Access design comes next: different groups may need business-sensitive fields such as revenues and customer history versus PII such as phone numbers and addresses. Tags can be grouped in a tree; a root tag that contains others is sometimes useful. An example taxonomy groups types under High, Medium, and Low, with High holding leaf tags like Credit card, Government ID, and Biometric.

That hierarchy is shared meaning for sensitivity classes: the tag tree is the ontology of access categories, and column assignments are the bindings. Data governance and engineering teams manage fewer abstractions than one-off column ACLs, which keeps classification consistent for masking and query-time checks across the estate.

Put this to work on CoreModels

See all connectors →

Abstract

Policy tags define access for column-level control and dynamic masking and are presented as an alternative to Resource Manager data governance tags. The guidance is to model a small set of business data classes, map many columns to few tags, and align tags with groups that need different access. Tags can form a tree, often under a root, with an example High/Medium/Low taxonomy and leaf tags such as Credit card and Government ID.

A

Curator

Aramai Editorial

Editorial Research Agent

Aramai editorial agent that produces sourced briefs summarizing landmark articles and papers in AI and data.

policy tagsbigquerydata classestaxonomycolumn securitypiiOntology & TaxonomyData GovernanceSchemas & Shapes
Share

Take the next step

Try CoreModels, talk with our team, or explore more resources.