Google BigQuery

Jump to Section

Connection Settings

The Google BigQuery connection uses the Simba BigQuery JDBC driver to enable reading, writing, and browsing BigQuery datasets. The connection uses the host https://www.googleapis.com/bigquery/v2 on port 443 for BigQuery.

To use this connection, you must do the following.

  1. Download the JDBC Driver linked to on this page: https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers
    • This release has been tested with version 1.5.2.1005 of the Simba driver
  2. Unzip and copy the GoogleBigQueryJDBC42.jar into the runtime/lib directory.
    • The Intelligence Hub installer contains all the required dependencies included in the zip with the exception of the Simba driver which cannot not be redistributed with applications.
  3. Restart the runtime

Below are the required setting for the Connection.

Project Id

The Project Id as defined in the Google Cloud Console. Login to BigQuery and create a project to get the Id. An example Id is myproject-417313

JDBC Connection String

Specifies additional arguments for the end of the JDBC connection string. For example, it’s common to authenticate with BigQuery using a Service Account. A key is generated from the Service Account in the form of a JSON file. Place the JSON file on disk, making it available to the runtime, and then reference it in the JDBC Connection String as follows.

OAuthType=0;OAuthServiceAcctEmail=serviceName@emailDomain;OAuthPvtKeyPath=C:/path/to/project-keyfile.json;

To find additional support parameters, reference the Simba Installation and Configuration Guide for the Google BigQuery JDBC driver.

Input/Output Settings

See JDBC Driver Settings for input and output settings.

Note: When specifying output tables, prefix the table with the name of the dataset. For example dataset.table.