部署云功能时Google BigQuery导入错误

Question

我有一个python云函数代码。来自GCS的txt文件，对其进行解析，并将行写入bigquery。当我试图从MacOS将此云功能部署到Google cloud时，它给出了以下错误

我已经验证了我的GCP项目中是否启用了Bigquery API。

GCloud函数部署sql_upload运行时python37触发器桶测试桶入口点load_sql

Deploying function (may take a while - up to 2 minutes)...failed.                                                                                                                                          
ERROR: (gcloud.functions.deploy) OperationError: code=3, message=Function failed on loading user code. Error message: Code in file main.py can't be loaded.
Detailed stack trace: Traceback (most recent call last):
  File "/env/local/lib/python3.7/site-packages/google/cloud/functions/worker.py", line 305, in check_or_load_user_function
    _function_handler.load_user_function()
  File "/env/local/lib/python3.7/site-packages/google/cloud/functions/worker.py", line 184, in load_user_function
    spec.loader.exec_module(main)
  File "<frozen importlib._bootstrap_external>", line 728, in exec_module
  File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed  File "/user_code/main.py", line 24, in <module>
    from google.cloud import bigquery
ImportError: cannot import name 'bigquery' from 'google.cloud' (unknown location)

Answer 1

Python中的依赖关系由pip管理，并在一个名为requirements的元数据文件中表示。txt。此文件必须与主文件位于同一目录中。包含函数代码的py文件。

如果此代码在您的计算机上运行，那么只需创建需求即可。txt文件作者：

pip freeze > requirements.txt

否则，首先必须安装bigquery的依赖项，然后创建需求文件：

pip install --upgrade google-cloud-bigquery
pip freeze > requirements.txt

看医生https://cloud.google.com/functions/docs/writing/specifying-dependencies-python https://cloud.google.com/bigquery/docs/reference/libraries#client-库安装python