Welcome to Microsoft Q&A platform and thanks for posting your question here.
Based on the error message you provided, it seems that the issue is related to the data type of the 'RAW' column in your Snowflake sink. The error message states that "Any type not supported for column 'RAW'". This means that the data type of the 'RAW' column is not compatible with the data type of the input data.
To troubleshoot this issue, you can try the following steps:
- Check the data type of the 'RAW' column in your Snowflake sink. Make sure that it is compatible with the data type of the input data.
- Check if there are any changes made to the input data schema or the Snowflake sink schema. If there are any changes, make sure that they are compatible with each other.
- Check if there are any null values in the input data. If there are any null values, make sure that they are handled properly in the data flow.
- Check the status of your file and table connections in the data flow designer. In debug mode, select Data Preview on your source transformations to ensure that you can access your data.
- If everything looks correct in data preview, go into the Pipeline designer and put your data flow in a Pipeline activity. Debug the pipeline for an end-to-end test.
Reference:
https://learn.microsoft.com/en-us/azure/data-factory/data-flow-troubleshoot-guide
I hope this helps! Let me know if you have any other questions.