RVR-LTBQ-101

Issue summary

• The error code RVR-LTBQ-101 refers to a failure in loading data to BigQuery through Data Integration. This issue is commonly encountered when there is a mismatch between the dataset's location and the connection's region, or due to insufficient permissions for the Google Cloud service account in use.

Action steps

To resolve the error, follow these steps:

• Location Consistency: Ensure that the dataset ID and the connection both have the same geographical location (region) in BigQuery. Loading data across different regions is not permitted and can lead to failure【4:19†source】.
• Service Account Permissions: Verify that the service account used for the connection has the appropriate permissions, such as BigQuery Data Viewer and BigQuery Job User, and that it has access to the Google Cloud Storage bucket if used as a staging area.
• Check Connectivity and Setup: Confirm that the Google Cloud service account and the BigQuery API are properly setup within Data Integration. Ensure the JSON key file for the service account is correctly uploaded and that the storage and dataset regions are compatible.

External references

• Data Integration Documentation on BigQuery Connection
• Google Cloud BigQuery Location Guide

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.