4

I need a JDBC driver to connect my application to Google BigQuery. I tried CData JDBC driver, but it did not support all types of Standard SQL queries. Are there any other complete options?

Hajar Homayouni
  • 560
  • 2
  • 6
  • 16

2 Answers2

12

The official JDBC driver for BigQuery should support all types of standard SQL queries.

Elliott Brossard
  • 32,095
  • 2
  • 67
  • 99
  • 1
    I have another querstion. In Simba configuration, I should set the url in this format: " jdbc:bigquery://[Host]:[Port];ProjectId=[Project];OAuthType= [AuthValue];[Property1]=[Value1];[Property2]=[Value2]; " I don't know what I should set for Host. My data is on Google bigquery, what is my server ip though? – Hajar Homayouni Nov 15 '16 at 20:30
  • 1
    You need to specify `https://www.googleapis.com/bigquery/v2` as the host. The Install and Configuration Guide that comes with the driver has an example of `jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=MyBigQueryProject;OAuthType=1;` as a complete connection URL. – Elliott Brossard Nov 15 '16 at 21:05
  • I still cannot connect to my Google Bigquery dataset via Simba. I want to connect from R application using RJDBC package. library(RJDBC) driver <- JDBC(driverClass = "com.simba.googlebigquery.jdbc42.Driver", classPath = "~/JDBC/GoogleBigQueryJDBC42.jar", identifier.quote = "'") conn <- dbConnect(driver,"jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=My_project_Id;OAuthType=1;") – Hajar Homayouni Nov 16 '16 at 21:31
  • I'm not familiar enough with R to help, unfortunately. Let's see if someone else answers the new question that you posted, though. – Elliott Brossard Nov 16 '16 at 21:51
1

Are there any other complete options?

You can use Query Prefix #standardSQL to force use of Standard SQL

See more details in Setting a query prefix

Mark Rotteveel
  • 100,966
  • 191
  • 140
  • 197
Mikhail Berlyant
  • 165,386
  • 8
  • 154
  • 230