RVR-SNF-006

1. Issue Summary

   • The error you're encountering, RVR-SNF-006, occurs when trying to synchronize schemas between columns using the sync_schemas function in a Snowflake data connector. This error suggests that there is a mismatch or an issue in aligning the schema definitions between your source and target schemas during synchronization. The initial diagnosis points to potential schema drift or misconfiguration in column mappings.

2. Action Steps:

   • Check your Snowflake schema for any recent changes that might not have been reflected in the target schema. Ensure that both source and target schemas are consistent and correctly aligned.
   • Verify column mapping configurations in Rivery to ensure that the columns are defined appropriately and match in type and name between the source and target.
   • Use Rivery's schema drift management to handle any possible schema changes automatically. This involves resyncing metadata and ensuring that changes in the data source are accurately reflected in the target.
   • Verify that the account permissions and role in Snowflake have the necessary access to manage and alter schemas if needed.

3. External References:

   • Snowflake as a Target in Rivery: This documentation offers guidance on using Snowflake as a Target with Rivery, including best practices and troubleshooting tips.
   • Schema Drift Management: Refer to this for understanding how Rivery manages schema drift and how you can ensure your data flows smoothly between schema updates.

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