Improve documentation of Simba JDBC driver, add Maven/Gradle instructions [180413368]

Infeasible

Feature Request

Status Update

No update yet.

Description

lu...@gmail.com

created issue #1

Feb 17, 2021 11:53AM

The current documentation of the Simba JDBC driver just explains how to work with a ZIP file: https://cloud.google.com/bigquery/providers/simba-drivers

These days, most people use Maven/Gradle and don't like to manually set up the dependencies for 50 individual jar files contained in the ZIP file. After a few attempts, I've noticed that this seems to suffice with Maven:

<dependency>
    <groupId>com.google.cloud</groupId>
    <artifactId>google-cloud-bigquery</artifactId>
    <version>1.127.2</version>
</dependency>
<dependency>
    <groupId>com.google.cloud</groupId>
    <artifactId>google-cloud-bigquerystorage</artifactId>
    <version>1.8.5</version>
</dependency>
<dependency>
    <groupId>com.google.cloud</groupId>
    <artifactId>simba</artifactId>
    <version>1.2.11.1014</version>
    <scope>system</scope>
    <systemPath>${basedir}/lib/bigquery/GoogleBigQueryJDBC42.jar</systemPath>
</dependency>

(Plus making sure the Guava dependency has the right version, as that might have already been on the classpath).

Knowing this up front would have saved a few minutes of trial-and-error, I think it's worth mentioning in the above linked documentation, or create a tutorial somewhere.

Comments

mk...@google.com <mk...@google.com> #2Feb 18, 2021 08:56AM

Assigned to gc...@google.com.

Hello,

Thank you for contacting us and contributing. Since your issue corresponds to the feature implementation demand the report has been adjusted as the feature request. The support team has been made aware about the request for Simba JDBC driver documentation review. Kindly note that there are no guarantees or ETAs for the implementation of this feature request, however all the future relevant updates and progress of implementation will be reflected in this thread.

jp...@stanford.edu <jp...@stanford.edu> #3Jun 11, 2021 10:52PM

Adding information here for the benefit of anyone else looking to use this hint. In the current version of the Simba driver (1.2.16.1020), it appears that there are additional bundled jar files that are not in the transitive dependencies of google-cloud-bigquery and google-cloud-bigquerystorage. These six additional files are:
avro-1.10.2.jar, commons-compress-1.20.jar, jackson-annotations-2.12.2.jar, jackson-databind-2.12.2.jar, joda-time-2.10.10.jar, and slf4j-api-1.7.30.jar. It looks like avro, joda-time, and jackson-databind are sufficient to transitively pull in all six.

se...@google.com <se...@google.com> #4Jun 15, 2021 08:31AM

Assigned to gc...@google.com.

Hello,

Thank you for additional information.

It was forwarded to the product team. You can keep track of the status by following this thread.

Kind Regards

jo...@qualytics.co <jo...@qualytics.co> #5Feb 23, 2022 12:45PM

Hey Google Team!

We would like to get this solved, we leverage build tools to inject dependencies.

Thanks!

pi...@gmail.com <pi...@gmail.com> #6Feb 28, 2022 02:39PM

hello team..
any update on the maven dependency address for the same?

sj...@google.com <sj...@google.com> #7Mar 1, 2022 01:18PM

Accepted by sj...@google.com.

Hello,

Thank you for the additional information. It was forwarded to the product team. For now, Please stay tune to this thread for updates.

Regards

Message last modified on Mar 1, 2022 01:19PM

sj...@google.com <sj...@google.com> Mar 10, 2022 04:29PM

Assigned to gc...@google.com.

[Deleted User] <[Deleted User]> #8Mar 11, 2022 10:29PM

+1 on adding a maven dependency for this driver

st...@google.com <st...@google.com> Mar 14, 2022 10:18AM

Reassigned to st...@google.com.

st...@google.com <st...@google.com> #9Mar 14, 2022 01:57PM

Reassigned to gc...@google.com.

Hello,

Thank you for reaching out.

The request was forwarded to the product team. For now, please stay tune to this thread for updates.

