BigQuery是否有谷歌支持的JDBC驱动程序? [英] Is there a google supported JDBC driver for BigQuery?
问题描述
我们正在寻求通过第三方sql客户端访问BigQuery,例如。 RazorSql。我遇到了StarSchema JDBC驱动程序,我无法使它与Razorsql一起工作,并且在网页上说它已经存档。所以,不知道它应该工作。任何建议吗?
我试图将它与RazoeSql一起使用时遇到的错误是:
java.io.IOException:toDerInputStream拒绝标签类型123
我正在使用服务账户密钥文件进行认证。
这是我使用的JDBC url值(其中my-poc是项目ID,MY_POC是数据集名称):
jdbc:BQDriver:my-poc%3AMY_POC?withServiceAccount = true
唉,不存在官方支持的JDBC驱动程序。 Simba与谷歌联合开发了一个ODBC驱动程序(您可以在此处免费),并且你可以使用JDBC到ODBC的桥接器(虽然官方的不推荐在java 8中使用,但我相信你可以从几个不同的人下载一个( here)。不可否认,这个不是一个很好的解决方案,国际海事组织谷歌真的应该提供一个JDBC驱动程序,但它们不是。 We are looking to access BigQuery through third party sql clients, ex. RazorSql. I came across StarSchema JDBC driver and I could not make it work with Razorsql and on the webpage it says that the project was archived. So, not sure if its supposed to work. Any suggestions? The error I get when trying to use it with RazoeSql is: I am using a service account key file for authentication. This is JDBC url value I use (where "my-poc" is the project id and "MY_POC" is the dataset name):
Alas, no there isn't a JDBC driver that is officially supported. There is an ODBC driver developed by Simba in conjunction with google (you can download it here for free), and you can use a JDBC to ODBC bridge (although the official one is deprecated in java 8, I believe you can download one from a couple of different folks (here, for example). Admittedly, this is not a great solution. IMO Google really should provide a JDBC driver, but they do not. 这篇关于BigQuery是否有谷歌支持的JDBC驱动程序?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!java.io.IOException: toDerInputStream rejects tag type 123
jdbc:BQDriver:my-poc%3AMY_POC?withServiceAccount=true