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 laterInformation 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 |