RVR-BQ-RDBMS-008

1. 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.

2. Action Steps:

   1. 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.

   2. 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's granted the necessary role (e.g., Storage Admin or a custom role with storage.buckets.list permission).

   3. Test Connection:

      • Try reconnecting or testing the connection in Data Integration after applying the necessary permission changes to confirm if the issue persists.

3. External References:

   • Data Integration documentation for BigQuery connection setup: Official Data Integration Docs - BigQuery Connection
   • Google Cloud permissions documentation: Google Cloud Storage IAM Permissions

If the issue persists or you need further assistance, please open a ticket with Data Integration support.