BigQuery

Connection Settings

The Google BigQuery connection uses Google’s 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.

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 supported parameters, see the connection properties for the Google BigQuery JDBC driver.

Keep Alive

See JDBC Driver Settings for keep alive settings.

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.