凭据与Google云端硬盘集成时出错 [英] Credentials Error when integrating Google Drive with

问题描述

我使用Google Big Query，我想将Google Big Query集成到Google云端硬盘。在大查询中，我使用Google电子表格网址上传我的数据它正在更新，但是当我在谷歌附件（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]

我收到一个错误消息：

I am getting an error:

查询失败：tableUnavailable：找不到合适的凭据来访问Google云端硬盘。请联系餐桌主人寻求帮助。

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. 为我的Google云端平台启用Drive API项目除了BigQuery。


2. 确保您的BigQuery客户端是使用BigQuery范围和Drive范围创建的。


3. 确保您希望BigQuery访问的Google表格与您的Google云端平台自己标识为的... @ appspot.gserviceaccount.com帐户共享。

之后，我可以在我自己的项目中成功查询来自BigQuery的Google Sheets支持的表。

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

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