Israel Herraiz created BEAM-8458:
------------------------------------

             Summary: BigQueryIO.Read needs permissions to create datasets to 
run queries
                 Key: BEAM-8458
                 URL: https://issues.apache.org/jira/browse/BEAM-8458
             Project: Beam
          Issue Type: Bug
          Components: io-java-gcp
            Reporter: Israel Herraiz


When using `fromQuery`, BigQueryIO creates a temp dataset to store the results 
of the query.

Therefore, Beam requires permissions to create datasets just to be able to run 
a query. In practice, this means that Beam requires the role bigQuery.User just 
to run queries, whereas if you use `from` (to read from a table), the role 
bigQuery.jobUser suffices.

BigQueryIO.Read should have an option to set an existing dataset  to write the 
temp results of
a query, so it would be enough with having the role bigQuery.jobUser.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to