与 Google Drive 集成时出现凭据错误 [英] Credentials Error when integrating Google Drive with

问题描述

我正在使用 Google Big Query，我想将 Google Big Query 集成到 Google Drive.在大查询中，我提供了 Google 电子表格 url 来上传我的数据 它正在更新，但是当我在 google Add-on(OWOX BI Big Query Reports) 中编写查询时:

I am using Google Big Query, I want to integrate Google Big Query to Google Drive. In Big query I am giving the Google spread sheet url to upload my data It is updating well, but when I write the query in google Add-on(OWOX BI Big Query Reports):

Select * from [datasetName.TableName]

我收到一个错误:

查询失败:tableUnavailable:找不到合适的凭据来访问 Google Drive.联系桌子主人寻求帮助.

Query failed: tableUnavailable: No suitable credentials found to access Google Drive. Contact the table owner for assistance.

推荐答案

我刚刚在我编写的一些代码中遇到了同样的问题 - 它可能不会直接帮助您，因为您似乎不对代码负责，但它可能对其他人有所帮助，或者您可以询问编写您正在使用的代码的人来阅读此内容:-)

I just faced the same issue in a some code I was writing - it might not directly help you here since it looks like you are not responsible for the code, but it might help someone else, or you can ask the person who does write the code you're using to read this :-)

所以我不得不做一些事情:

So I had to do a couple of things:

1. 除了 BigQuery 之外，还为我的 Google Cloud Platform 项目启用 Drive API.
2. 确保您的 BigQuery 客户端是使用 BigQuery 范围和 Drive 范围创建的.
3. 确保您希望 BigQuery 访问的 Google 表格与您的 Google Cloud Platform 标识为的[e-mail]"帐户共享.

之后，我能够在我自己的项目中从 BigQuery 成功查询 Google Sheets 支持的表.

After that I was able to successfully query the Google Sheets backed tables from BigQuery in my own project.

这篇关于与 Google Drive 集成时出现凭据错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！