Skip to main content
Feedback

RVR-RDBMS-404

Issue summary

You encounter 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 Data Integration, BigQuery connections require a properly set up Google Cloud Storage bucket to export and import data.

Action steps

To resolve the error, follow these steps:

  1. Verify Bucket Configuration:
  • Ensure you have a correctly configured Google Cloud Storage bucket. If one is not set up, you will 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.

  1. 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.

  2. Check BigQuery Service Account Setup:

  • Ensure your Data Integration service account has the following roles set up for your Google Cloud Storage:
    • BigQuery Data Viewer and BigQuery Job User roles.
  • If using a custom service account, make sure it has the storage.buckets.list permission at the project level, associated with the appropriate role.
  1. Ensure you enable the Correct API:
  • Confirm that the Google Cloud Storage JSON API and BigQuery API enabled in your Google Cloud Platform.

External references

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.

On this Page