Cannot add metadata to BigQuery views

142 Views Asked by At

BigQuery views cannot be assigned a primarykey or policy tag. I'd like to give both views and tables the same metadata in the same way.

1

There are 1 best solutions below

0
On

According to the google cloud documentation :

Views are derived from an underlying table. The same column-level access control on the table applies when the protected columns are accessed through a view. There are two kinds of views in BigQuery, logical views and authorized views. Both types of views are derived from a source table, and both are consistent with the table's column-level access control.

So for your requirements you can consider applying the policy tag directly to the BigQuery table.Almost similar type of a feature request filed for the same. You can vote for this feature by clicking the +1 and *STAR* mark to receive updates on it.

For more information you can refer to these link1 and link2.