RVR-LTBQ-101

1. Issue Summary

   • The error code RVR-LTBQ-101 refers to a failure in loading data to BigQuery through Rivery. 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 being used.

2. Action 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【4:9†source】【4:18†source】.
   • Check Connectivity and Setup: Confirm that the Google Cloud service account and the BigQuery API are properly setup within Rivery. Ensure the JSON key file for the service account is correctly uploaded and that the storage and dataset regions are compatible【4:13†source】【4:17†source】.

3. External References:

   • Rivery Documentation on BigQuery Connection
   • Google Cloud BigQuery Location Guide

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