My Oracle Support Banner

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:

Oracle GoldenGate Big Data and Application Adapters - Version 21.12.0.0.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


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