RVR-LTBQ-100

Issue summary

The error code RVR-LTBQ-100 indicates a failure when attempting to load data into BigQuery. Based on typical error scenarios, this can relate to mismatches in data types, region discrepancies between the dataset and the storage location, or issues with permissions and connection settings.

Action steps

To resolve the error, follow these steps:
Here’s a series of checks and fixes you can apply to resolve this issue:

1. Data Type Mismatches:

   • Ensure the data types in your source match those expected in the BigQuery target. For instance, if you are inserting strings into a date field, this would cause a failure.

2. Region Compatibility:

   • Verify that your Google Cloud Storage (GCS) bucket's region matches the dataset region in BigQuery. BigQuery cannot read and write data across different regions.

3. Connection and Permission Settings:

   • Ensure your Google Cloud project and BigQuery service account have the correct roles. The service account should have permissions like BigQuery Data Viewer, BigQuery Job User, and access to both the source bucket and BigQuery dataset.

4. Legacy & Standard SQL Differences:

   • If you have switched from Legacy SQL to Standard SQL (or vice versa), ensure any changes required for functions and data types are well-configured.

5. Advanced Options in Data Integration:

   • Review the advanced options in Data Integration and verify that special configurations or toggles, including Custom File Zone, are correctly configured based on your service account and bucket setup.

External references

• For detailed setup instructions and troubleshooting, refer to Data Integration documentation on the configuration of BigQuery and GCS 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.