Defining a connection to BigQuery

To access BigQuery data warehouse, you must define a connection by specifying credentials file in the Connection section on the Properties page.

About this task

Option Procedure Best practices for security
Credentials file In the Credentials file field, specify the fully qualified path for the Google service account credentials json file. For example, /opt/bigquery.json Set the security permissions on the credentials file, so that only the user who runs the job has read access to it.
Project Id This is an optional property to specify the Google project id to be used for BigQuery connection. If this property is not specified, project id from the Credentials file will be used during connection.  

Additionally, BigQuery connection can also be established through a HTTPS proxy server.