RVR-BQ-RDBMS-011

1. Issue Summary

   • The error FAILED_TO_GET_COLUMN_MAPPING with code RVR-BQ-RDBMS-011 occurs when working with the BigQuery data connector in Rivery. This error typically indicates an issue with the automatic or manual column mapping between source and target within Rivery. An initial diagnosis suggests that this may be due to a mismatch in data types or an incomplete column mapping configuration.

2. Action Steps:

   • Verify Data Source and Target Structure: Check to ensure that the schema of the data source matches the mapping settings in Rivery. This includes verifying data types and column names in both the source and target configurations.

   • Automatic Mapping: Utilize Rivery's Auto Mapping feature, which automatically determines your table/query metadata and maps the columns from the source to the target.

   • Manual Adjustments: If automatic mapping does not resolve the issue, manually adjust the mapping settings. Make sure that all required columns are defined and properly mapped without conflicts or missing attributes.

   • Check Data Type Compatibility: Ensure that the data types in both source and target systems are compatible. If there are specific data types that might cause conflicts, consider casting them to a compatible type before performing the data load.

   • Review Rivery's Logs: Examine logs in the Rivery platform to identify any additional errors or warnings that might shed light on the mapping failure.

3. External References:

   • Rivery documentation on BigQuery Connector:
     Rivery BigQuery Documentation

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