RVR-BQ-RDBMS-005

1. Issue Summary

   • The error code RVR-BQ-RDBMS-005 with the message GCS_ERROR indicates a problem with the Google Cloud Storage (GCS) bucket configuration when using the BigQuery data connector (bq_src) in Data Integration. This commonly arises from issues with the GCS bucket access or misconfigured settings associated with the BigQuery connection.

2. Action Steps:

   • Verify GCS Configuration: Ensure that the GCS bucket name matches the gcs_file_zone variable configured for your BigQuery connection.
   • Check Bucket Permissions: Confirm that the service account associated with your Data Integration integration has the necessary permissions to access the GCS bucket. The account should have at least the "storage.buckets.get" permission.
   • Region Consistency: Check that the region specified for the GCS bucket aligns with the region for your BigQuery dataset, as mismatched regions can lead to load failures.
   • Test the Connection: Use Data Integration connection testing feature within the Data Integration console to validate and ensure that the connection settings to the GCS and BigQuery are correctly configured.

3 External References:

• For more detailed guidance, consult the official Data Integration documentation for Google Cloud Storage Connection and BigQuery for any additional configuration specifics or updates.

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