All geek questions in one place

What operations does the bigquery.readonly scope allow?

The only documentation I can find in the area

https://www.googleapis.com/auth/bigquery.readonly

- This is an extremely useless short post here , which says: "View data in Bigquery." And I was looking tall and short.

What operations does this correspond to? Can a user run asynchronous jobs? Can they get completed jobs? Can they run synchronous jobs? With or without destination tables? I am looking for an area that allows you to run tabledata.list () or get completed results of asynchronous tasks (i.e. it doesn’t allow the user to run queries, but allows them to get data about the queries that were launched)

+5
source share
1 answer

Operations allowed using the read-only scope:

  • projects.list
  • datasets.get
  • datasets.list
  • tables.get
  • tables.list
  • tabledata.list
  • jobs.get
  • jobs.list
  • jobs.query
  • jobs.getQueryResults

This is from viewing the code, so the list should be canonical. Therefore, in response to your questions:

  • Can a user run asynchronous jobs? Only jobs.query (), which runs an asynchronous job under covers. (it often returns synchronously, but when it expires, you can get the results using jobs.getQueryResults ().
  • Can they get completed assignments? Yes ... with jobs.get () or jobs.getQueryResults ()
  • Can they run synchronous jobs? Only through jobs.query ().
  • With or without destination tables? jobs.query () does not support specifying a destination table, so no, destination tables are not supported in a read-only area.
+2
source

Source: https://habr.com/ru/post/1203110/

More articles:


All Articles