Problem Summary: Workaround Redshift Reserve Words and Permissions
Description:
If you have a column name that is a Redshift reserved word, this rather unhelpful error message comes out.
Answer:
The only way to fix it is to remap the offending column name in HVR and change the column name on the target to not be a reserved word.