从大查询获取数据时出现凭据错误

Question

我尝试使用python从大查询中获取数据。以下是我的代码：

bg_client = bigquery.Client.from_service_account_json("soy-serenity.json")

QUERY = "(SELECT * from table_name)"

df = gbq.read_gbq(QUERY, project_id = 'soy-serenity', dialect = 'standard')

一直持续到昨天。不知何故，它给出了以下错误：

^{pr2}$

Answer 1

following link显示了一个示例，可以运行该示例使用Python从BigQuery获取数据：

import os
from google.cloud import bigquery

os.environ['GOOGLE_APPLICATION_CREDENTIALS'] = 'path_to_soy-serenity.json'
client = bigquery.Client()

query = ("SELECT * FROM `bigquery-public-data.usa_names.usa_1910_2013`")
query_job = client.query(query, location="US",) 

for row in query_job:  # API request - fetches results
    assert row[0] == row.name == row["name"]
    print(row)

Answer 2

试着这样做：

from google.oauth2 import service_account
import pandas_gbq

credentials = service_account.Credentials.from_service_account_file(
    'soy-serenity.json',
)
sql = "SELECT * from table_name"
df = pandas_gbq.read_gbq(sql, project_id="soy-serenity", credentials=credentials)