BigQuery API查询作业在使用魔法请求bigquery时返回404,尽管数据集存在。

huangapple go评论84阅读模式
英文:

BigQuery API query job return 404 for existing dataset, while using the magic request bigquery?

问题

I have set up a bigquery client with complete authentication, then tried to fetch the dataframe using a magic request

  1. from google.colab import auth
  2. auth.authenticate_user()
  3. print('Authenticated')
  4. %%bigquery df
  5. select * from `project_id.dataset.table`

I'm getting the following error

  1. The requested URL <code>/bigquery/v2/projects//jobs?prettyPrint=false</code> was not found on this server.

Can anyone tell me what's the problem?

英文:

I have set up a bigquery client with complete authentication, then tried to fetch the dataframe using a magic request

  1. from google.colab import auth
  2. auth.authenticate_user()
  3. print(&#39;Authenticated&#39;)
  4. %%bigquery df
  5. select * from `project_id.dataset.table`

I'm getting the following error

  1. The requested URL &lt;code&gt;/bigquery/v2/projects//jobs?prettyPrint=false&lt;/code&gt; was not found on this server.

Can anyone tell me what's the problem?

答案1

得分: 1

这里我没有提供完整的细节,因此无法访问该页面。

提供 Project_id 和 project_details

  1. pid = "Project_id"
  2. %%bigquery --project $pid df
  3. select * from `project_id.dataset.table`

这将起作用。

英文:

Here I have not provided the complete details, hence it's unable to reach out to the page.

Provide the Project_id and project_details

  1. pid = &quot;Project_id&quot;
  2. %%bigquery --project $pid df
  3. select * from `project_id.dataset.table`

This will work.

huangapple
  • 本文由 发表于 2023年5月17日 16:29:46
  • 转载请务必保留本文链接:https://go.coder-hub.com/76270033.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定