Page tree


Outdated release! Latest docs are Release 8.7: Redshift Data Type Conversions

   

NOTE: The Trifacta® data types 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

Trifacta data type

stringYString
bigintYInteger
double precisionYDecimal
boolYBoolean
dateYDateTime
timestampYDateTime

Export

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.

Trifacta Data Type

Redshift Data TypeNotes
Stringvarchar 
Integerbigint 
Decimaldouble precision 
Boolbool 
Datetimevarchar 
Objectvarchar 
Arrayvarchar 

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

This page has no comments.