Doorda Knowledge Base

Connecting to BigQuery with Jetbrains Datagrip (and most IDE)

Dependencies

1) gcloud cli

- Windows: https://cloud.google.com/sdk/docs/quickstart-windows
- Mac: https://cloud.google.com/sdk/docs/quickstart-macos
- Ubuntu: https://cloud.google.com/sdk/docs/quickstart-debian-ubuntu

2) Simba JDBC Connector

 

https://cloud.google.com/bigquery/partners/simba-drivers/?insvid=16426adc99ebba3f--1529657574391

 

 

Authentication

 

This step will only need to be done once, subsequent queries will use the same credential in .config folder. 

 

1) On Windows, start Start Google Cloud SDK Shell. On Mac/Ubuntu go to Terminal.
2) Run:

 

gcloud beta auth application-default login

 

 

3) Visit the link in your browser and log in using the doorda.com account provided to you

 

 

Setting up BigQuery Driver

 

 

 

Select Add new driver

Name the Datasource BigQuery

Download the JDBC connector and unzip in preferred directory

Add the 7 .jar files in the simba connector folder into Additional folder

Choose com.simba.googlebigquery.jdbc42.Driver under Class

Under URL Template, add jdbc:bigquery://[Host]:[Port];ProjectId=[Project];OAuthType=[AuthValue]; and name it as Default

Add BigQuery Datasource

 

 

Select BigQuery Driver that was set up previously

 

Leave Name and Password blank

 

Under URL, enter jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=doorda-production-207313;OAuthType=3

 

Click on Test Connection to make sure that everything has been set up.

 

Advanced Settings

If you receive a Server Timeout Error, you can increase the timeout value as shown below. But this may mean that you're likely to exceed your data/query usage quota. 

 

 

 

 

    Attached Files
    There are no attachments for this article.
    Related Articles
    API Documentation
    Viewed 343 times since Wed, Feb 14, 2018
    Doorda Host Supported Functions and Operators
    Viewed 380 times since Mon, Jul 9, 2018
    Google Cloud Authentication
    Viewed 301 times since Wed, Sep 12, 2018