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.