Amazon Redshift Lookups in Data Synchronization Tasks
When you configure field mappings in a Data Synchronization task, you can create a lookup to an Amazon Redshift object.
When you use an Amazon Redshift object as a lookup, you need to configure the Amazon S3 bucket name in Amazon Redshift properties.
When you use a cache lookup with Amazon Redshift connection, the lookup condition is ignored if the lookup condition contains a NULL value.