访问Google表格联合表时出现BigQuery凭据问题 [英] BigQuery Credential Problems when Accessing Google Sheets Federated Table

问题描述

我将表格定义为指向Google工作表的联邦表格。当我从google bigquery Web UI查询它时，它工作得非常好。但是，如果我尝试使用Tableau Software BigQuery驱动程序查询它，则会收到以下错误消息：找不到用于访问Google Drive的合适凭证。请联系餐桌主人寻求帮助。

I defined a table as a federated table which refers to a google sheet. It works perfectly well when I query it from the google bigquery web UI. However, if I try to query it using the Tableau Software BigQuery driver, I get the following error message: No suitable credentials found to access Google Drive. Contact the table owner for assistance.

关于我的设置的一些事实：

A few facts about my setup:

1. 在Tableau中使用BigQuery驱动程序时，我使用与进入BigQuery Web UI时使用的相同用户标识登录。


2. 从Tableau查询本地BigQuery表格很好。


3. 我在云帐户中启用了Google Drive api。


4. Google表格和Google大型查询帐号在同一个Google用户下。


5. 我没有任何问题，将bigquery查询另存为该帐户下的Google表单。


6. 我尝试将表格分享给任何拥有此网址的人并且它不起作用。
   

1. When I use the BigQuery driver in Tableau, I log in using the same user id that I use when I go into the BigQuery web UI.
2. Queries from Tableau to a native BigQuery table work fine.
3. I enabled the google drive api in my cloud account.
4. The google sheet and google big query account are under the same google user.
5. I have no problem saving a bigquery query as a google sheet under that account.
6. I tried sharing the sheet "to anyone that has the URL" and it does not work.

推荐答案

这是Tableau应该解决的问题。问题是，当他们向BigQuery发送请求时，他们只能通过BigQuery API范围。不过，他们也应该请求GoogleDrive范围。

This is something Tableau should fix. The problem is that when they send request to BigQuery, they only pass BigQuery API scope. However they should also request GoogleDrive scope.

这篇关于访问Google表格联合表时出现BigQuery凭据问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！