RVR-RDBMS-404

1. Issue Summary

   • You are encountering a MISSING_BIGQUERY_BUCKET error with the error code RVR-RDBMS-404. This error typically indicates that the Google Cloud Storage bucket required for transferring data to BigQuery is not properly configured or is missing. In Rivery, BigQuery connections require a properly set up Google Cloud Storage bucket to export and import data.

2. Action Steps:

   • Verify Bucket Configuration:

     1. Ensure you have a correctly configured Google Cloud Storage bucket. If one is not set up, you'll need to create it:
        • Navigate to Google Cloud Platform Console.
        • Go to "Cloud Storage" and then "Buckets."
        • Click "+CREATE" and follow the wizard to set up a new bucket. Ensure you choose the correct region, as bucket and dataset regions must match.
     2. Verify that you have assigned the correct permissions to the bucket created:
        • Go to "IAM & Admin" and select "IAM."
        • Assign the required roles (such as Storage Admin) to your service account to ensure it has the necessary access to the bucket.

   • Check BigQuery Service Account Setup:

     1. Ensure your Rivery service account has the following roles set up for your Google Cloud Storage:
        • BigQuery Data Viewer and BigQuery Job User roles.
     2. If using a custom service account, make sure it has the storage.buckets.list permission at the project level, associated with the appropriate role.

   • Ensure the Correct API is Enabled:

     • Confirm that the "Google Cloud Storage JSON API" and "BigQuery API" are enabled in your Google Cloud Platform.

3. External References:

   • Rivery BigQuery Connection Guide for detailed steps on setting up BigQuery connections.
   • Google Cloud Storage Documentation for creating and managing buckets.

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