RVR-BQ-RDBMS-009

1. Issue Summary

   • The error code RVR-BQ-RDBMS-009 with the description BUCKET_LOCATION_MISMATCH in the context of the Data Connector bq_src typically indicates a mismatch between the location (region) of a Google Cloud Storage bucket and the BigQuery dataset. This mismatch occurs when the regional settings for either the bucket or the dataset do not match, causing a failure in data transfer between them.

2. Action Steps:

   • Verify Locations:
     • Check the region specifications for your Google Cloud Storage bucket and ensure it matches the region of the BigQuery dataset.
     • You can find the region of your bucket in the Google Cloud Console under the Cloud Storage section.
     • Similarly, verify your BigQuery dataset's region in the BigQuery Console.
   • Update Settings if Necessary:
     • If there is a mismatch, update either the bucket to match the dataset's region or the dataset to match the bucket's region. This may involve creating a new bucket or dataset in the correct region.
     • Modify your Rivery connection configuration to reflect these changes.
   • Test Configuration:
     • After ensuring the region match, test the connection in Rivery to ensure the error is resolved.

3. External References:

   • For more information on storage bucket locations and how to set them, you can refer to the Google Cloud official documentation: Google Cloud Storage Locations.

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