Datagrip x BigQuery - Datagrip won't read the schema

Hey there

Getting a weird error for two days where Datagrip can't read the schema structure in BigQuery and as a result do not show any dataset or tables. Autocomplete is also gone as result.

Querying the database and connecting is still working.

The error code retrieve when trying to refresh the schema is:

Y000][100092] [Simba][BigQueryJDBCDriver](100092) Project operations error. Message: null
and 3 duplicate reports (1 m 43 s 917 ms)

I am using Datagrip 2019.2.6 on MacOS. Database is BigQuery and I'm using the Simba driver.

Thanks in advance for the assistance!

Thomas

11 comments
Comment actions Permalink

Same problem for me, could you give us some suggestion?

Thanks

1
Comment actions Permalink

T Ducrot , Albert Caramia

Could you e-mail me vasily.chernov@jetbrains.com full IDE & SQL logs?

Also, it'll helpful to get JDBC driver version.

0
Comment actions Permalink

Hi Vasily,

thanks for your reply.

IDE: DataGrip (build #DB-192.7142.42, 30 Oct 2019 16:35)

jdbc: last simba driver SimbaJDBCDriverforGoogleBigQuery42_1.2.2.1004.zip (com.simba.googlebigquery.jdbc42.Driver)

I followed this tutorial: https://blog.jetbrains.com/datagrip/2018/07/10/using-bigquery-from-intellij-based-ide/

I think I solved the issue: I modified the schema pattern in the schema tab (properties on connection).

When I select only the current database/dataset (schema pattern: databasename:datasetname,) , it is possible to introspect the schema and Autocomplete starts working.

1
Comment actions Permalink

Hi Vasily,

I am using:

DataGrip 2019.2.6
Build #DB-192.7142.42, built on October 30, 2019
Licensed to Wargaming Group Limited / Thomas Ducrot
Subscription is active until January 27, 2020
Runtime version: 11.0.4+10-b304.77 x86_64
VM: OpenJDK 64-Bit Server VM by JetBrains s.r.o
macOS 10.14.6
GC: ParNew, ConcurrentMarkSweep
Memory: 1981M
Cores: 8
Registry:
Non-Bundled Plugins: org.jetbrains.plugins.terminal

Using the simba driver: SimbaJDBCDriverforGoogleBigQuery42_1.2.2.1004

Uploaded the logs here: https://drive.google.com/drive/folders/1I0TvhZHVsZ3tCFXtKruhYFpD1T9lc3xf?usp=sharing

I could reproduce the same behavior using Pycharm Pro Version, and I had a similar error using different version of Simba BQ drivers.

Hope that helps!

Thomas

0
Comment actions Permalink

T Ducrot,

It looks like JDBC driver issue. Could you apply schema pattern as it was mentioned by Albert Caramia in your data source settings?

0
Comment actions Permalink

Hi Vasily,

I double checked the setting but the database schema settings is already set up like this.

I am still getting the same error when trying to refresh the schema.

[HY000][100092] [Simba][BigQueryJDBCDriver](100092) Project operations error. Message: null
and 3 duplicate reports (1 m 28 s 670 ms)

0
Comment actions Permalink

Could you change @:@  according to pattern: databasename:datasetname.

In your case it would be wg-mobile-hq:<your-dataset-name>

 

 

By the way you can expand list, e.g

 

0
Comment actions Permalink

It seems that Datagrip / the driver can't detect the schemas/datasets in BQ.

Specifying explicitly a single schema/dataset also trigger the same error...

0
Comment actions Permalink

You're right, it's JDBC driver issue.

Do you know data set you need to work with to specify in schema pattern?

0
Comment actions Permalink

I'm having the same issue, and specifying one specific schema in the schema pattern isn't solving it.

0
Comment actions Permalink

There's a comment in DBE-2497 describing how to connect using OAuth values from the Google Cloud SDK rather than a service account private key file, and it turns out doing that avoids this error when doing introspection.

0

Please sign in to leave a comment.