Install and configure Informatica Services.

Install and configure the Developer tool. You can install the Developer tool when you install Informatica clients.

Create and configure a Model Repository Service and a Data Integration Service in the Informatica domain.

Verify that you have write permissions on all the directories within the

<Informatica installation directory>

directory.

Ensure that the PowerExchange for Google BigQuery license is activated.

Ensure you have a Google service account to access Google BigQuery.

Ensure you have the client_email, project_id, and private_key values for the service account. You will need to enter these details when you create a Google BigQuery connection in Developer tool.

Ensure you have the project ID, dataset ID, source table name, and target table name when you create mappings in

Developer Tool

.

Verify that you have read and write access to the Google BigQuery dataset that contains the source table and target table.

When you read data from or write data to a Google BigQuery table, you must have the required permissions to run the mapping successfully. When you only read data from a Google BigQuery table, you must have the required permissions to read data successfully.

If your organization passes data through a proxy, virtual private cloud, or protective firewall, you must configure your firewall to allow the

www.googleapis.com

and

www.accounts.google.com

URI for PowerExchange for Google BigQuery to transfer data through a proxy, virtual private cloud, or firewall.

If you use bulk mode, verify that you have write access to the Google Cloud Storage path where the

Data Integration Service

creates the staging file.

If you use staging mode, verify that you have read access to the Google Cloud Storage path where the

Data Integration Service

creates the staging file to store the data from the Google BigQuery source.