RVR-SF-402
Issue summary
- This error code, RVR-SF-402, relates 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.
Action steps
To resolve the error, follow these 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 are 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 are correctly configured.
External references
- Data Integration Documentation on Snowflake Integration: Data Integration Snowflake Target
- Snowflake Reserved Words and Identifiers: Snowflake Documentation
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.