Page tree

Trifacta SaaS


Contents:

   

Contents:


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

Write/Publish

Create new table

NOTE: By default, the maximum length of values published to VARCHAR columns is 256 characters.

Trifacta Data Type

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:

  • Columns: Trifacta data types
  • Rows: Target table data types

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    

This page has no comments.