RVR-SF-402

1. Issue Summary

   • This error code, RVR-SF-402, is related to the ingestion of a dataframe into Snowflake via Data Integration. This likely indicates a problem during the data transfer or load operation from Data Integration to Snowflake. Initial diagnosis suggests potential issues with data compatibility, column naming, or Snowflake connection settings.

2. Action Steps:

   • Check Column Names: Ensure that the column names in your dataframe do not contain special characters or spaces. Snowflake does not allow the character "." in header columns, so rename them if necessary.
   • Verify Data Types: Confirm that the data types in your dataframe are compatible with the expected data types in Snowflake. Refer to the Snowflake to Data Integration data type mapping to ensure compatibility.
   • Review Permissions: Validate that the Snowflake credentials used in Data Integration have the necessary permissions for the Snowflake database, schema, and warehouse settings.
   • Check Data Encoding: If your dataframe contains special or non-English characters, ensure they're properly handled or encoded according to Snowflake's requirements.
   • Snowflake Connection: Double-check the connection settings and credentials for Snowflake in Data Integration to make sure they're correctly configured.

3. External References:

   • Data Integration Documentation on Snowflake Integration: Data Integration Snowflake Target
   • Snowflake Reserved Words and Identifiers: Snowflake Documentation

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