OGG BigData For BigQuery Stage Merge Handler - Using separate compute project and storage project (Doc ID 3022296.1)

Last updated on JUNE 06, 2024

Applies to:

Goal

Per customer's compute and storage separation policy, bigquery.jobs.create permission is only allowed on the compute project where the BigQuery jobs are being executed but not on the storage project where the dataset is.

The compute project is xxxx-yyyy-p-dps. The BigQuery storage project is aaaa-edw.

The Service Account is granted bigquery.jobs.create permission in xxxx-yyyy-p-dps, but not in aaaa-edw

The replicat will abend with error: "Access Denied: Project pypl-edw: User does not have bigquery.jobs.create permission in project pypl-edw.".

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.