You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hop.apache.org by ha...@apache.org on 2023/06/23 18:34:49 UTC

[hop] branch master updated: Update googlebigquery.adoc

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 <mg...@gmail.com>
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