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