RVR-LTBQ-103

1. Issue Summary

   • Error Code: RVR-LTBQ-103 with the description "Loading to BigQuery failed" indicates that there was an issue while trying to load data into Google BigQuery from Rivery. This usually relates to incorrect configurations or connectivity issues between Rivery and BigQuery.
   • Initial diagnosis: This error might occur due to misconfigurations in the connection settings or due to resource or permission issues in the target BigQuery dataset/table.

2. Action Steps:

   • Verify Connection Settings:

     • Ensure that your connection to BigQuery in Rivery is set up correctly. Check for the correct project ID, dataset, and table names.
     • Make sure the API key or service account used for the connection has the necessary permissions to load data into BigQuery.

   • Check BigQuery Quotas and Limits:

     • Confirm that you have not exceeded the quotas for BigQuery usage, such as the limit on the number of load operations or concurrent processes.

   • Inspect Data Formatting:

     • Verify that the data being loaded is in an acceptable format and schema as required by BigQuery.

   • Review Logs for Detailed Error Messages:

     • Check the execution logs in Rivery for any specific error messages that could give more insight into what went wrong during the loading process.

   • Test with Sample Data:

     • Try running a test load with a small subset of the data to isolate the problem.

3. External References:

   • For more information on connecting Rivery to BigQuery, refer to Rivery's documentation: Rivery BigQuery Integration.
   • Google BigQuery Quotas and limits: BigQuery Quotas.

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