BigQuery query for table_type View without parent table's permission

Question

I am facing a unique problem. My service account has BigQuery data view permission for a view (table_type). But no permission for parents tables from which view is created. Now, How can I query on the view table without the parent table's permission?

Answer 1

You can use so called authorized views for this

Giving a view access to a dataset is also known as creating an authorized view in BigQuery. An authorized view allows you to share query results with particular users and groups without giving them access to the underlying source data. You can also use the view's SQL query to restrict the columns (fields) the users are able to query.

See the tutorial for Creating an authorized view