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

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 included in the Simba driver 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