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.