Amazon Redshift lookups in mappings
In a mapping, you can configure a Lookup transformation to represent 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.
Note: Amazon Redshift Connector does not support un-connected lookup transformation.