Is there a google supported JDBC driver for BigQuery?

3
votes

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: 

java.io.IOException: toDerInputStream rejects tag type 123

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): 

jdbc:BQDriver:my-poc%3AMY_POC?withServiceAccount=true
2
jdbcgoogle-bigquerystar-schema
Possible duplicate of jdbc driver for google bigquery – Luís Bianchin

2 Answers

3
votes

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.

0
votes

java.io.IOException: toDerInputStream rejects tag type 123

The JDBC driver requires a p12 formatted file instead of the json formatted file.