When you use a Google BigQuery target for the first time, perform the following steps before you configure an

application ingestion

task for the target:

Download the Google BigQuery JDBC driver from the Google Cloud website.
Copy the JDBC driver jar files to the following directory:
<Secure_Agent_installation_directory>/apps/Database_Ingestion/ext/
Restart the Secure Agent.

You must have a service account in your Google account to access Google BigQuery and Google Cloud Storage.

Ensure that you have the client_email, project_id, private_key, private_key_id, client_id, and region ID values for the service account. You must enter these details when you create a Google BigQuery connection.

If you want to configure a timeout interval for a Google BigQuery connection, specify the timeout interval property in the

Provide Optional Properties

field of the connection properties. Use the following format:

"timeout": "<
timeout_interval_in_seconds>"

You must have read and write access to the following entities:

Google BigQuery datasets that contain the target tables.
Google Cloud Storage path where
Mass Ingestion Applications
creates the staging file.

Application ingestion jobs configured for Google BigQuery targets do not replicate the modification and renaming of source fields on the target.

You must have the following permissions to write data to a Google BigQuery table:

bigquery.datasets.get
bigquery.datasets.getIamPolicy
bigquery.models.*
bigquery.routines.*
bigquery.tables.create
bigquery.tables.delete
bigquery.tables.export
bigquery.tables.get
bigquery.tables.getData
bigquery.tables.list
bigquery.tables.update
bigquery.tables.updateData
bigquery.tables.updateTag
resourcemanager.projects.get
resourcemanager.projects.list
bigquery.jobs.create