Ensure you have a service account in your Google 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

PowerCenter

.

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 following permissions:

bigquery.datasets.create
bigquery.datasets.get
bigquery.datasets.getIamPolicy
bigquery.datasets.updateTag
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

When you only read data from a Google BigQuery table, you must have the following permissions:

bigquery.datasets.get
bigquery.datasets.getIamPolicy
bigquery.models.getData
bigquery.models.getMetadata
bigquery.models.list
bigquery.routines.get
bigquery.routines.list
bigquery.tables.export
bigquery.tables.get
bigquery.tables.getData
bigquery.tables.list
resourcemanager.projects.get
resourcemanager.projects.list
bigquery.jobs.create
bigquery.tables.create

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

PowerCenter 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

PowerCenter Integration Service

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