I am unable to load a csv into a Snowflake Table via Matillion. The job throws an error as Invalid UTF8 detected in String. I have also tried to change the encoding type as ISO88591 (after i googled the error) but still unable to make the job run successfully. Any leads on what could be the issue?
@Akshay - Not sure which operating system the files are on, but if they are on Linux/Unix you may want to try a grep to see find the invalid UTF8 characters and see if they are junk or actual data. This Stack Overflow has an example: https://stackoverflow.com/questions/29465612/how-to-detect-invalid-utf8-unicode-binary-in-a-text-file.
Had the same issue just now and switching to the ISO 88591 encoding type worked.