Google BigQuery的Simba ODBC驱动程序看不到共享数据集 [英] Simba ODBC driver for Google BigQuery doesn't see shared dataset

问题描述

我已经安装了适用于Google BigQuery v2.2.3的Simba ODBC驱动程序，并且具有共享数据集，我能够从BigQuery Web界面使用此共享数据集，但无法通过Simba ODBC进行访问.在ODBC设置下拉列表中，我仅看到自己的数据集.但是，如果我将共享数据集的项目名称粘贴到该下拉列表中，则ODBC会返回共享数据集的列表，但不允许测试或保存连接.如何设置与共享数据集的连接?

I have Simba ODBC Driver for Google BigQuery v2.2.3 installed and I have Shared Dataset, I be able to use this shared dataset from BigQuery Web interface but can't reach it through Simba ODBC. In ODBC setting dropdown I see only my own dataset. But if I paste project name of Shared dataset in that dropdown than ODBC returns list of share datasets but not allow to test or save connection. How can I setup connection to a shared dataset?

推荐答案

我认为问题可能出在驱动程序中未明确使用被授予访问共享数据集权限的帐户中.假设给 User1 这样的权限.因此，在驱动程序配置中，尤其是在连接字符串中，应确保使用相同的 User1 ，因为与 User2 连接时，驱动程序将列出数据集 User1 有权访问(不是 User2 ).

I think the issue could be in the account that was granted permissions to access the shared dataset is not explicitely used in the driver. Let's suppose that the User1 was given such permission. So, in your driver configuration, especially in the connection string, you should be sure you are using the same User1, since connecting with a User2 the driver will list the datasets User1 has access to (not User2).

由于没有出现拼写错误，并且驱动程序未检索到所需的数据集，因此可以再次检查

As you are not getting a conetion error and the driver is not retrieving the desired dataset, you can double-check the Simba authehtication configuration and following steps depending on if you are using User Account or Service Account.

这篇关于Google BigQuery的Simba ODBC驱动程序看不到共享数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！