RVR-BQ-RDBMS-005
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 incorrectly configured settings associated with the BigQuery connection.
Action steps
To resolve the error, follow these steps:
- Verify GCS Configuration: Ensure that the GCS bucket name matches the
gcs_file_zonevariable 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.
External references
- For more detailed guidance, consult the official Data Integration documentation for Google Cloud Storage Connection and BigQuery for any configuration specifics or updates.
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.