NOTE: The listed in this page reflect the raw data type of the converted column. Depending on the contents of the column, the Transformer Page may re-infer a different data type, when a dataset using this type of source is loaded.

Access/Read

Source Data TypeSupported

stringYString
bigintYInteger
double precisionYDecimal
boolYBoolean
dateYDateTime
timestampYDateTime

Notes:

Write/Publish

Create new table

NOTE: By default, the maximum length of values published to VARCHAR columns is 256 characters.As needed, this limit can be changed for multiple publication targets. For more information, see Configure Application Limits.

Redshift Data TypeNotes
Stringvarchar 
Integerbigint 
Decimaldouble precision 
Boolbool 
Datetimetimestamp

When you publish results from a job through the Export Results window to Redshift, all Datetime column values are written as String type.

Objectvarchar 
Arrayvarchar 

NOTE: Object and Array types are written in the supported format, if escaped commas and backslashes are unescaped in your recipe.

Append to existing table

If you are publishing to a pre-existing table, the following data type conversions apply:

In any table cell, a Y indicates that the append operation for that data type mapping is supported.

 StringIntegerDatetimeBoolFloatMapArray
TEXTYYYYYYY
VARCHARYYYYYYY
NVARCHARYYYYYYY
BPCHARYYYYYYY
NCHAR       
CHAR       
CHARACTER VARYINGYYYYYYY
SMALLINT       
INT2       
INTEGER       
INT       
INT4       
BIGINT Y     
INT8 Y     
DECIMAL Y  Y  
NUMERIC Y  Y  
DOUBLE_PRECISION Y  Y  
FLOAT Y  Y  
FLOAT4       
FLOAT8    Y  
REAL       
BOOL   Y   
BOOLEAN   Y   
TIMESTAMP  Y    
TIMESTAMPTZ  Y