BigRquery - RUN_QUERY_JOB [英] BigRquery - RUN_QUERY_JOB
问题描述
devtools :: install_github(hadley / bigrquery)
library(bigrquery)
当我尝试提取数据时,出现此错误:
错误:访问被拒绝:作业triple-xxx-xxx:job_zu6P-qSxxx7DBVICij6_QyDv0:RUN_QUERY_JOB
我在这里和网上看过,每个人都说你只需要两件事就可以从Google BigQuery中提取数据:
1.为它设置一个项目(启用BigQuery):
$ b 2.为BigQuery设置帐单地址。
我已经这样做了,但仍然遇到了问题。
IMPORTAT:
对于其他包与Google产品(Google Analytics)进行互动,例如RGA;你需要创建一个客户端ID(OAUTH),我需要用bigrquery吗?
有人可以更新方法来获取数据?
Ps。我可以通过浏览器获取数据(使用Google提供的Web界面)。但不是从bigrquery的R中 - 我使用的是CRAN上托管的版本。
Ps2。我不希望验证码存储在缓存中,是否有办法让bigrquery在每次尝试连接到BigQuery时都要求进行验证?
我在这篇文章中发现了这个问题,但是解决方案已经过期:
此错误意味着运行查询的用户未被授权在项目中运行作业( triple-xxx-xxx
)。您需要通过开发者控制台将运行查询的用户添加到项目中( https://
回答您的其他一些问题:
I've installed "bigrquery" like this:
devtools::install_github("hadley/bigrquery")
library(bigrquery)
And i get this error, when trying to extract data:
Error: Access Denied: Job triple-xxx-xxx:job_zu6P-qSxxx7DBVICij6_QyDv0: RUN_QUERY_JOB
I've looked here and on the web and everyone says that you just need 2 things to extrac data from Google BigQuery:
1.-Have a Project for it (BigQuery Enabled):
2.-Put a billing address for BigQuery.
I've done that, but still got the problem.
IMPORTAT: For other packages that interact with Google products (Google Analytics), e.g RGA; you need to create a Client ID (OAUTH), do i need to to this with "bigrquery"???
Someone can update the method to get the data?
Ps. I can get the data in the broswer (with the Web Interface provided by Google). But not in R from "bigrquery" - I'm using the version hosted on CRAN.
Ps2. I don't want that the "authentications" to be stored in the cache, is there a way to make "bigrquery" to ask for authentication everytime it tries to connect to BigQuery?
I found this issue on this post, but with the solution out-of-date:
Google App Engine authorization for Google BigQuery
This error means that the user that was running the query was not authorized to run jobs in the project (triple-xxx-xxx
). You'd need to add the user that is running the query to the project via the developers console (https://console.developers.google.com/project).
To answer some of your other questions:
- You don't need to create a clientid to use bigquery.
- I'm not sure if there is a way to force bigrquery to re-authorize every time. That said, looking at the source code (https://github.com/hadley/bigrquery/blob/master/R/auth.r) you may be able to call set_access_cred with null to clear the authentication.
这篇关于BigRquery - RUN_QUERY_JOB的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!