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 Rivery. 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 Rivery 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 Rivery's connection testing feature within the Rivery 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 Rivery 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 Rivery support.