Error SQLFetch: [Amazon][Support] (40481) Invalid data format for '17-05-24'.

[lindbergh]

Attempting to pull data from Amazon Redshift and ran into the following error. The workflow previously worked.

[lindbergh · Accepted solution]

The issue was with the data. Someone put "0017" as the year.

[mattagone]

I'm having a similar issue but I don't have write access to the source data. I'd also love to be able to solve this without unchecking the header box, bringing everything in as Vstrings and having to rename a few dozen columns.