RVR-RDBMS-404

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 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:

• 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 Data Integration 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 you enable the Correct API:

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

External references

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

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.