为 BigQuery Python CLI 设置 GOOGLE_APPLICATION_CREDENTIALS [英] Setting GOOGLE_APPLICATION_CREDENTIALS for BigQuery Python CLI
问题描述
我正在尝试使用 Python 通过 BigQuery API 连接到 Google BigQuery.
I'm trying to connect to Google BigQuery through the BigQuery API, using Python.
我在这里关注这个页面:https://cloud.google.com/bigquery/bigquery-api-quickstart
I'm following this page here: https://cloud.google.com/bigquery/bigquery-api-quickstart
我的代码如下:
import os
import argparse
from apiclient.discovery import build
from apiclient.errors import HttpError
from oauth2client.client import GoogleCredentials
GOOGLE_APPLICATION_CREDENTIALS = './Peepl-cb1dac99bdc0.json'
def main(project_id):
# Grab the application's default credentials from the environment.
credentials = GoogleCredentials.get_application_default()
print(credentials)
# Construct the service object for interacting with the BigQuery API.
bigquery_service = build('bigquery', 'v2', credentials=credentials)
try:
query_request = bigquery_service.jobs()
query_data = {
'query': (
'SELECT TOP(corpus, 10) as title, '
'COUNT(*) as unique_words '
'FROM [publicdata:samples.shakespeare];')
}
query_response = query_request.query(
projectId=project_id,
body=query_data).execute()
print('Query Results:')
for row in query_response['rows']:
print(' '.join(field['v'] for field in row['f']))
except HttpError as err:
print('Error: {}'.format(err.content))
raise err
if __name__ == '__main__':
parser = argparse.ArgumentParser(
description=__doc__,
formatter_class=argparse.RawDescriptionHelpFormatter)
parser.add_argument('project_id', help='Your Google Cloud Project ID.')
args = parser.parse_args()
main(args.project_id)
但是,当我通过终端运行此代码时,出现以下错误:
However, when I run this code through the terminal, I get the following error:
oauth2client.client.ApplicationDefaultCredentialsError: The Application Default Credentials are not available. They are available if running in Google Compute Engine. Otherwise, the environment variable GOOGLE_APPLICATION_CREDENTIALS must be defined pointing to a file defining the credentials. See https://developers.google.com/accounts/docs/application-default-credentials for more information.
正如您在代码中看到的,我尝试根据错误中的链接设置 GOOGLE_APPLICATION_CREDENTIALS
.但是,错误仍然存在.有谁知道问题是什么?
As you can see in the code, I've tried to set the GOOGLE_APPLICATION_CREDENTIALS
as per the link in the error. However, the error persists. Does anyone know what the issue is?
先谢谢你.
推荐答案
首先 - 感谢您的代码 - 这提供了非常有用的.我还建议直接在您的代码中添加设置环境变量 - 不要为您工作的每个环境设置它.您可以使用以下代码:
First - Thanks for the code - this provided to be very useful. I would also suggest adding setting the environmental variable directly in your code - as not to set it for every environment you work on. you can use the following code:
import os
os.environ["GOOGLE_APPLICATION_CREDENTIALS"] = "path_to_your_.json_credential_file"
我发现这在需要不同凭据的不同项目之间切换时很有用.
I found this useful when switching between different projects that require different credentials.
这篇关于为 BigQuery Python CLI 设置 GOOGLE_APPLICATION_CREDENTIALS的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!