Kind regards

se...@teads.com <se...@teads.com> #10Mar 18, 2022 10:41AM

Hello,
On our side we manually craft a pom.xml (with the right dependencies) and then upload the jar on our entreprise maven repository.
It's time consuming and error prone.

It would be great to distribute the driver on a public maven repository.

Thank you!

km...@confluent.io <km...@confluent.io> #11Mar 21, 2022 03:51AM

+1 to the requests here.

pi...@gmail.com <pi...@gmail.com> #12Mar 21, 2022 10:37AM

another +1 to requests above. It's hard to keep right dependencies updated and would be great to have the driver in mvn repository.

ew...@google.com <ew...@google.com> #13Mar 21, 2022 04:04PM

Hi,

If you wanted to demonstrate your interest on this feature, please use the [+1] button on the case. The product team is aware of the feature and an update will be posted soon. Please fell free to add additional information and workarounds found in the comments.

Kind Regards!

sh...@google.com <sh...@google.com> #14Mar 25, 2022 09:01PM

Serious +1. If we're not interoperating with Maven/Gradle, we simply aren't in the ecosystem.

ew...@google.com <ew...@google.com> #15Mar 28, 2022 03:00PM

Hi,

If you wanted to demonstrate your interest on this feature, please use the [+1] button on the case. The product team is aware of the feature and an update will be posted soon. Please fell free to add additional information and workarounds found in the comments.

Kind Regards!

ds...@google.com <ds...@google.com> Jun 5, 2023 05:23AM

Reassigned to ds...@google.com.

ds...@google.com <ds...@google.com> Jun 9, 2023 06:45AM

Reassigned to gc...@google.com.

jk...@google.com <jk...@google.com> #16Jan 23, 2024 08:08PM

Hi, One of my customers has a requirement for this feature and is asking for an ETA. Is there any way we can get an ETA on this request?

ds...@google.com <ds...@google.com> #17Mar 25, 2024 12:33PM

Status: Won't Fix (Infeasible)

Hello , Simba is not willing to distribute the driver via Maven. As mentioned in the internal bug by engineering them , i am going to close this as it won't fix infeasible, if you have any issue you can create a new thread and describes the issue there .

Issue 180413368

Description

Issue summary

Comments

mk...@google.com <mk...@google.com> #2Feb 18, 2021 08:56AM

jp...@stanford.edu <jp...@stanford.edu> #3Jun 11, 2021 10:52PM

se...@google.com <se...@google.com> #4Jun 15, 2021 08:31AM

jo...@qualytics.co <jo...@qualytics.co> #5Feb 23, 2022 12:45PM

pi...@gmail.com <pi...@gmail.com> #6Feb 28, 2022 02:39PM

sj...@google.com <sj...@google.com> #7Mar 1, 2022 01:18PM

sj...@google.com <sj...@google.com> Mar 10, 2022 04:29PM

[Deleted User] <[Deleted User]> #8Mar 11, 2022 10:29PM

st...@google.com <st...@google.com> Mar 14, 2022 10:18AM

st...@google.com <st...@google.com> #9Mar 14, 2022 01:57PM

se...@teads.com <se...@teads.com> #10Mar 18, 2022 10:41AM

km...@confluent.io <km...@confluent.io> #11Mar 21, 2022 03:51AM

pi...@gmail.com <pi...@gmail.com> #12Mar 21, 2022 10:37AM

ew...@google.com <ew...@google.com> #13Mar 21, 2022 04:04PM

sh...@google.com <sh...@google.com> #14Mar 25, 2022 09:01PM

ew...@google.com <ew...@google.com> #15Mar 28, 2022 03:00PM

ds...@google.com <ds...@google.com> Jun 5, 2023 05:23AM

ds...@google.com <ds...@google.com> Jun 9, 2023 06:45AM

jk...@google.com <jk...@google.com> #16Jan 23, 2024 08:08PM

ds...@google.com <ds...@google.com> #17Mar 25, 2024 12:33PM

Add comment

Issue metadata