RVR-BQ-RDBMS-006

Issue summary

• Error Code: RVR-BQ-RDBMS-006
• Data Connector: bq_src
• Error Description: FAILED_TO_GET_BUCKETS suggests that the system was unable to retrieve the list of buckets from Google Cloud Storage. This is often linked to insufficient permissions or a misconfigured connection setup concerning the service account in use.

Action steps

To resolve the error, follow these steps:

• Verify Service Account Permissions: Ensure that the service account in use has the storage.buckets.list permission. This permission is necessary for the service account to list buckets in Google Cloud Storage. If this is not yet assigned, you might need to customize the IAM role to include this permission.
• Configure Google Cloud Storage Bucket:
  • Check if the Google Cloud Storage bucket is correctly set up following these instructions:
    • Go to the Google Cloud Platform Console.
    • Navigate to "Cloud Storage" and create necessary buckets if not already done.
    • Under "Permissions," ensure the service account has the necessary access, ideally as a Storage Admin.
• Review Connection Settings in Data Integration:
  • Confirm that the connection settings in Data Integration reflect the accurate details of the service account, project ID, and default bucket. Ensure the correct JSON key you upload the file for the service account.

External references

• Google Cloud IAM Roles and Permissions for Storage
• BigQuery Connection in Data Integration

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.