BigQuery drivers for DataGrip

I'm searching for a good BigQuery IDE. DataGrip looks excellent but it doesn't look possible to connect to BigQuery. Is it possible?

4 comments
Comment actions Permalink

Hello David,

Support in a large degree depends on jdbc drivers for the database. It seems that there is no officially supported jdbc driver for the BigQuery provided by Google. We have a request about BigQuery support though. Please vote and follow it in our tracker: https://youtrack.jetbrains.com/issue/DBE-2497 

0
Comment actions Permalink

Has there been any progress on this with, perhaps, the Simba JDBC driver? The lack of an out-of-the-box option for BigQuery is forcing evaluation of other SQL IDEs where DataGrip would be preferred.

1
Comment actions Permalink

did anyone be able to resolve this?

I tried using this guide: https://www.snowflake-analytics.com/blog/infrastructure/bigquery-datagrip-setup/

Can't understand what to enter here:

jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=PROJECTID;OAuthType=0;OAuthServiceAcctEmail==EMAIL;OAuthPvtKeyPath=KEYFILE

0
Comment actions Permalink

@Oshri Maidanik
Follow a template:

jdbc:bigquery://[Host]:[Port];ProjectId=[Project];OAuthType=[AuthValue];
0

Please sign in to leave a comment.