I am parsing a CSV to send out email reminders.
I have a scheduled job which emails me the CSV every day via Metabase. I set the encoding to UTF-8, but got error: Error parsing CSV file: Invalid byte sequence in UTF-8 in line 1
If I change the encoding to US-ASCII, it is giving error:"\x89" on US-ASCII
If I download the CSV on my Mac and manually run the recipe, it works fine. Has anyone faced this issue before?