This is an automated email from the ASF dual-hosted git repository.
hansva pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/hop.git
The following commit(s) were added to refs/heads/master by this push:
new 174b44cb25 Update googlebigquery.adoc
new 1cb59b962f Merge pull request #3030 from gitmstoute/patch-5
174b44cb25 is described below
commit 174b44cb255d84333d7d73a13a7ce5abe335e207
Author: gitmstoute <[email protected]>
AuthorDate: Fri Jun 23 14:02:07 2023 -0400
Update googlebigquery.adoc
Added information on conflicting jars packaged with the BigQuery simba
driver, as well as a minimal set of jars for working BigQuery connection. Fixed
hyperlink to Bigquery driver.
---
.../pages/database/databases/googlebigquery.adoc | 27 +++++++++++++++++++++-
1 file changed, 26 insertions(+), 1 deletion(-)
diff --git
a/docs/hop-user-manual/modules/ROOT/pages/database/databases/googlebigquery.adoc
b/docs/hop-user-manual/modules/ROOT/pages/database/databases/googlebigquery.adoc
index c820fcd009..5b5fa12271 100644
---
a/docs/hop-user-manual/modules/ROOT/pages/database/databases/googlebigquery.adoc
+++
b/docs/hop-user-manual/modules/ROOT/pages/database/databases/googlebigquery.adoc
@@ -24,10 +24,35 @@ under the License.
|===
| Option | Info
|Type | Relational
-|Driver | https://cloud.google.com/bigquery/providers/simba-drivers/[Driver
Link]
+|Driver |
https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers[Driver Link]
|Version Included | None
|Hop Dependencies | None
|Documentation |
https://www.simba.com/products/BigQuery/doc/JDBC_InstallGuide/content/jdbc/d-intro.htm[Documentation
Link]
|JDBC Url |
jdbc:bigquery://[Host]:[Port];ProjectId=[Project];OAuthType=[AuthValue]
|Driver folder | Hop Installation/plugins/databases/googlebigquery/lib
|===
+
+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
+ proto-google-cloud-bigquerystorage-v1-<VERSION>.jar
+ proto-google-cloud-bigquerystorage-v1beta1-<VERSION>.jar
+ proto-google-cloud-bigquerystorage-v1beta2-<VERSION>.jar
+ threetenbp-<VERSION>.jar
+
+pass:[*] 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
