Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

For more information on setting up service account access to specific BigQuery datasets, see https://cloud.google.com/bigquery/docs/dataset-access-controls#controlling_access_to_a_dataset.

Grant access to BigQuery authorized views

In this scenario, the 

D s product
productdp
project is attempting to access a BigQuery authorized view in another target project. This view is connected to an underlying BigQuery dataset. The following additional permissions are required:

  • Google IAM: The BigQuery User  permission must be granted to any
    D s product
    productdp
    user account or service account that is trying to access the target project.
  • BigQuery: In the target project, the BigQuery Data Viewer  permission must be granted to any
    D s product
    productdp
    user account or service account that is trying to access the target project.
  • The view must be an authorized view.
  • The table dataset underlying the authorized view must grant permissions to the view. For more information, see https://cloud.google.com/bigquery/docs/share-access-views.

D s also
inCQLtrue
label((label = "bigquery") OR (label = "cross-project"))