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时都要求进行验证？

我在这篇文章中发现了这个问题，但是解决方案已经过期：

Google BigQuery的Google App Engine授权

此错误意味着运行查询的用户未被授权在项目中运行作业（ triple-xxx-xxx ）。您需要通过开发者控制台将运行查询的用户添加到项目中（ https：//

回答您的其他一些问题：

• 您不需要创建一个clientid来使用bigquery。


• 我不确定是否有办法强制bigrquery重新创建，每次授权。也就是说，查看源代码（ https://github.com/ hadley / bigrquery / blob / master / R / auth.r ）您可以使用null调用set_access_cred来清除身份验证。

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屋！