The Amazon Redshift data types are the names and aliases that represent how the Data Integration Service stores the data types.
Super
Consider the following guidelines for data that contains the super data type:
You cannot condition in a simple filter or an uncached lookup for the super data type columns.
By default, the precision of the super data type is 256. If you do not set the precision correctly in the mapping, the mapping fails due to data truncation or target overflow.
When you map the following data types to the super data type in the target, the COPY command fails:
char
varchar
date
time
timestamp
timestamptz
The issue occurs because the super column in a Amazon Redshift table always expects the string data to be enclosed within double quotes while loading the data using COPY command. When you map the Char and Varchar data types to the Super data type in the target, ensure that the incoming data contains double quotes (").