尝试使用python客户端访问BigQuery时发生身份验证错误

Question

我试图通过Python客户端查询BigQuery数据集。

我有一个启用了计费的项目，一个按此处指示分配了BigQuery管理员角色的服务帐户：https://cloud.google.com/bigquery/docs/quickstarts/quickstart-client-libraries

这是我正在尝试的代码片段

from google.cloud import bigquery
jsonPath = "/Users/xyz/Downloads/serviceaccount.json"
client = bigquery.Client.from_service_account_json(jsonPath)
query_job = client.query("""
    SELECT
    CONCAT(
    'https://stackoverflow.com/questions/',
    CAST(id as STRING)) as url,
    view_count
    FROM `bigquery-public-data.stackoverflow.posts_questions`
    WHERE tags like '%google-bigquery%'
    ORDER BY view_count DESC
    LIMIT 10""")

results = query_job.result() 

客户。查询调用导致此错误：

Traceback (most recent call last):
  File "<stdin>", line 10, in <module>
  File "/Users/xyz/Library/Python/2.7/lib/python/site- 
packages/google/cloud/bigquery/client.py", line 1254, in query
    query_job._begin(retry=retry)
  File "/Users/xyz/Library/Python/2.7/lib/python/site- 
packages/google/cloud/bigquery/job.py", line 552, in _begin
    method='POST', path=path, data=self._build_resource())
  File "/Users/xyz/Library/Python/2.7/lib/python/site- 
packages/google/cloud/bigquery/client.py", line 336, in _call_api
    return call()
  File "/Users/xyz/Library/Python/2.7/lib/python/site- 
packages/google/api_core/retry.py", line 260, in retry_wrapped_func
    on_error=on_error,
   File "/Users/xyz/Library/Python/2.7/lib/python/site- 
packages/google/api_core/retry.py", line 177, in retry_target
    return target()
  File "/Users/xyz/Library/Python/2.7/lib/python/site- 
packages/google/cloud/_http.py", line 293, in api_request
    raise exceptions.from_http_response(response)
google.api_core.exceptions.Unauthorized: 401 POST . 
https://www.googleapis.com/bigquery/v2/projects/xyzproject/jobs: HTTP 
Basic Authentication is not supported for this API

关于我能做些什么来解决这个身份验证问题，有什么建议吗？太感谢了

python-v2.7。10我安装了最新的谷歌云库

Answer 1

我拿了你的代码，添加语句来打印查询结果，并在Python 2.7.15和Python 3.6.1下运行了这个程序，它工作得很好。

这让我相信你有一个过时的库。Google Python SDK使用google-auth、urllib3等。检查是否安装了最新版本。

另外，我会更新你的Python版本。2.7.10于2015年发布。

在命令提示下：

pip freeze > python_modules.list

然后使用grep或您最喜欢的编辑器检查您安装在系统上的版本。

我的Python 2。x环境正在使用：

• 谷歌api核心==1.4。1
• 谷歌认证==1.5。1
• 谷歌云bigquery==1.6。0
• 谷歌云核心==0.28。1
• 谷歌可恢复媒体==0.3。1
• googleapis公共原型==1.5。3
• urllib3==1.22

样本输出：

https://stackoverflow.com/questions/13530967 : 44672 views
https://stackoverflow.com/questions/22879669 : 34745 views
https://stackoverflow.com/questions/13221978 : 31584 views
https://stackoverflow.com/questions/6607552 : 27736 views
https://stackoverflow.com/questions/16609219 : 26271 views
https://stackoverflow.com/questions/35159967 : 26258 views
https://stackoverflow.com/questions/10604135 : 25860 views
https://stackoverflow.com/questions/22004216 : 23496 views
https://stackoverflow.com/questions/10644993 : 22356 views
https://stackoverflow.com/questions/11647201 : 18547 views