How do I connect to BigQuery using Simba's JDBC driver?

[julianhyde]

How do I connect to BigQuery using SQLLine?

Call sqlline

java -classpath /usr/local/sqlline-1.12/sqlline-1.12.0.jar:/usr/local/sqlline-1.12/jline-3.21.0.jar:/usr/local/sqlline-1.12/SimbaJDBCDriverforGoogleBigQuery42_1.2.22.1026/* sqlline.SqlLine
sqlline version 1.12.0
sqlline>

Specify the properties file (You'll get some warnings unrelated to the properties file)

sqlline> !properties /usr/local/sqlline-1.12/bigquery.properties
Transaction isolation level TRANSACTION_REPEATABLE_READ is not supported. Default (TRANSACTION_READ_UNCOMMITTED) will be used instead.

Run a query

0: jdbc:bigquery://[https://www.googleapis.com>](https://www.google.com/url?sa=D&q=https%3A%2F%2Fwww.googleapis.com%253E%2F) select current_datetime, count(*) from my-project.foo.events;
+----------------------------+--------+
| f0_ | f1_ |
+----------------------------+--------+
| 2022-04-12 22:21:18.353722 | 227640 |
+----------------------------+--------+
1 row selected (0.613 seconds)

This is what the properties file looks like:

$ cat /usr/local/sqlline-1.12/bigquery.properties
url=jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443
driver=com.simba.googlebigquery.jdbc.Driver
user=
password=
OAuthType=0
ProjectID=my-project
[email protected]
OAuthPvtKeyPath=/usr/local/sqlline-1.12/mykeys.example.com.json