RVR-BQ-RDBMS-008
Issue summary
- Error Code: RVR-BQ-RDBMS-008
- Data Connector:
bq_src - Description:
INVALID_PROJECTS_FAILED_TO_GET_BUCKETS
Diagnosis: This error suggests that there is a problem with retrieving buckets from Google Cloud Storage, which is often related to insufficient permissions granted to the service account used by Data Integration to access these resources.
Action steps
To resolve the error, follow these steps:
-
Check Permissions on the Google Cloud Project:
- Ensure that the service account associated with the BigQuery connection has the required permissions. The service account must have "storage.buckets.list" permission at the project level. This permission is often part of broader roles like
Storage Admin.
- Ensure that the service account associated with the BigQuery connection has the required permissions. The service account must have "storage.buckets.list" permission at the project level. This permission is often part of broader roles like
-
Configure Service Account:
- Go to the Google Cloud Platform Console and navigate to "IAM & Admin" > "Service accounts".
- Find the service account connected to Data Integration, and ensure It grants the necessary role (e.g.,
Storage Adminor a custom role withstorage.buckets.listpermission).
-
Test Connection:
- Try reconnecting or testing the connection in Data Integration after applying the necessary permission changes to confirm if the issue persists.
External references
- Data Integration documentation for BigQuery connection setup: Official Data Integration Docs - BigQuery Connection
- Google Cloud permissions documentation: Google Cloud Storage IAM Permissions
note
If the issue persists or you need help, open a case with Data Integration Support. In the console sidebar, select Help > Contact Us and follow the instructions.
