Consider the following rules and guidelines when you use synchronization tasks for Amazon Redshift sources and targets:
•If you use multiple Amazon Redshift source objects in a synchronization task, the Refresh Fields option in the Field Mapping tab does not display the metadata for the source objects. You can save and run the task, but the task fails at run time. Hence, you must create a new synchronization task with a single source object, or use the mapping task.
•Do not use single quotes in the WHERE clause of a filter or query.