Google BigQuery

Option	Info
Type	Relational
Driver	Driver Link
Version Included	None
Hop Dependencies	None
Documentation	Documentation Link
JDBC Url	jdbc:bigquery://[Host]:[Port];ProjectId=[Project];OAuthType=[AuthValue]
Driver folder	<Hop Installation>/lib/jdbc

Option

Info

Type

Relational

Driver

Driver Link

Version Included

None

Hop Dependencies

None

Documentation

Documentation Link

JDBC Url

jdbc:bigquery://[Host]:[Port];ProjectId=[Project];OAuthType=[AuthValue]

Driver folder

<Hop Installation>/lib/jdbc

The Simba driver is packaged as a .zip containing many jars. Only a subset of the jars included with the Driver are necessary to use Bigquery JDBC with Apache Hop. Furthermore, some of the jars may conflict with those packaged with Hop and must be excluded.

SIMBA DRIVER JARS TO EXCLUDE (THESE JARS ARE INCLUDED IN THE SIMBA DRIVER, BUT CONFLICT WITH HOP LIBRARIES AND MUST BE EXCLUDED

grpc-alts-<VERSION>.jar
grpc-api-<VERSION>.jar
grpc-core-<VERSION>.jar
grpc-netty-shaded-<VERSION>.jar

SIMBA DRIVER JARS TO INCLUDE (Include only these jars for a minimal Bigquery driver install):

api-common-<VERSION>.jar
gax-<VERSION>.jar
gax-grpc-<VERSION>.jar
google-api-services-bigquery-v2-<VERSION>.jar
GoogleBigQueryJDBC42.jar
google-cloud-bigquerystorage-<VERSION>.jar
grpc-google-cloud-bigquerystorage-v1-<VERSION>.jar
grpc-google-cloud-bigquerystorage-v1beta1-<VERSION>.jar
grpc-google-cloud-bigquerystorage-v1beta2-<VERSION>.jar
json-<VERSION>.jar
proto-google-cloud-bigquerystorage-v1-<VERSION>.jar
proto-google-cloud-bigquerystorage-v1beta1-<VERSION>.jar
proto-google-cloud-bigquerystorage-v1beta2-<VERSION>.jar
threetenbp-<VERSION>.jar

* Tested with Hop 2.5.0 and Simba 1.3.3.1004. Not all authentication methods tested either, so this list may not be exhaustive